protected void Button2_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand(); if (DropDownList3.SelectedItem.Text == "Economy") { seats = Convert.ToInt32(DropDownList1.SelectedItem.Text); cmd.Connection = con; con.Open(); cmd.CommandText = "select easeats from flight where fno='" + fn + "'"; int eds = Convert.ToInt32(cmd.ExecuteScalar()); if (eds > seats) { Panel2.Visible = true; //seats available cl = DropDownList3.SelectedItem.Text; seat = seats.ToString(); seats = eds; }
fn
cmd.CommandText = "select easeats from flight where fno=" + fn ;
cmd.CommandText = "select easeats from flight where fno='" + fn + "'"; int eds = Convert.ToInt32(cmd.ExecuteScalar());
easeats
varchar
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)