tables in the database are:
Resi,NonResi,HES01,HAG02.
there are two dropdownlist
ddlist1 and ddlist2
if(ddlist1.selected.value=="Resi") then the values from the textboxes are stored into the Resi_Table then
if(ddlist2.selected.value=="HES01") then those values are also stored in the HES01_Table.
firstly the Resi is selected and values are stored and then hes01 is selected and values are stored..
i have written this code.This actually helps u in knwing what i am trying to say..
if (DropDownList1.SelectedItem.Value == "Non Residential")
{
cmd = new SqlCommand("insert into Cal_NonR(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);
if (DropDownList2.SelectedItem.Value == "HES01")
{
cmd = new SqlCommand("insert into HES01(GroupID,ProgrammeType,Title,ProgramStartDate ,ProgramEndDate,FiancialYear,Venue,TFee,PO_number) values(@GroupID,@ProgrammeType,@Title,@ProgramStartDate,@ProgramEndDate,@FiancialYear,@Venue,@TFee,@PO_number)", con);
cmd.Parameters.AddWithValue("@GroupID", DropDownList2.SelectedItem.Text);
cmd.Parameters.AddWithValue("@ProgrammeType", DropDownList1.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Title", TextBox1.Text);
cmd.Parameters.AddWithValue("@ProgramStartDate", Convert.ToDateTime(TextBox5.Text));
cmd.Parameters.AddWithValue("@ProgramEndDate", Convert.ToDateTime(TextBox6.Text));
cmd.Parameters.AddWithValue("@FiancialYear", TextBox7.Text);
cmd.Parameters.AddWithValue("@Venue", tbVenue.Text);
cmd.Parameters.AddWithValue("@TFee", tbTotalFee.Text);
cmd.Parameters.AddWithValue("@PO_number", TextBox4.Text);
}