Sorting and Paging not works in GridView

Question

Hi, I try to use a function to sort and paging, but doesn't works, in in the "design mode" appear the paging, but when I run the program, doesn't appear nothing.

and when I run it:

C#:

private string SortDirection  
        {  
            get { return ViewState["SortDirection"] != null ? ViewState["SortDirection"].ToString() : "ASC"; }  
            set { ViewState["SortDirection"] = value; }  
        }  
        private void BindGrid(string sortExpression = null)  
        {  
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;  
            using (SqlConnection con = new SqlConnection(constr))  
            {  
                using (SqlCommand cmd = new SqlCommand("SELECT distinct No_curso, Room, Idioma, Fecha_inicio, Fecha_final, Training, PMax from [Agregar_sesion]"))  
                {  
                    using (SqlDataAdapter sda = new SqlDataAdapter())  
                    {  
                        cmd.Connection = con;  
                        sda.SelectCommand = cmd;  
                        using (DataTable dt = new DataTable())  
                        {  
                            sda.Fill(dt);  
                            if (sortExpression != null)  
                            {  
                                DataView dv = dt.AsDataView();  
                                this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";  
  
                                dv.Sort = sortExpression + " " + this.SortDirection;  
                                GridView1.DataSource = dv;  
                            }  
                            else  
                            {  
                                GridView1.DataSource = dt;  
                            }  
                            GridView1.DataBind();  
                        }  
                    }  
                }  
            }  
        }  
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)  
        {  
            if (e.Row.RowType == DataControlRowType.DataRow)  
            {  
                SqlConnection con = new SqlConnection();  
                con.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;  
                con.Open();  
                GridView gv = (GridView)e.Row.FindControl("GridView2") ;  
                string curso = e.Row.Cells[1].Text.ToString();  
                SqlCommand cmd = new SqlCommand("SELECT distinct AgS.No_curso, AgS.Fecha_inicio, M.Num_empleado, M.Nombre,M.Leader From Agregar_sesion Ags, Maestro M WHERE  Ags.No_emp = M.Num_empleado and Ags.No_curso ='" + curso + "'",con);  
                SqlDataAdapter da = new SqlDataAdapter(cmd);  
                DataSet ds = new DataSet();  
                da.Fill(ds);  
                con.Close();  
                gv.DataSource = ds;  
                gv.DataBind();  
            }  
        }  
        protected void OnSorting(object sender, GridViewSortEventArgs e)  
        {  
            this.BindGrid(e.SortExpression);  
  
        }  
  
        protected void OnPageIndexChanging(object sender, GridViewPageEventArgs e)  
        {  
            GridView1.PageIndex = e.NewPageIndex;  
            this.BindGrid();  
        }  

HTML:

Answer 1

Hi @Anonymous ,
In your codes,you don't specify what field to sort by. So it will sort by the first field on default. I have changed the sort of No_curso and it works fine with Sorting. You could check your data.
Best regards,
Yijing Sun

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Anonymous ,
How many data in your datebase? I have run your codes and I have 11 records. It works fine.Your pagesize is 10. So,the records need more than 10 to show the paging.
Or do you have other codes?
My codes tested is like this:




Best regards,
Yijing Sun

---

If the answer is helpful, please click "Accept Answer" and upvote it

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.