con.Open();
var = DropDownList1.SelectedValue;
if (DropDownList1.SelectedValue== var)
{
cmd = new SqlCommand("insert into Cal_Residential(Title_of_Programme,GroupID,Program_Start_Date,Program_End_Date,Venue,Fee,PO_Number) values(@Title_of_Programme,@GroupID,@Program_Start_Date,@Program_End_Date,@Venue,@Fee,@PO_Number)", con);
cmd.Parameters.AddWithValue("@Title_of_Programme", TextBox1.Text);
cmd.Parameters.AddWithValue("@GroupID", DropDownList2.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Program_Start_Date", Convert.ToDateTime(TextBox5.Text));
cmd.Parameters.AddWithValue("@Program_End_Date", Convert.ToDateTime(TextBox6.Text));
cmd.Parameters.AddWithValue("@Venue", tbVenue.Text);
cmd.Parameters.AddWithValue("@Fee", tbTotalFee.Text);
cmd.Parameters.AddWithValue("@PO_Number", TextBox4.Text);
cmd.ExecuteNonQuery();
Response.Write("<script LANGUAGE='JavaScript'>alert('Successfully Submitted')</script>");
string sv;
sv=DropDownList2.SelectedValue.ToString();
cmd1=new SqlCommand("insert into " +sv +" values (@GroupID, @ProgrammeType,@Title,@ProgramStartDate,@ProgramEndDate,@FiancialYear,@Venue,@TFee,@PO_number)",con);
cmd1.Parameters.AddWithValue("@GroupID", DropDownList2.SelectedItem.Text);
cmd1.Parameters.AddWithValue("@ProgrammeType", DropDownList1.SelectedItem.Text);
cmd1.Parameters.AddWithValue("@Title", TextBox1.Text);
cmd1.Parameters.AddWithValue("@ProgramStartDate", Convert.ToDateTime(TextBox5.Text));
cmd1.Parameters.AddWithValue("@ProgramEndDate", Convert.ToDateTime(TextBox6.Text));
cmd1.Parameters.AddWithValue("@FiancialYear", TextBox7.Text);
cmd1.Parameters.AddWithValue("@Venue", tbVenue.Text);
cmd1.Parameters.AddWithValue("@TFee", tbTotalFee.Text);
cmd1.Parameters.AddWithValue("@PO_number", TextBox4.Text);
cmd1.ExecuteNonQuery();
con.Close();
}