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 vote243 views1 answer
.net core check if linux
C#
13 votes242 views1 answer
Unity how to set gameobjkect enabled
C#Unity
-2 votes185 views2 answers
Ui.onclick unity in code
C#
5 votes214 views3 answers
Unity 2d rotation
C#
0 vote241 views1 answer
C# get all bytes of a file
C#
0 vote248 views1 answer
C# create delegate type at runtime
C#
0 vote242 views1 answer
C# The name `Math' does not exist in the current contex
C#
5 votes249 views3 answers
Number to number array
C#
1 vote267 views1 answer
C# string to sha256
C#
0 vote251 views1 answer
C# skip debug attribute
C#