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

4 votes346 views1 answer
Raycast from camera to mouse unity
C#
0 vote188 views1 answer
DataTable GetErrors
C#
2 votes223 views1 answer
C# compile code at runtime
C#
0 vote199 views1 answer
PrincipalContext c# example
C#
0 vote201 views1 answer
My custom file watcher
C#
3 votes167 views2 answers
Unity mouse click m
C#
11 votes183 views1 answer
C# How to write Hello World
C#
0 vote191 views1 answer
C# monogodb
C#
0 vote173 views1 answer
C# how to get connection string from app config
C#
3 votes185 views1 answer
Check ping c sharp
C#