Using datatable with Linq

 


public void LinqFilterData()
        {
            SqlConnection con = new SqlConnection(" Data Source=192.168.200.77;Initial Catalog=pluto;User ID=sa;Password=indi123;" +
                   "Connection Timeout=1500;Connection Lifetime=0;Min Pool Size=1;Max Pool Size=400;Pooling=true;");
            SqlDataAdapter da = new SqlDataAdapter("Select * from Employee", con);
            DataTable dt = new DataTable();          
            da.Fill(dt);
            var result = from emp in dt.AsEnumerable()
                         where emp.Field<int>("Rank")!=3
                         select emp;
            DataTable dtd = result.CopyToDataTable();
           
        }