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 vote335 views1 answer
Get link element revit api
C#
0 vote360 views2 answers
C# how to get a file path from user
C#
-1 vote313 views1 answer
How to get image from resource folder in c#
C#
1 vote305 views1 answer
C# write text before user input
C#
1 vote341 views1 answer
Merge point
C#
0 vote333 views1 answer
Wpf listbox binding change style of selected item
C#
21 votes301 views3 answers
How to pause your game unity
C#
0 vote340 views1 answer
Spawning object around in a circle of an gameobject unity'
C#
0 vote297 views2 answers
C# how to convert string to float
C#
4 votes365 views1 answer
Unity mouse look script 2021
C#Unity