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 vote136 views1 answer
Unity OVR Headset
C#
0 vote137 views1 answer
Check variable is empty powershell
C#
0 vote199 views1 answer
Unity apply bloom of a different color
C#Unity
0 vote201 views1 answer
Unity normalize movement
C#Unity
1 vote151 views1 answer
Unity temperature to colour
C#
2 votes154 views1 answer
Unity right click on gameobject
C#
0 vote143 views4 answers
Check list exist in list c# if matches any
C#
0 vote150 views1 answer
WCF service dependency injection
C#
0 vote151 views1 answer
Fixed angle unity
C#
4 votes177 views2 answers
Unity clamp rotation
C#