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]

Still no-go


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";