datatable select problems

[bopritchard]

the table my dsExaminers dataset reads from has column display (of type int) that all of the values are 0...yet after applying this select method it still contains the values with 0 in the display field...what gives?

string strSelect = "display = 1";
dsExaminers.Tables[0].Select(strSelect);

 

[dalchri]

The Select method does not filter or get rid of the rows in the DataTable itself, it just returns a set of rows that meet the condition. I think what you are after is DataView.RowFilter if you are displaying this data in a grid.

More information:

http://msdn.microsoft.com/library/d...s/vbcon/html/vboridatasetfilteringsorting.asp

//Intialized elsewhere
DataGrid grd;

dsExaminers.Tables[0].DefaultView.RowFilter = "display = 1";
grd.DataSource = dsExaminers.Tables[0].DefaultView;