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 vote124 views1 answer
Ef core include
C#
6 votes127 views2 answers
Simplified if statement c#
C#
19 votes158 views2 answers
Unity change text
C#Unity
10 votes140 views5 answers
C# null check
C#
0 vote441 views1 answer
Dotnet target specific framework
C#
0 vote133 views1 answer
C# stringwriter encoding iso-8859-1 example
C#
22 votes129 views3 answers
Textmeshpro text
C#
0 vote134 views1 answer
See if two string arrays are equal c#
C#
0 vote124 views1 answer
Check which activity in focus in android
C#
1 vote121 views1 answer
C# .net core convert string to enum
C#