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 vote136 views1 answer
Dataset empty check C#
C#
21 votes129 views6 answers
Button group bootstrap
C#
0 vote149 views1 answer
Unity generate random offset position around a gameobject
C#
0 vote153 views1 answer
Sorting a list of objects in c#
C#
0 vote138 views1 answer
Mvc invalidOperationException: Method 'InvokeAsync' of view component should be declared to return Task<t>
C#
4 votes140 views1 answer
Combobox selected name c#
C#
-1 vote183 views1 answer
Unity check if colliders are touching
C#
55 votes181 views6 answers
C# print
C#
0 vote195 views1 answer
Enzymes chemical factory
C#
1 vote162 views2 answers
C# bitmap to Image
C#