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 vote348 views1 answer
Unity normalize float
C#Unity
1 vote272 views1 answer
Unity character controller ignore collision
C#
0 vote272 views1 answer
Moq Unittest with ILogger
C#
10 votes264 views3 answers
Get number of days between two dates c#
C#
4 votes258 views1 answer
F string C#
C#
0 vote271 views1 answer
SerializedObjectNotCreatableException: Object at index 0 is null
C#
0 vote286 views1 answer
Unity dictionary check if key exists
C#
0 vote315 views1 answer
Unity rb.addexplosionforce 2d
C#Unity
0 vote314 views2 answers
Windows forms webbrowser navigate
C#
30 votes243 views2 answers
C# how to initialize an array
C#