Linq datatable

LINQ query on a DataTable C#

var results = from myRow in myDataTable.AsEnumerable()
where myRow.Field<int>("RowNo") == 1
select myRow;

Source: stackoverflow.com

Linq datatable

//Reference System.Data.DataSetExtensions
//Be carefull to data types
int id = 1;
//one row
DataRow r = (from DataRow m in myTable.Rows where m.Field<int>("col_name") == id select m).FirstOrDefault();
//list of rows
List<DataRow> r = (from DataRow m in myTable.Rows where m.Field<int>("col_name") == id select m).ToList();

Similar codes

7 votes246 views2 answers
How to clone somthing unity
C#Unity
0 vote270 views1 answer
Cannot convert string to long c#
C#
0 vote233 views1 answer
C# milisecond to h m s
C#
0 vote259 views1 answer
C# remove numericUpDown white space
C#
0 vote228 views2 answers
Convert stream to base64 string c#
C#
0 vote241 views1 answer
Create a hash of an XML c#
C#
0 vote221 views1 answer
Antlr c# errors
C#
1 vote254 views4 answers
Remove from array c#
C#
0 vote219 views1 answer
Query associative table ef6
C#
2 votes219 views1 answer
Change array size in unity
C#