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

1 vote185 views1 answer
C# unity camera follow player horizontal axis
C#
2 votes198 views1 answer
Loadscene unity
C#Unity
0 vote185 views1 answer
Show 2 decimals of float
C#
1 vote177 views2 answers
C# 2d list
C#
0 vote199 views1 answer
C# chance of
C#
0 vote240 views1 answer
Nuget package TSETMC guide
C#
1 vote181 views1 answer
There is already a virtual axis named Horizontal registered. unity
C#
2 votes187 views1 answer
C# aspnet how to run a migration
C#
36 votes544 views5 answers
How to generate random number in unity
C#Unity
0 vote195 views1 answer
C# picturebox cursor hand
C#