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 vote120 views4 answers
Catch multiple exception c#
C#
0 vote136 views1 answer
Dotween dovalue
C#
0 vote116 views1 answer
Response.Redirect cannot be called in a Page callback
C#
0 vote122 views1 answer
C# split include separators
C#
0 vote110 views1 answer
Asp.net file detect mime type
C#
0 vote124 views1 answer
C# if break
C#
10 votes122 views1 answer
Unity c# get bool from another script
C#
3 votes126 views1 answer
How to use the protected keyword in C#
C#
0 vote126 views1 answer
Unity animation length
C#
34 votes116 views3 answers
Unity get all by tag
C#