title: How to sorting the gridview data
body: <p>See the below code, I am try to sorting Grid view data by calling function provided by the Microsoft vs 2008, but the paging is done well but the sorting process is not work, tell me where should i change the following code and yes i put grid view in updated penal,is there problem regarding to update penal? </p>
  
  <pre><code>protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  {
      GridView1.PageIndex = e.NewPageIndex;
      showData();
  }
  protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
  {
      try
      {
          SqlCommand cmd = new SqlCommand("showData", con);
          cmd.CommandType = CommandType.StoredProcedure;
          SqlDataAdapter da = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
          da.Fill(ds);
          if (ds.Tables[0] != null)
          {
  
              ds.Tables[0].DefaultView.Sort = e.SortExpression + " " + sortType(e.SortDirection);
              GridView1.DataSource = ds;
              GridView1.DataBind();
          }
      }
      catch (Exception ex)
      {
          Label1.Text = ex.ToString();
      }
  }
  
  
  private string sortType(SortDirection sortDirection)
  {
      string newSortDirection = String.Empty;
  
      switch (sortDirection)
      {
          case SortDirection.Ascending:
              newSortDirection = "DESC";
              break;
  
          case SortDirection.Descending:
              newSortDirection = "ASC";
              break;
      }
  
      return newSortDirection;
  }
  </code></pre>