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 vote176 views1 answer
Conevrt list to pipe separated string c#
C#
0 vote162 views1 answer
C# project path
C#
1 vote162 views1 answer
Teleport in vue
C#
25 votes187 views4 answers
Movetowards unity
C#
0 vote176 views1 answer
Autoclicker for yes/no in c# indicator
C#
0 vote161 views1 answer
Vbnet programatically convert type to db type
C#
0 vote178 views1 answer
How to find the multiples of 3 c#
C#
0 vote172 views1 answer
10x10 table matrix C#
C#
2 votes171 views2 answers
C# get enum name from value
C#
0 vote153 views1 answer
Populate array from an XML file
C#