Blog

Select Query on DataTable for filtering Data Using LINQ

Jan 21, 2012 Blogs | LINQ
I go through lots of site for select query on DataTable. But most of the time I did not get a suitable solution. So, at last I use LINQ to filter data from DataTable.

I go through lots of site for select query on DataTable. But most of the time I did not get a suitable solution. So, at last I use linq to filter data from datatable. So I share my code below:-


DataTable dt = new DataTable();

 string sqlStatement1 = "select * from hsswith_view where cp_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "'  or ep_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "'";

 SqlCommand sqlCmd1 = new SqlCommand(sqlStatement1,connection);                                                                SqlDataAdapter sqlDa1 = new SqlDataAdapter(sqlCmd1);
          sqlDa1.Fill(dt1);

            var query = from r in dt1.AsEnumerable()
                        where r.Field<string>("pax") == no_person

                        select
new

                        {

                            entry_id = r["entry_id"].ToString(),

                            pax = r["pax"].ToString(),
                            package = r["package"].ToString(),
                            no_of_days = r["no_of_days"].ToString(),
                            cp_amount = r["cp_amount"].ToString(),
                           
                            ep_amount = r["ep_amount"].ToString()

                       };
 

            GridView1.DataSource = query;

            GridView1.DataBind();


First of all I select data using one select query and fill it at datatable(dt1). Now I write linq query to extract data from dt1 DataTable and bind the values at GridView. These much.

  • 441rank
  • 106K readers
COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs