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 vote358 views1 answer
Dapper execute with list of ids
C#
0 vote359 views1 answer
Angular Input has no initializer
C#
0 vote329 views1 answer
C# loop through repeater items
C#
0 vote355 views1 answer
Flutter find a widget
C#
8 votes379 views2 answers
How to get parent gameobject in unity
C#
11 votes325 views2 answers
Unity how to change rotation
C#
1 vote362 views1 answer
Assign string value c#
C#
0 vote330 views1 answer
Html beginform
C#
3 votes357 views2 answers
C# console play sound
C#
0 vote357 views1 answer
Instantiate unity in parent
C#