|
-
October 20th, 2004, 12:42 AM
#1
 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.
R. Thomas
"Be anxious for nothing, but in everything by prayer and supplication, with thanksgiving, let your requests be made know to God; and the peace of God, which surpasses all understanding, will guard your hearts and minds through Christ Jesus."Philippians 4:6-7
"Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
