protected void ProductSearch_Click(object sender, EventArgs e) { String product_id = TextBox1.Text; conn = new MySqlConnection(GetConnectionString()); ProductsList.ClearSelection(); try { conn.Open(); String sql = mainquery + "where Product_ID='" + product_id + "'"; MySqlCommand comm = new MySqlCommand(sql, conn); MySqlDataReader dr = comm.ExecuteReader(); ProductsList.DataSource = dr; ProductsList.DataTextField = maintextfield; ProductsList.DataValueField = mainvaluefield; ProductsList.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } }
protected void DeselectAll_Click(object sender, EventArgs e) { ProductsList.ClearSelection(); }