using System;

using System.Data;

using System.Xml;

using System.Linq;

using System.Data.DataSetExtensions;

​

public class Program

{

    public static void Main()

    {

        DataTable dt = new DataTable("Emp");

​

            //Adding columns to table Emp

            DataColumn colEmpid = new DataColumn("Empid", typeof(System.Int32));

            DataColumn colName = new DataColumn("Name", typeof(System.String));

            DataColumn colDept = new DataColumn("Department", typeof(System.String));

​

            //Adding columns to datatable

            dt.Columns.AddRange(new DataColumn[] { colEmpid, colName, colDept });

​

            //Adding data

            dt.Rows.Add(1000, "John Smith Brown", "Finance");

            dt.Rows.Add(1001, "Carry Brown", "Engineering");

            dt.Rows.Add(1002, "Candle Pencil", "Marketing");

            dt.Rows.Add(1003, "Graham Bell", "Engineering");

            dt.Rows.Add(1004, "Peter Kevin", "Finance & Engineering");

            DataRow[] rowsFilteredConditionAND = dt.Select("Name='Carry Brown'");

            Console.WriteLine("Count: " + rowsFilteredConditionAND.Length);

            DataTable dtSelected;

            var dr = from row in dt.AsEnumerable()

            where row.Field<string>("Name") == "Candle Pencil"

            select row;

            dtSelected = dr.CopyToDataTable();

​

            Console.WriteLine("Count2: " + dtSelected.Rows.Count);

​

    }

}