<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False"
AllowPaging="True"
OnPageIndexChanging="GridView1_PageIndexChanging">
Code in C#
protected void BindProducts()
{
string cs =@"path";
cn = new SqlConnection(cs);
cn.Open();
DataSet ds = new DataSet();
string k = "select * from student";
SqlDataAdapter adp = new SqlDataAdapter (k,cn);
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindProducts();
}
No comments:
Post a Comment