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 vote259 views1 answer
How to learn c# fast to learn unity
C#Unity
34 votes170 views3 answers
Convert text to number C#
C#
1 vote181 views2 answers
Merge xml files into one c#
C#
0 vote183 views2 answers
Winforms reportviewer.print report
C#
0 vote160 views1 answer
Eleventy set default layout
C#
5 votes154 views1 answer
Conditional if statement c# programming
C#
0 vote198 views1 answer
Unity how to reorder a list
C#
1 vote168 views1 answer
How to reference a UI element in unity
C#
-1 vote169 views2 answers
C# extend array
C#
3 votes177 views2 answers
Linq inner join
C#