performing a select on a c# datatable

Question

I have a datatable with a bunch of rows in it, the first column is an Int32 and I want to perform a simple select like:

select * from MyDataTable where column1 = 234

Answer 1

Try this to get result as row array :

DataRow[] rows = myDataTable.Select("column1 = 234");

Or this to get dataview :

DataView myDataView = myDataTable.DefaultView;
myDataView.RowFilter = "column1 = 234";