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 vote253 views1 answer
Check if number is in range c#
C#
0 vote277 views2 answers
C# generate random date
C#
1 vote305 views1 answer
Mvc input type file
C#
0 vote332 views1 answer
Dirty property unity
C#Unity
2 votes292 views1 answer
Asp.net data annotations Datetime
C#
1 vote271 views1 answer
.net core check if user is logged in
C#
0 vote277 views1 answer
Force asp.net https
C#
1 vote262 views1 answer
Unity custom editor save changes
C#
2 votes300 views1 answer
System command c#
C#
0 vote275 views1 answer
IHttpContextAccessor
C#