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 vote222 views1 answer
C# iorderedenumerable to dictionary
C#
1 vote203 views1 answer
Make mesh follow wheel collider unity
C#
4 votes184 views1 answer
Unity get animator
C#Unity
1 vote235 views1 answer
If in dictionary c#
C#
11 votes216 views2 answers
C# inline if
C#
1 vote245 views1 answer
How o remove .meta files visual studio code
C#
0 vote226 views1 answer
??= mean C#
C#
1 vote219 views1 answer
Fon der lajen
C#
3 votes216 views2 answers
C# array index tostring
C#
278 votes224 views6 answers
Unity download
C#Unity