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 vote99 views1 answer
C# get total milliseconds from datetime
C#
0 vote94 views1 answer
Vb.net single quote in string
C#
1 vote98 views1 answer
C# add int var
C#
0 vote94 views1 answer
C# windows forms how to get controls in gropu box
C#
57 votes154 views10 answers
Bootstrap 4
C#
1 vote122 views1 answer
C# unity camera follow player horizontal axis
C#Unity
0 vote92 views1 answer
For what is ? sign in unity c#
C#
18 votes108 views4 answers
How to delete all files in a directory c#
C#
3 votes97 views2 answers
How to freeze x and y position in rb2d with code unity
C#
4 votes102 views1 answer
Get enum by index c#
C#