protected void QuantityAddButton_Click(object sender, EventArgs e)
{
String cs = ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString1"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("insert into ProductQuantityTable values('" + ProductDropDownId.SelectedItem.Value + "','" + ProductQuantityTextBox.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
ProductQuantityTextBox.Text = string.Empty;
ProductDropDownId.ClearSelection();
ProductDropDownId.Items.FindByValue("0").Selected = true;
}
}
