How to pass GridView SortExpression to GridViewPageIndexChanging Event in ASP.Net

Amol111

SOLVED CLOSED ACTIVE ANSWERED
User: Amol111
Posted: on Nov 30, 2016 03:16 AM
Forum: Data Controls
Answer: 1
Views: 6491
Sample Code: Download

protected void Sorting(object sender, GridViewSortEventArgs e)
        {
            string[] SortOrder = ViewState["SortExpr"].ToString().Split(' ');
            if (SortOrder[0] == e.SortExpression)
            {
                if (SortOrder[1] == "ASC")
                {
                    ViewState["SortExpr"] = e.SortExpression + " " + "DESC";
                }
                else
                {
                    ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
                }
            }
            else
            {
                ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
            }
            GridVwPagingSorting.DataSource = Getdata();
            GridVwPagingSorting.DataBind();

protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
        {

protected void Page_Load(object sender, EventArgs e);

GridVwPagingSorting.PageIndex = e.NewPageIndex; DataView dvEmployee = Getdata(); GridVwPagingSorting.DataSource = dvEmployee; GridVwPagingSorting.DataBind(); }

how to pass ??

Download FREE API for Word, Excel and PDF in ASP.Net

Amol111

0 2

Reply
User: Amol111
Replied: on Nov 30, 2016 03:40 AM
Report

I am trying to maintain sorting expression values while paging event of Grid.

But it takes null value in Viewstate ["Sort Expression"].ToString(); it throws object value not set to an a instance of object exception.

private DataView Getdata()
        {
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
            {
                DataSet dsEmployee = new DataSet();
                string strSelectCmd = "SELECT [Emp_Name],[Emp_id],[Emp_job],[Emp_Dep],[Emp_Salary] FROM [employee]";
                SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn);
                da.Fill(dsEmployee, "Employee");
                DataView dvEmp = dsEmployee.Tables["Employee"].DefaultView;
                dvEmp.Sort = ViewState["SortExpr"].ToString();
                return dvEmp;    
            }
        }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to pass GridView SortExpression to GridViewPageIndexChanging Event in ASP.Net

Company

Explore

Follow us

Contact Us