Filter rows in a DataSet

[Hardy Wang]

Hi all:
I have a DataSet populated with values. How can I return
ds.Tables[0].DefaultView's records from a starting number to a ending
number?
For example, I have 100 records in the DefaultView, but I just need
records from 25th to 50th.

Thanks for any suggestion!

--

WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy

[Ralph Gerbig]

hi,

use a for-loop and start at 25 and end at 50 e.g (not tested code)

for (int = 0; i<=50;i++)
{
DataSet.Tables[i].DefaultView;
}

--
Mit freundlichen Gruessen - Regards

Ralph Gerbig
ik********@web. de
www.ralphgerbig.de.vu

Because of some spam isues I'm not able
to response to all e-mail requests.

[Hardy Wang]

Thanks!
But not loop through DataTables.
What I need are records within a DataView from record 25 to record 50.
"Ralph Gerbig" <ik********@web .de.nospam> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

hi,

use a for-loop and start at 25 and end at 50 e.g (not tested code)

for (int = 0; i<=50;i++)
{
DataSet.Tables[i].DefaultView;
}

--
Mit freundlichen Gruessen - Regards

Ralph Gerbig
ik********@web. de
www.ralphgerbig.de.vu

Because of some spam isues I'm not able
to response to all e-mail requests.

[William Ryan]

If you are using the DefaultView and you don't have a filter condition, then
Ralph's implementation will work. Assuming that you only want to work with
a DataView, you can use the same logic, just change the reference from
DataSet.Table to DataView. In general, I prefer an enumerator like this,
but it's 6 of one half dozen of the other but you can use a for loop for a
better implementation for this specific issue...

for(int i = 25; i<=50; i++){
Debug.WriteLine (row[i];
}

If you have a column who's number corresponds to row value, then you can use
something like

DataRow[] dRows = ds.Tables[0].Select("ID > 25 and ID < 51) //Since you are
using Defaultview, this should work as well even if you don't use the view
per se.

--This is the enumerated example, just for reference b/c it's the better
solution here.
DataView v = new DataView(ds.Tab les[0].DefaultView);

DataRowView dro;

IEnumerator myEnum = v.GetEnumerator ();
int x = 0;
while(myEnum.Mo veNext()){
//Check for the row position
if(x >25 and x < 51){
Debug.WriteLine (
}
i++
}
"Hardy Wang" <ha********@mar ketrend.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi all:
I have a DataSet populated with values. How can I return
ds.Tables[0].DefaultView's records from a starting number to a ending
number?
For example, I have 100 records in the DefaultView, but I just need
records from 25th to 50th.

Thanks for any suggestion!

--

WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy

[Manoj G [MVP]]

You can create a new DataColumn (say RowNum) and set its AutoIncrement
property to true and have its AutoIncrementSe ed and AutoIncrementSt ep as 1.
You can add this column to the Datatable b4 you do a Fill. To keep things
simple, select a column name that does not clash with the result set schema.
Finally, after a DataView is created from the DataTable, you can use a
FilterExpressio n likeRowNum >= 25 and RowNum <= 50.
I am not sure if a simpler approach is possible.

--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

"Hardy Wang" <ha********@mar ketrend.com> wrote in message
news:#j******** ******@TK2MSFTN GP10.phx.gbl...

Hi all:
I have a DataSet populated with values. How can I return
ds.Tables[0].DefaultView's records from a starting number to a ending
number?
For example, I have 100 records in the DefaultView, but I just need
records from 25th to 50th.

Thanks for any suggestion!

--

WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy