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 vote311 views1 answer
C# System.Resources.MissingManifestResourceException error
C#
1 vote330 views1 answer
Debug raycasthit2d unity
C#Unity
0 vote318 views1 answer
Declare string array c# without size
C#
0 vote332 views1 answer
Android jaca how to pass a imageurl in a recyclerview adapter
C#
1 vote331 views1 answer
C# compile just one exe
C#
0 vote346 views1 answer
Unity c# image invisible
C#Unity
4 votes322 views1 answer
C# loop datatable rows
C#
0 vote318 views1 answer
Selenium webdriver what browser am i using?
C#
0 vote362 views1 answer
How do you make a 2D object follow another 2D object in unity 2D
C#Unity
1 vote314 views1 answer
Int value from enum in C#
C#