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

-3 votes170 views2 answers
C# how to append in array
C#
1 vote173 views1 answer
How to set up blender with unity units
C#
0 vote162 views1 answer
Propertychanged is not firing up when text is change
C#
0 vote176 views1 answer
C# read all lines from filestream
C#
0 vote242 views1 answer
How to make projectile track and go to specified enemy in unity
C#Unity
25 votes230 views3 answers
If get key down unity
C#Unity
2 votes179 views2 answers
Casting string to enum type
C#
3 votes138 views3 answers
C# double to string format 6 decimal places
C#
-1 vote181 views1 answer
How to backgrund c# red
C#
0 vote197 views1 answer
Ffmpeg add audio to video at specific time
C#