Adding search by prices in the code.

See more:

C#

ASP.NET

I have shown the search by Products name as below.. i want to add the search by price query in the same code.. how can i add search by prices i.e range 0 to 5000, 5000 to 15000 e.t.c in the same query.. can i use OR command for that.. and i am using the object oriented aapproach here.. how can i get rid from sql concetination.. where to put cmd.Parameter.Add in the code.

I have shown the products by by using like sql query as below

private void Search()
{  
  string query = "Select * from Products where ProductName Like '" + Request.QueryString["Name"] + "%'";
            DataSet ds = obj.fillgrid(query);
  GridView1.DataSource = ds.Tables[0];
  GridView1.DataBind();
}

and i have a fillgrid method in dbcon class as.

public DataSet fillgrid(String query)
       {
           DataSet ds = null;
           try
           {
               SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connectionString);
               ds = new DataSet();
               dataAdapter.Fill(ds, "*.mdb");

           }
           catch (Exception ex)
           {
               // MessageBox.Show(ex.Message);
           }
           return ds;
       }