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 vote131 views1 answer
C# regex replace all line breaks
C#
0 vote136 views1 answer
Set text in unity invisible
C#Unity
0 vote121 views1 answer
Dictionary namespace c#
C#
0 vote112 views1 answer
Unity predicts rigidbody position in x seconds
C#
5 votes112 views3 answers
Unity audiosource play
C#
1 vote117 views1 answer
How c# connection
C#
1 vote103 views1 answer
C# System.Resources.MissingManifestResourceException error
C#
0 vote141 views1 answer
Keep sprites at fixed transform according to screen resolution unity
C#Unity
0 vote114 views1 answer
How to get mouse position c#
C#
2 votes106 views2 answers
How to destroy parent gameobject unity
C#