DataTable.DefaultView

[sandman]

I'm trying to filter the data as I load a dataset, so I
set the RowFilter property of the DataTable's
DefaultView. But the dataset still contains all of the
records. Is the row filter (and dataviews) meant to be
used only for accessing data rather than loading the
dataset? Maybe I'm using it wrong. Why else would it load
the entire table? Do I have to actually change the
SelectCommand in the DataAdapter in order to limit what
gets loaded in DataSet?

[Pramod Anchuparayil]

Try reading it this way

foreach(DataRowView drv in dv)
{ System.Data.DataRow dr = drv.Row;
..... <more..code>
}

Pramod
"sandman" <sa*********@yahoo.com> wrote in message
news:04****************************@phx.gbl...

I'm trying to filter the data as I load a dataset, so I
set the RowFilter property of the DataTable's
DefaultView. But the dataset still contains all of the
records. Is the row filter (and dataviews) meant to be
used only for accessing data rather than loading the
dataset? Maybe I'm using it wrong. Why else would it load
the entire table? Do I have to actually change the
SelectCommand in the DataAdapter in order to limit what
gets loaded in DataSet?

[MP]

Yes...
your data adapter is the one that fill the dataset
the dataview is for going filter, sort, allow... and back

"sandman" <sa*********@yahoo.com> wrote in message
news:8c****************************@phx.gbl...

That wasn't my question. The dataview works fine, and I'm
using it just as you described. But when I was debugging,
I was surprised to find all the records were in the
dataset. What I'm trying to figure out is whether the
DefaultView has anything to do with what actually gets
loaded in the DataSet or if it's just meant to be used to
screen out a subset of the whole table?

-----Original Message-----
Try reading it this way

foreach(DataRowView drv in dv)
{ System.Data.DataRow dr = drv.Row;
..... <more..code>
}

Pramod
"sandman" <sa*********@yahoo.com> wrote in message
news:04****************************@phx.gbl...

I'm trying to filter the data as I load a dataset, so I
set the RowFilter property of the DataTable's
DefaultView. But the dataset still contains all of the
records. Is the row filter (and dataviews) meant to be
used only for accessing data rather than loading the
dataset? Maybe I'm using it wrong. Why else would it load the entire table? Do I have to actually change the
SelectCommand in the DataAdapter in order to limit what
gets loaded in DataSet?

.