Row Filtering in dataset

[DBC User]

I have a data set which has a data table. This dataset is set as a
datasource for a display grid. Before I assign the data set to data
grid, I would like to elliminate some rows from the data table. How can
I do this?

I saw an example where I can identify the table and then apply the
select on the table. Which returns the data rows. Is there a way I can
remove the rows without doing this 2 step process of obtaining the data
row and then put the data row back in the table etc.,??

Thanks.

 

[Chris Fulstow]

Maybe try setting the SqlDataSource.FilterExpression property?
http://msdn2.microsoft.com/en-us/li...bcontrols.sqldatasource.filterexpression.aspx

 

[DBC User]

The original input is XML that I convert to DataSource. Any
suggestions?
Thanks.

 

[Chris Fulstow]

Ahhh, ok...
Maybe try setting the XmlDataSource.XPath property?
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource.xpath.aspx

 

[Dave Sexton]

Hi,

You can bind the grid to a DataView:

DataView view = new DataView(myDataTable);

// the following code does not modify the underlying DataTable
// it only provides a logical "view" of the data to which you can bind the grid
view.RowFilter = "Column1 = 'a value.'";

// Although we're assigning the DataView as the source and not the DataTable,
// you can still configure the grid in exactly the same way as you would for your DataTable.
// i.e. You can use the same column names for binding.
// (Internally, most framework controls switch to a DataView anyway when binding to a DataTable, AFAIK.)
grid.DataSource = view;

The following link describes the expression syntax that you can use for the RowFilter property and other DataSet expressions:

DataColumn.Expression property on MSDN:
http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

 

[Cor Ligthert [MVP]]

DBC,

There is nothing wrong with looping through the table and to remove the
datarows you do not want
If it is not a database related table, than it is not important if you use
delete or remove.

Cor