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 votes138 views1 answer
How to cjeck if a string has a word c#
C#
0 vote153 views1 answer
How to look around with mouse in unity
C#Unity
0 vote125 views1 answer
Even configuration custom errors page is not working asp.net MVC
C#
7 votes127 views5 answers
C# or
C#
0 vote93 views1 answer
C# verify "no other" call xunit
C#
0 vote123 views1 answer
C# OrderBy desc
C#
0 vote139 views1 answer
Unity3d gameobject follow path
C#
0 vote136 views1 answer
Unity how to reorder a list
C#
3 votes132 views3 answers
C# Letters Only
C#
2 votes181 views1 answer
How to remove space between string in c#
C#