How to Use LINQ query on a DataTable in C#?

Published on July 25, 2013 by abundantcode

Filed under LINQ

Last modified July 25, 2013

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2 (2 votes)

This article have been viewed 14718 times

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; }

}

}

How to Use LINQ query on a DataTable in C#?

0saves
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

1 Comment

  1. sunil

    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;

    August 15, 2015 - 9:09 pm – Reply

Leave a Comment


x

You might be Interested in these Posts

VB.NET and LINQ – Filter elements from object collection with Logical Operators

Here’s a sample code snippet demonstrating how to filter elements from a list of objects using the w...

C# and LINQ – Filter elements from object collection with Logical Operators

Here’s a sample code snippet demonstrating how to filter elements from a list of objects using the w...

VB.NET and LINQ – Filter elements from object collection using where clause

Here’s a sample code snippet demonstrating how to filter elements from a list of objects using the w...