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 votes150 views1 answer
C# error
C#
0 vote116 views1 answer
My custom file watcher
C#
0 vote118 views1 answer
How to make a circuit board
C#
0 vote167 views1 answer
Make 2D object move at constant speed unity
C#Unity
1 vote162 views1 answer
Ef rollback migration
C#
1 vote126 views1 answer
Datetimeoffset to datetime c#
C#
4 votes122 views1 answer
Make winforms full-screen c#
C#
9 votes140 views3 answers
Get rigidbody component unity
C#
0 vote126 views1 answer
Mvc client validation doen't work display none
C#
0 vote117 views1 answer
C# return default "" if null
C#