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 vote112 views3 answers
C# shuffle array
C#
0 vote207 views1 answer
//Unity rigidbody drag and top speed relation:
C#Unity
1 vote150 views1 answer
Fade text unity
C#
1 vote180 views1 answer
Create gaps / headers between variables in the unity inspector
C#
1 vote144 views1 answer
Initialize ConsoleLoggerProvider in EF core
C#
1 vote198 views1 answer
Unity text display int
C#Unity
-2 votes205 views1 answer
Random position unity 2d
C#Unity
0 vote100 views1 answer
Radiobutton in asp.net
C#
1 vote136 views1 answer
C# get distance
C#
0 vote102 views1 answer
C# change all values in dictionary
C#