Below is a sample code snippet that demonstrates the usage of the LINQ query on a DataTable in C#.
How to Use LINQ query on a DataTable in C#?
using System; using System.Collections.Generic; using System.Data; using System.Linq; namespace AbundantCode { internal class Program { //How to Use LINQ query on a DataTable in C# ? private static void Main(string[] args) { List<CodeSnippet> CodeLst = new List<CodeSnippet>(); DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("Code"); DataRow row1 = dt.NewRow(); row1["Name"] = "Abundantcode"; row1["Code"] = "1-1-1"; dt.Rows.Add(row1); DataRow row2 = dt.NewRow(); row2["Name"] = "Plenty of sourcecode"; row2["Code"] = "1-1-12"; dt.Rows.Add(row2); var results = (from m in dt.AsEnumerable() where m.Field<string>("Code") == "1-1-12" select m).FirstOrDefault(); Console.WriteLine(results["Name"]); Console.ReadLine(); } } public class CodeSnippet { public string Name { get; set; } public string Code { get; set; } } }
var value = from Query in DT.AsEnumerable()
where Query.Field(“ID”) == Value
select (
new
{
UserId = Query.Field(“ID”).ToString(),
UserName = Query.Field(“Name”).ToString(),
Count = Query.Field(“Count”).ToString()
});
return value.First().Count;