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 vote97 views1 answer
How to clip out ui element if they are not inside an element unity
C#Unity
0 vote116 views2 answers
Unity find all scriptable objects of a type
C#
115 votes125 views7 answers
Object length javascript
C#
0 vote97 views1 answer
C# Jobject to string
C#
23 votes119 views3 answers
C# foreach on a dictionary
C#
0 vote108 views1 answer
C# ipaddress to integer
C#
0 vote96 views3 answers
C# encrypt folder SHA512
C#
0 vote105 views1 answer
StackTrace getframe last frame
C#
2 votes149 views1 answer
Placeholder syntax c#
C#
81 votes160 views6 answers
Benoit Mandelbrot
C#