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 vote122 views2 answers
Combobox in datagrid wpf
C#
1 vote136 views1 answer
Avoid autocomplete input text asp.net
C#
1 vote120 views1 answer
How to check type in c#
C#
6 votes117 views1 answer
Net core get remote ip
C#
0 vote116 views1 answer
Disable quickedit c#
C#
0 vote130 views1 answer
C# get excel column number from letter
C#
2 votes123 views1 answer
Unity click on 2d object
C#
1 vote167 views1 answer
Unity3d change player position
C#Unity
2 votes137 views1 answer
How to type to console in unity
C#
0 vote91 views1 answer
Aps.net core mvc chek box
C#