What Am I missing?

[TomACMan]

Successfully wrote some VB Web Form sample code that displays a custom paging datagrid. "http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassvirtualitemcounttopic.asp"

The data is internally generated. When I try to substitute a SQLdatareader to populate the table, my sqldtatareader instance is lost after the Postback to goto the next page. I only load the table at the inital page load. IF I am not doing something wrong, whats the point of paging if you have to reload the data AND always load the same table? Would a dataset persist after the postback?

[Mike Hildner]

Not sure about what is going on with all that, but datasets do seem to work fine.

[TomACMan]

I have just rewritten to use a Oledatadapter, am using a datatable, same thing:

Object reference not set to an instance of an object.

It just seems to me that once a postback is done, I lose the dataset instance. Is this right?

[Mike Hildner]

How about a little code? That Object Reference business, at least in my case, means I've done something wrong.

[Tom Yaz]

Hi, I am TomACMan(I have two logins, 1 for work and one for home) I am at work now, and my code is on my other computer.

I will try to regen it here and post

BTW I got issues with trying to do a simple load, see my other post.

Thanks

[Tom Yaz]

I found out he magic thing to do is to create a session variable to save the dataset. Works fine now. But would hate to store all that data in memeory. Most efficient would be to load only what you need--Page at a time SQL reads. need to figure that out next.

[Tom Yaz]

I found out he magic thing to do is to create a session variable to save the dataset. Works fine now. But would hate to store all that data in memeory. Most efficient would be to load only what you need--Page at a time SQL reads. need to figure that out next.