using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;      

using System.Data;

using System.Data.DataSetExtensions;

​

public class Program

{

    public static void Main()

    {

        DataTable dt = new DataTable();

        dt.Columns.Add("Name");

        var row1 = dt.NewRow();

        row1[0] = "test";

        dt.Rows.Add(row1);

        var row2 = dt.NewRow();

        row2[0] = "test";

        dt.Rows.Add(row2);

        var row3 = dt.NewRow();

        row3[0] = "Sample";

        dt.Rows.Add(row3);

​

        var enumerableDt = dt.AsEnumerable();

        var result = enumerableDt.FirstOrDefault(x => x.Field<string>("Name")== "Sample");//Returns a DataRow

        Console.WriteLine(result[0].ToString());

​

        var result1 = dt.Select("Name = 'Sample'"); //Returns a dataTable

        Console.WriteLine(result1[0][0].ToString());

​

    }   

}

​

​