chandu gummadi

chandu gummadi

  • NA
  • 67
  • 71.6k

GRIDVIEW SORTING

May 2 2013 2:37 AM
Hi friends iam implementing the gridview sorting in my application but sorting is not done for all rows.
it shows a error like "can not fine column name empname".

iam using bellow code
public void BindGVPasswordChange()
    {
        try
        {
            DataTable dt = new DataTable();
            Hashtable htnew = new Hashtable();
            htnew.Add("PwdId", 0);
            dt = _sec.getDataTable("Stp_UM_FillGV_Changepasswords", CommandType.StoredProcedure, htnew);
            if (dt.Rows.Count > 0)
            {
                DataView dv = dt.DefaultView;
                if (ViewState["SortDirection"] != null)
                {
                    sortDirection = ViewState["SortDirection"].ToString();
                }
                if (ViewState["SortExpression"] != null)
                {
                    sortExpression = ViewState["SortExpression"].ToString();
                    string sort = string.Concat(sortExpression, " ", sortDirection);
                    dv.Sort = string.Concat(sortExpression, " ", sortDirection);
                }
                GVChangePwd.DataSource = dv;
                GVChangePwd.DataSource = dt;
                GVChangePwd.DataBind();          
            }
            GVChangePwd.Visible = true;
        }
        catch (Exception ex)
        {
        }
    }


protected void GVChangePwd_Sorting(object sender, GridViewSortEventArgs e)
    {
        if (ViewState["SortDirection"] == null || ViewState["SortExpression"].ToString() != e.SortExpression)
        {
            ViewState["SortDirection"] = "ASC";
            GVChangePwd.PageIndex = 0;
        }
        else if (ViewState["SortDirection"].ToString() == "ASC")
        {
            ViewState["SortDirection"] = "DESC";
        }
        else if (ViewState["SortDirection"].ToString() == "DESC")
        {
            ViewState["SortDirection"] = "ASC";
        }
        ViewState["SortExpression"] = e.SortExpression;
        BindGVPasswordChange();

    }


please help me..

Answers (3)