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();
}
