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 vote179 views2 answers
Dotnet add package
C#
0 vote160 views1 answer
RelayCommand
C#
3 votes180 views2 answers
C# move files from one folder to another
C#
-5 votes159 views5 answers
Happy New Year!
C#
1 vote229 views1 answer
Unity raycast all layers except one
C#Unity
1 vote174 views1 answer
How to use double in c#
C#
0 vote165 views5 answers
Exit form esc winforms
C#
0 vote153 views1 answer
C# wpf get clipboard text
C#
5 votes158 views2 answers
Rigidbody velocity c# unity
C#
1 vote178 views1 answer
How to open new form on button click in c# xamarin
C#