Datagrid Development Discussion
Topic : I have a datagrid (ASP.NET) and i need to bind this datagrid to a Database table. the number of records to be bound are, say... 100,000 or more...
Agenda : How to achive this, while keeping the datafetching process very fast and the paging with out POSTBACK...
Idea: using some XSLT , XML, or something?
Adressing Issue : the issue of getting 100,000 or more data can be achieved by keeping a composite key and retriving only 10 records from database at a time to show in the datagrid and when the user clicks next or previous we can use that composite key to fetch the next batch of data. Makin it seem that all the data is in the datagrid but actually its still in the DB.
That is not a very big deal
Next Issue : the issue of paging without postback, that mean the data should all be out of the DB? or using the XSLT to pipe the data to the cliet and updata the datagrid?
Anybody would like to comment on this?
thanks and appreciate your time.