select query on datatable for filter data

I go through lots of site for select query on datatable. But  most of the time I not get 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 datatble and bind the values at gridview. These much.