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

24 votes227 views2 answers
Unity destroy self
C#Unity
4 votes137 views2 answers
Prime Number in C#
C#
3 votes174 views1 answer
Stop sound in unity
C#Unity
3 votes139 views2 answers
C# move files from one folder to another
C#
0 vote143 views1 answer
C# asp.net only displays name of property
C#
19 votes192 views1 answer
How to disable a gameObject unity c#
C#
-1 vote118 views1 answer
C# get regedit value
C#
0 vote128 views1 answer
HOW TO CALL AN EXTENSION METHOD FOR VIEW C#
C#
1 vote130 views1 answer
Connection string in asp.net with username and password
C#
0 vote93 views1 answer
C# clamp
C#