ASP.NET

private DataSet GetData()<br />
{<br />
  SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
  SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM Categories", myConnection);<br />
<br />
 DataSet ds = new DataSet();<br />
 ad.Fill(ds);<br />
 return ds; <br />
}<br />

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" OnSorting="GridView1_Sorting"><br />
</asp:GridView><br />

<br />
public SortDirection GridViewSortDirection<br />
{<br />
 get<br />
 {<br />
  if (ViewState["sortDirection"] == null)<br />
  ViewState["sortDirection"] = SortDirection.Ascending;<br />
  return (SortDirection) ViewState["sortDirection"]; <br />
 }<br />
<br />
 set { ViewState["sortDirection"] = value; } <br />
}<br />

<br />
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)<br />
{<br />
string sortExpression = e.SortExpression;<br />
if (GridViewSortDirection == SortDirection.Ascending)<br />
{<br />
 GridViewSortDirection = SortDirection.Descending;<br />
 SortGridView(sortExpression, DESCENDING);<br />
}<br />
else<br />
{<br />
 GridViewSortDirection = SortDirection.Ascending;<br />
 SortGridView(sortExpression, ASCENDING); <br />
} <br />
}<br />

<br />
private void SortGridView(string sortExpression,string direction)<br />
{<br />
 // You can cache the DataTable for improving performance<br />
 DataTable dt = GetData().Tables[0]; <br />
 DataView dv = new DataView(dt); <br />
 dv.Sort = sortExpression + direction; <br />
 GridView1.DataSource = dv;<br />
 GridView1.DataBind(); <br />
}<br />

<br />
protected void UploadBtn_Click(object sender, EventArgs e)<br />
{<br />
 if (FileUpLoad1.HasFile)<br />
 {<br />
   FileUpLoad1.SaveAs(@"C:\temp\" + FileUpLoad1.FileName);<br />
   Label1.Text = "File Uploaded: " + FileUpLoad1.FileName ;<br />
 }<br />
 else<br />
   Label1.Text = "No File Uploaded.";<br />
}<br />

DuplicateEmail: The e-mail address already exists in the database for the application.  <br />
 DuplicateProviderUserKey: The provider user key already exists in the database for the application.  <br />
 DuplicateUserName: The user name already exists in the database for the application.  <br />
 InvalidAnswer: The password answer is not formatted correctly.  <br />
 InvalidEmail: The e-mail address is not formatted correctly.  <br />
 InvalidPassword: The password is not formatted correctly.  <br />
 InvalidProviderUserKey: The provider user key is of an invalid type or format.  <br />
 InvalidQuestion: The password question is not formatted correctly.  <br />
 InvalidUserName: The user name was not found in the database.  <br />
 ProviderError: The provider returned an error that is not described by other MembershipCreateStatus: enumeration values.  <br />
 Success: The user was successfully created.  <br />
 UserRejected: The user was not created, for a reason defined by the provider 

<br />
public void CreateUser_OnClick(object sender, EventArgs args)<br />
{<br />
  // Create new user and retrieve create status result.<br />
<br />
  MembershipCreateStatus status;<br />
  string passwordQuestion = "";<br />
  string passwordAnswer = "";<br />
<br />
  if (Membership.RequiresQuestionAndAnswer)<br />
  {<br />
    passwordQuestion = PasswordQuestionTextbox.Text;<br />
    passwordAnswer = PasswordAnswerTextbox.Text;<br />
  }<br />
<br />
  try<br />
  {<br />
    MembershipUser newUser = Membership.CreateUser(UsernameTextbox.Text, PasswordTextbox.Text,EmailTextbox.Text, passwordQuestion,                                                   passwordAnswer, true, out status);<br />
    if (newUser == null)<br />
    {<br />
      Msg.Text = GetErrorMessage(status);<br />
    }<br />
    else<br />
    {<br />
      Response.Redirect("login.aspx");<br />
    }<br />
  }<br />
  catch<br />
  {<br />
    Msg.Text = "An exception occurred creating the user.";<br />
  }<br />
}<br />
<br />
public string GetErrorMessage(MembershipCreateStatus status)<br />
{<br />
   switch (status)<br />
   {<br />
      case MembershipCreateStatus.DuplicateUserName:<br />
        return "Username already exists. Please enter a different user name.";<br />
<br />
      case MembershipCreateStatus.DuplicateEmail:<br />
        return "A username for that e-mail address already exists. Please enter a different e-mail address.";<br />
<br />
      case MembershipCreateStatus.InvalidPassword:<br />
        return "The password provided is invalid. Please enter a valid password value.";<br />
<br />
      case MembershipCreateStatus.InvalidEmail:<br />
        return "The e-mail address provided is invalid. Please check the value and try again.";<br />
<br />
      case MembershipCreateStatus.InvalidAnswer:<br />
        return "The password retrieval answer provided is invalid. Please check the value and try again.";<br />
<br />
      case MembershipCreateStatus.InvalidQuestion:<br />
        return "The password retrieval question provided is invalid. Please check the value and try again.";<br />
<br />
      case MembershipCreateStatus.InvalidUserName:<br />
        return "The user name provided is invalid. Please check the value and try again.";<br />
<br />
      case MembershipCreateStatus.ProviderError:<br />
        return "The authentication provider returned an error. Please verify your entry and try again. If the problem persists, please contact your system administrator.";<br />
<br />
      case MembershipCreateStatus.UserRejected:<br />
        return "The user creation request has been canceled. Please verify your entry and try again. If the problem persists, please contact your system administrator.";<br />
<br />
      default:<br />
        return "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator.";<br />
   }<br />
}<br />
<br />