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 vote160 views2 answers
Install active directory windows server 2019 powershell
C#
1 vote194 views1 answer
How to compare 2 date time in asp.net core 3.1
C#
5 votes153 views1 answer
Idenitfy if you press a key in unity
C#
0 vote172 views1 answer
Is number c#
C#
19 votes163 views2 answers
Unity reset scene
C#
4 votes368 views1 answer
Raycast from camera to mouse unity
C#
32 votes161 views10 answers
Translate
C#
0 vote155 views1 answer
Blazor get current url
C#
1 vote160 views1 answer
Loop over enum values
C#
8 votes228 views2 answers
Unity rotate towards
C#Unity