Textbox is showing Quantity after submit button1 click.I want Quantity on selection of dropdownlist.code is.......
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd1 = new SqlCommand("SELECT Quantity from AddedItem where Item_Name='" + DropDownList3.SelectedItem.Text + "'", con);
SqlDataReader dr = cmd1.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
TextBox3.Text = dr.GetValue(0).ToString();
dr.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string st = "";
if (IsPostBack)
{
try
{
SqlCommand cmd1 = new SqlCommand("SELECT Item_Id from AddedItem where Item_Name='" + DropDownList3.SelectedItem.Text + "'", con);
SqlDataReader dr = cmd1.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
st = dr[0].ToString();
dr.Close();
}
SqlCommand cmd = new SqlCommand("INSERT INTO IssuedItem VALUES('" + st + "','" + DropDownList1.SelectedItem.Text + "','" + DropDownList2.SelectedItem.Text + "','"+DropDownList3.SelectedItem.Text+"','"+Calendar1.SelectedDate.ToShortDateString()+"','"+TextBox2.Text+"')", con);
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
}
}