Click here to Skip to main content
15,906,463 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I use a gridview for two bindings in asp.net.
There are plenty of images in each of these bindings.
I want to page the gridview.
I only know how to use single BindGrid, but in my case they are double.
What code should I use in the "protected void gvImages_PageIndexChanging" method?
C#
protected void ddlName1_SelectedIndexChanged(object sender, EventArgs e)
{
    BindGrid1();
}
protected void ddlName2_SelectedIndexChanged(object sender, EventArgs e)
{
    BindGrid2();
}
private void BindGrid1()
{
    MySqlConnection con = new MySqlConnection(constr);
    MySqlCommand cmd = new MySqlCommand("SELECT * FROM rasmlar where Rasm_ID in ('" + String.Join("','", getImage_ID1().ToArray()) + "')", con);
    MySqlDataAdapter da = new MySqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    gvImages.DataSource = dt;
    gvImages.DataBind();
}
private void BindGrid2()
{
    MySqlConnection con = new MySqlConnection(constr);
    MySqlCommand cmd = new MySqlCommand("SELECT * FROM rasmlar where Rasm_ID in ('" + String.Join("','", getImage_ID2().ToArray()) + "')", con);
    MySqlDataAdapter da = new MySqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    gvImages.DataSource = dt;
    gvImages.DataBind();
}
protected void gvImages_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
   gvImages.PageIndex = e.NewPageIndex;

}
Posted
Updated 20-Sep-15 2:58am
v2
Comments
Why same codes in different methods? What's wrong in the paging event?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900