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 votes364 views1 answer
C# xml
C#
1 vote283 views1 answer
C# close all threads application exit
C#
1 vote330 views1 answer
What is type unity
C#Unity
-1 vote355 views1 answer
How to fix unity crashing
C#Unity
2 votes287 views1 answer
Assign a value to multiple variables c#
C#
0 vote279 views1 answer
C# streamreader to file
C#
3 votes324 views2 answers
C# is not marked as serializable
C#
0 vote301 views1 answer
GetComponent<Button>().onClick
C#
0 vote320 views1 answer
EntityFramework: using tables in different scemas
C#
0 vote307 views1 answer
Get random point in collider unity
C#