By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,391 Members | 1,387 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,391 IT Pros & Developers. It's quick & easy.

DataGrid Paging doesnt page!

P: n/a
Dee
Hi
The paging numbers of my DataGrid dont actually page. What can be the cause?
Everyting else seems to work.
Thanks
Dee
Nov 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
What code have you entered into the PageIndexChanged event handler?
"Dee" <dee@home> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi
The paging numbers of my DataGrid dont actually page. What can be the
cause?
Everyting else seems to work.
Thanks
Dee

Nov 19 '05 #2

P: n/a
Dee
Thanks Scott,
I dodnt know I needd to handle that event.
It workd now. I added:

DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()

It's intersting that the paging works without thr DataBind() call but have
to click on the page TWICE!
"Scott M." <s-***@nospam.nospam> wrote in message
news:ui**************@TK2MSFTNGP09.phx.gbl...
What code have you entered into the PageIndexChanged event handler?
"Dee" <dee@home> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi
The paging numbers of my DataGrid dont actually page. What can be the
cause?
Everyting else seems to work.
Thanks
Dee


Nov 19 '05 #3

P: n/a
HI
set the property of datagrid to AllowPaging="True"
then
on the grid_page index changed event
write the code

grid.CurrentPageIndex = e.NewPageIndex ;

and then write the code for connecting to the datbase
"Dee" <dee@home> wrote in message news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi
The paging numbers of my DataGrid dont actually page. What can be the cause?
Everyting else seems to work.
Thanks
Dee

Nov 19 '05 #4

P: n/a
You must ALWAYS call the databind method after making any kind of change to
the datagrid that affects what data the grid is showing.

The reason you'd have to click the pager twice without the extra databind
call is that the grid uses ViewState to remember, not only the data that is
was showing, but also other "state" information such as what page of data
was showing, what sort order was in effect, what row was being edited or was
selected, etc.

Without the databind call, the grid is bound to its data in Page_Load
(that's where you do have a databind call, right?) and the first click sets
the page correctly but doesn't update the grid with the new page of data
because no databind call took place AFTER setting the page to show, the
second click causes the grid to bind to its data in Page_Load as well, but
now the grid is "remembering" via ViewState what page of data to display
BEFORE the databind call takes place.

In general, your page load event handler should look like this:

datagrid.datasource = someDataSource
If Not IsPostBack Then
datagrid.databind
End If

and then at the end of EACH and EVERY datagrid event handler where the data
would change in some way (sortCommand, PageIndexChanged, EditCommand,
DeleteCommand, SortCommand, CancelCommand)

datagrid.databind

"Dee" <dee@home> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
Thanks Scott,
I dodnt know I needd to handle that event.
It workd now. I added:

DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()

It's intersting that the paging works without thr DataBind() call but have
to click on the page TWICE!
"Scott M." <s-***@nospam.nospam> wrote in message
news:ui**************@TK2MSFTNGP09.phx.gbl...
What code have you entered into the PageIndexChanged event handler?
"Dee" <dee@home> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> Hi
> The paging numbers of my DataGrid dont actually page. What can be the
> cause?
> Everyting else seems to work.
> Thanks
> Dee
>
>



Nov 19 '05 #5

P: n/a
Dee
Wow
Great explanation! Thanks very much.
Dee

"Scott M." <s-***@nospam.nospam> wrote in message
news:#b**************@TK2MSFTNGP10.phx.gbl...
You must ALWAYS call the databind method after making any kind of change to the datagrid that affects what data the grid is showing.

The reason you'd have to click the pager twice without the extra databind
call is that the grid uses ViewState to remember, not only the data that is was showing, but also other "state" information such as what page of data
was showing, what sort order was in effect, what row was being edited or was selected, etc.

Without the databind call, the grid is bound to its data in Page_Load
(that's where you do have a databind call, right?) and the first click sets the page correctly but doesn't update the grid with the new page of data
because no databind call took place AFTER setting the page to show, the
second click causes the grid to bind to its data in Page_Load as well, but
now the grid is "remembering" via ViewState what page of data to display
BEFORE the databind call takes place.

In general, your page load event handler should look like this:

datagrid.datasource = someDataSource
If Not IsPostBack Then
datagrid.databind
End If

and then at the end of EACH and EVERY datagrid event handler where the data would change in some way (sortCommand, PageIndexChanged, EditCommand,
DeleteCommand, SortCommand, CancelCommand)

datagrid.databind

"Dee" <dee@home> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
Thanks Scott,
I dodnt know I needd to handle that event.
It workd now. I added:

DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()

It's intersting that the paging works without thr DataBind() call but have to click on the page TWICE!
"Scott M." <s-***@nospam.nospam> wrote in message
news:ui**************@TK2MSFTNGP09.phx.gbl...
What code have you entered into the PageIndexChanged event handler?
"Dee" <dee@home> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> Hi
> The paging numbers of my DataGrid dont actually page. What can be the
> cause?
> Everyting else seems to work.
> Thanks
> Dee
>
>



Nov 19 '05 #6

P: n/a
No problem. Good luck.
"Dee" <dee@home> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Wow
Great explanation! Thanks very much.
Dee

"Scott M." <s-***@nospam.nospam> wrote in message
news:#b**************@TK2MSFTNGP10.phx.gbl...
You must ALWAYS call the databind method after making any kind of change

to
the datagrid that affects what data the grid is showing.

The reason you'd have to click the pager twice without the extra databind
call is that the grid uses ViewState to remember, not only the data that

is
was showing, but also other "state" information such as what page of data
was showing, what sort order was in effect, what row was being edited or

was
selected, etc.

Without the databind call, the grid is bound to its data in Page_Load
(that's where you do have a databind call, right?) and the first click

sets
the page correctly but doesn't update the grid with the new page of data
because no databind call took place AFTER setting the page to show, the
second click causes the grid to bind to its data in Page_Load as well,
but
now the grid is "remembering" via ViewState what page of data to display
BEFORE the databind call takes place.

In general, your page load event handler should look like this:

datagrid.datasource = someDataSource
If Not IsPostBack Then
datagrid.databind
End If

and then at the end of EACH and EVERY datagrid event handler where the

data
would change in some way (sortCommand, PageIndexChanged, EditCommand,
DeleteCommand, SortCommand, CancelCommand)

datagrid.databind

"Dee" <dee@home> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
> Thanks Scott,
> I dodnt know I needd to handle that event.
> It workd now. I added:
>
> DataGrid1.CurrentPageIndex = e.NewPageIndex
> DataGrid1.DataBind()
>
> It's intersting that the paging works without thr DataBind() call but have > to click on the page TWICE!
>
>
> "Scott M." <s-***@nospam.nospam> wrote in message
> news:ui**************@TK2MSFTNGP09.phx.gbl...
>> What code have you entered into the PageIndexChanged event handler?
>>
>>
>> "Dee" <dee@home> wrote in message
>> news:%2****************@TK2MSFTNGP09.phx.gbl...
>> > Hi
>> > The paging numbers of my DataGrid dont actually page. What can be
>> > the
>> > cause?
>> > Everyting else seems to work.
>> > Thanks
>> > Dee
>> >
>> >
>>
>>
>
>



Nov 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.