protected void Button4_Click(object sender, EventArgs e)
 {
     SpecificationRList1.ClearSelection();
     SpecificationRList2.ClearSelection();
     SpecificationRList3.ClearSelection();
     SpecificationRList4.ClearSelection();
     SpecificationRList5.ClearSelection();
     SpecificationRList6.ClearSelection();
     SpecificationRList7.ClearSelection();
     BrandList.SelectedIndex = 0;
     brandchanged            = false;
     conn = new MySqlConnection(GetConnectionString());
     try
     {
         conn.Open();
         MySqlCommand    comm = new MySqlCommand(mainquery + condition, conn);
         MySqlDataReader dr   = comm.ExecuteReader();
         ProductsGrid.DataSource = dr;
         ProductsGrid.DataBind();
         dr.Close();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
     finally
     {
         conn.Close();
     }
 }
        protected void Button4_Click(object sender, EventArgs e)
        {
            SpecificationRList1.ClearSelection();
            SpecificationRList2.ClearSelection();
            SpecificationRList3.ClearSelection();
            SpecificationRList4.ClearSelection();
            SpecificationRList5.ClearSelection();
            SpecificationRList6.ClearSelection();
            SpecificationRList7.ClearSelection();
            BrandList.SelectedIndex = 0;
            brandchanged            = false;



            Button4.Visible = false;
        }