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

2 votes185 views1 answer
C# create log file
C#
0 vote196 views1 answer
Set data annotation text in model c#
C#
0 vote191 views1 answer
Create a list of 3 Orders c#
C#
1 vote203 views1 answer
How to turn off sprite renderer in unity
C#
0 vote191 views1 answer
.net core get runtime version
C#
1 vote206 views1 answer
And in c#
C#
0 vote206 views1 answer
Exception handling in c# web api
C#
0 vote195 views1 answer
Black lives matter update arsenal
C#
0 vote222 views1 answer
C# entity framework code first connection string
C#
27 votes252 views3 answers
Unity get textmesh pro component
C#Unity