DataView RowFilter

[Ryan Moore]

I have a dataset (called adset) which has a column called "Large" which is
either an integer 0 or 1.

I am creating 2 dataviews, one which should display the 1's and one which
should display the 0's using the following code:

DataView largeview = new DataView();
largeview.RowFilter = "Large=1";
largeview.Table = adSet1.Tables[0];
DataView smallview = new DataView();
smallview.RowFilter = "Large=0";
smallview.Table = adSet1.Tables[0];

but, for some reason, adSet, largeview, and smallview all have 8 rows.....
what am I doing wrong?
thnx

[Raterus]

try this..telling the dataview about the table you are using before the rowfilter

DataView largeview = new DataView(adSet1.Tables[0]);
largeview.RowFilter = "Large=1";

DataView smallview = new DataView(adSet1.Tables[0]);
smallview.RowFilter = "Large=0";

"Ryan Moore" <ry*******@hotmail.com> wrote in message news:ur**************@TK2MSFTNGP12.phx.gbl...

I have a dataset (called adset) which has a column called "Large" which is
either an integer 0 or 1.

I am creating 2 dataviews, one which should display the 1's and one which
should display the 0's using the following code:

DataView largeview = new DataView();
largeview.RowFilter = "Large=1";
largeview.Table = adSet1.Tables[0];
DataView smallview = new DataView();
smallview.RowFilter = "Large=0";
smallview.Table = adSet1.Tables[0];

but, for some reason, adSet, largeview, and smallview all have 8 rows.....
what am I doing wrong?
thnx

[Ryan Moore]

Still no-go
"Raterus" <ra*****@spam.org> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
try this..telling the dataview about the table you are using before the
rowfilter

DataView largeview = new DataView(adSet1.Tables[0]);
largeview.RowFilter = "Large=1";

DataView smallview = new DataView(adSet1.Tables[0]);
smallview.RowFilter = "Large=0";

"Ryan Moore" <ry*******@hotmail.com> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

I have a dataset (called adset) which has a column called "Large" which is
either an integer 0 or 1.

I am creating 2 dataviews, one which should display the 1's and one which
should display the 0's using the following code:

DataView largeview = new DataView();
largeview.RowFilter = "Large=1";
largeview.Table = adSet1.Tables[0];
DataView smallview = new DataView();
smallview.RowFilter = "Large=0";
smallview.Table = adSet1.Tables[0];

but, for some reason, adSet, largeview, and smallview all have 8 rows.....
what am I doing wrong?
thnx