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

12 votes331 views2 answers
C# messagebox yes no "wpf"
C#
0 vote291 views1 answer
C# invokerequired wpf
C#
0 vote260 views1 answer
Remove tabpage by key
C#
0 vote299 views1 answer
C# remove non-alphanumeric characters from string
C#
1 vote312 views1 answer
C# append textbox
C#
0 vote258 views1 answer
C# max rand
C#
0 vote273 views1 answer
C# insert spaces before capital letters
C#
1 vote299 views1 answer
Cannot implicitly convert type 'int' to 'System.Threading.Tasks.Task<int>'
C#
8 votes287 views2 answers
How to sort a list of objects in place
C#
0 vote271 views1 answer
Clickable table row asp.net core
C#