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

1 vote297 views2 answers
Unity script wait
C#
0 vote306 views1 answer
Unity ar scale
C#Unity
0 vote346 views1 answer
Concurrent post request c#
C#
0 vote371 views1 answer
C# int cast error
C#
1 vote310 views1 answer
C# get set value
C#
0 vote318 views1 answer
Clickable table row asp.net core cursor
C#
2 votes325 views1 answer
Photon how to destroy object
C#
1 vote316 views1 answer
Check valid binary search tree
C#
2 votes353 views1 answer
Get current computer name C#
C#
1 vote351 views1 answer
Unity change tag of go
C#Unity