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

4 votes113 views3 answers
Regex for email c#
C#
2 votes165 views1 answer
Unity player look at mouse
C#Unity
1 vote163 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#Unity
1 vote131 views1 answer
Copy text from a text box c#
C#
30 votes189 views4 answers
Unity get all children
C#Unity
0 vote150 views1 answer
Change text size unity
C#Unity
7 votes83 views4 answers
How to add text to element javascript
C#
9 votes115 views3 answers
C# round number
C#
1 vote124 views1 answer
Fill all array c# with same value
C#
-1 vote123 views1 answer
Substring c#
C#