Developer Forum

by ES » Fri, 06 Oct 2006 06:37:39

Is there a reasonable way to implement paging in a GridView control that's
bound to a DataSet rather than a SqlDataSource? What needs to be done?

Thanks

by **ReyN** » Fri, 06 Oct 2006 08:33:19

you don't have to change anything

paging will work in a GridView whether it's bound to SqlDataSource or a
DataSet

http://raven/aspxtreme/sys/web/ui/webcontrols/demos/gridviewdatasource.aspx

by **ReyN** » Fri, 06 Oct 2006 08:37:39

ooops I posted the wrong link that's in my local host :) so here goes

http://www.yqcomputer.com/

by ES » Fri, 06 Oct 2006 22:50:09

his is a multi-part message in MIME format.

Thanks for your reply.
I initially just bound the GridView to the DataSet, and ran it. It worked fine until I clicked a page number. At that point it gave me an error about the OnPageIndexChanging being raised but not handled, so I implemented it as such:
protected void gvSrchMatch_PageIndexChanging(object sender, GridViewPageEventArgs e) {

gvSrchMatch.PageIndex = e.NewPageIndex;

}

This runs, but does not page correctly. The help file on this event speaks of canceling the move to the next page, but not actually making the control move to the next page.

Interestingly, your demo crashes when you click a page link...

Elton

"ReyN" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Thanks for your reply.</DIV>
<DIV>I initially just bound the GridView to the DataSet,
and ran it. It worked fine until I clicked a page number. At that
point it gave me an error about the OnPageIndexChanging being raised but not
handled, so I implemented it as such:</DIV>
<DIV>
protected void
gvSrchMatch_PageIndexChanging(object sender, GridViewPageEventArgs e)
{

gvSrchMatch.PageIndex = e.NewPageIndex;
}
This runs, but does not page correctly. The
help file on this event speaks of canceling the move to the next page, but not
actually making the control move to the next page.
Interestingly, your demo crashes when you click a
page link...
Elton</DIV>
<DIV>"ReyN" <<A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>> wrote
in message <A
href="news: XXXX@XXXXX.COM ">news: XXXX@XXXXX.COM </A>...</DIV>>
 > ooops I posted the wrong link that's in my local host :) so here
goes > > <A
href="http://authors.aspalliance.com/aspxtreme/sys/web/ui/webcontrols/demos/gridviewdatasource.aspx">http://authors.aspalliance.com/aspxtreme/sys/web/ui/webcontrols/demos/gridviewdatasource.aspx</A> ></BODY></HTML>

by **ReyN** » Sat, 07 Oct 2006 18:11:26

you have to rebind the GridView after setting the PageIndex in the
event handler

by ES » Thu, 12 Oct 2006 02:36:49

This is a multi-part message in MIME format.

Thanks, I repopulated the grid, set the index, and bound and it appears to work. I think caching the dataset might make it more efficient. It seems wrong to get the whole dataset each time...

protected void gvSrchMatch_PageIndexChanging(object sender, GridViewPageEventArgs e) {

gvSrchMatch.DataSource = PvrProfile.GetMatches(txtSrchLastName.Text);

gvSrchMatch.PageIndex = e.NewPageIndex;

gvSrchMatch.DataBind();

}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Thanks, I repopulated the grid, set
the index, and bound and it appears to work. I think caching the dataset
might make it more efficient. It seems wrong to get the whole dataset each
time...</DIV>
<DIV> </DIV>
<DIV>
protected void gvSrchMatch_PageIndexChanging(object sender, GridViewPageEventArgs e) {
 gvSrchMatch.DataSource =
PvrProfile.GetMatches(txtSrchLastName.Text);
 gvSrchMatch.PageIndex =
e.NewPageIndex;

gvSrchMatch.DataBind();
}</DIV>
<DIV> </DIV>
<DIV>"ReyN" <<A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>> wrote
in message <A

face="Courier New"

face="Courier New" size=2>...</DIV>>
 > you have to rebind the GridView after setting the PageIndex in
the > event handler ></BODY></HTML>

Developer Forum

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet

Paging In GridView bound to DataSet