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

0 vote308 views1 answer
C# copy each property
C#
0 vote326 views1 answer
Web page search c#
C#
0 vote390 views1 answer
Set teh screen rect of camera unity
C#Unity
0 vote351 views2 answers
Sars
C#
32 votes369 views4 answers
Raycasthit unity
C#Unity
13 votes325 views2 answers
Model in bootsrap 4
C#
0 vote357 views1 answer
Unity rigidbody drag and top speed relation
C#
1 vote324 views1 answer
C# unity choose key input
C#
11 votes364 views1 answer
Reduce decimal point in double c#
C#
22 votes358 views2 answers
Unity coroutine
C#Unity