c# datatable to linq
//You can't query against the DataTable's Rows collection, since
//DataRowCollection doesn't implement IEnumerable<T>.
//You need to use the AsEnumerable() extension for DataTable
var results = from myRow in myDataTable.AsEnumerable()
where myRow.Field<int>("RowNo") == 1
select myRow;
//AsEnumerable() returns IEnumerable<DataRow>.
//If you need to convert IEnumerable<DataRow> to a DataTable,
//use the CopyToDataTable()