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 vote208 views1 answer
Beard styles without mustache Intitle:work with me
C#
1 vote196 views1 answer
Subtract two times c#
C#
1 vote205 views2 answers
C# check word length
C#
0 vote176 views1 answer
Linq get a dictionary key and value c#
C#
6 votes200 views2 answers
How to check if textbox is empty in c#
C#
5 votes197 views2 answers
Find value in object c#
C#
1 vote185 views1 answer
How to write web service for API in c#
C#
1 vote264 views1 answer
Unity 2d joystick controls
C#Unity
1 vote192 views1 answer
Path desktop c#
C#
-1 vote194 views1 answer
C# tuple
C#