fecthing rows between 1 to 1000 to datatble.

tusharkale · August 8th, 2008, 02:57 PM

Hi,

I have dataset with 3 datatables.
datatable1,datatable2 and datatable3

Datatable1 contains 20000 records.

Now I want to fetch rows between 1 and 1000 only in datatable2
and from 1001 to 2000 in datatable3.

How can I do that?

Any help/tutorial on this would be a great help

Thanks

robzyc · August 8th, 2008, 03:25 PM

Well there are numerous ways of doing it, you could filter on the server before it gets to the DataSet, iterate through and read the data from the tables 1 row at a time, you could lay a view over the top of the table to filter..

My first question is why retrieve the data from the DataSet and not filter before it gets there? (i.e. at the server?)
Only 1000 records from a 20000 record DataSet seems like an awful amount of memory to waste...

Rob
http://cantgrokwontgrok.blogspot.com

samjudson · August 9th, 2008, 02:35 AM

You don't mention what database you are using. This would have been quite helpful seeing as your question is basically a database question.

If you are using SQL Server 2005 or greater then you can use the row_number() function:

http://msdn.microsoft.com/en-us/library/ms186734.aspx

If you are using MySql then you can use the LIMIT keyword

http://dev.mysql.com/doc/refman/5.0/en/select.html

If you are using Oracle then there is ROWNUM.

/- Sam Judson : Wrox Technical Editor -/