gridview control and paging asp.net

Question

I have a gridview which gets populated in the backend code. I am trying to implement paging now, but when I am trying my way, I am getting nothing. Here is my piece of code:

public void generateTable() { conn.ConnectionString = connString; SqlCommand comm = new SqlCommand("ViewBusinessInfo", conn); comm.CommandType = CommandType.StoredProcedure; comm.CommandTimeout = 2; try { conn.Open(); SqlDataReader rdr = comm.ExecuteReader(); if (rdr.HasRows) { gvAssociation.DataSource = rdr; gvAssociation.DataBind(); gvAssociation.AllowPaging = true; gvAssociation.PageSize = 10; rdr.Close(); } else { lblResult.Text = "No businesses found."; lblResult.Visible = true; } } catch { } finally { conn.Close(); } }

Can anyone advice what am I doing wrong and I can't get the paging in the gridview? Thx in advance, Laziale

For starters, you can probably change catch to catch(Exception ex) so you can see if you are actually getting an exception. An empty catch block will hide your exception. — Bryan Crosby
– Bryan Crosby, Commented Nov 21, 2011 at 17:25

Brian · Accepted Answer · 2013-04-12 21:49:24Z

The allowPaging and pagesize property of the gridview can be added in the .aspx, where the gridview tag is present.

<asp:GridView ID="gridView" OnPageIndexChanging="gridView_PageIndexChanging" AllowPaging="True" pagesize="10" runat="server" />

Additionally, to make the paging links work, you have to add the following code in the gridview_PageIndexChanging event of the gridview:

protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { gridView.PageIndex = e.NewPageIndex; gridView.DataBind(); }

Hope this is helpful.

that was not the problem. The problem was that you cannot use a DataReader to populate a GridView if paging is enabled.
Yes you are right...it just skipped my mind. With DATAREADER as DATASOURCE, SERVER SIDE PAGING IS NOT ALLOWED. One will have to use DATAADAPTER-DATASET

slfan · Accepted Answer · 2011-11-21 18:04:22Z

You cannot use paging with a DataReader. You should fill your data into a Dataset or a Datatable using a DataAdapter. Something like this:

 SqlCommand myCommand = new SqlCommand("ViewBusinessInfo", conn); SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand)) DataTable dt = new DataTable(); myAdapter.Fill(dt); ...

drdwilcox · Accepted Answer · 2011-11-21 17:25:55Z

0

Set the AllowPaging and PageSize declaratively, or do so before you call DataBind().

answered Nov 21, 2011 at 17:25

drdwilcox

3,96121 silver badges19 bronze badges

1 Comment

Laziale Over a year ago

I am getting an error: The data source does not support server-side data paging

Collectives™ on Stack Overflow

gridview control and paging asp.net

3 Answers 3

2 Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Linked

Related