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

1 vote341 views1 answer
Unity check if other object is colliding
C#
0 vote780 views1 answer
How to access path position variable in unity
C#
0 vote344 views1 answer
Update postgres sequence to max
C#
0 vote322 views1 answer
Dominosteine c#
C#
2 votes415 views1 answer
C# check if string is only letters and numbers
C#
4 votes365 views3 answers
Sum of digit of number c#
C#
0 vote355 views1 answer
C# serialize to xml
C#
0 vote342 views1 answer
Unity if object doens't exist
C#
6 votes315 views2 answers
Index list c#
C#
0 vote338 views1 answer
How to use C# to open windows explorer in “select/open file mode
C#