Hi
i want to bind data in the dropdownlist and insert that data in another table.
Here is my CODE::;
THIS IS FOR BINDING
MySqlDataAdapter da = new MySqlDataAdapter("Select * from tbl_legal", cn);
DataTable dt = new DataTable();
da.Fill(dt);
//ddplegal.SelectedItem.Value =
ddplegal.DataSource = dt;
ddplegal.DataTextField = "legal";
ddplegal.DataValueField = "id";
ddplegal.Items.Insert(0, new ListItem("--Select--", "0"));
ddplegal.DataBind();
THIS IS FOR INSERTING DATA
string str2 = "insert into tbl_organization1 values('" + lblempcode.Text + "','" + Dpgroup.SelectedItem.Text + "','" + ddplegal.SelectedItem.Text + "','" + Dpdivisn.SelectedItem.Text + "','" + Dplocation.SelectedItem.Text + "','" + Dpdepartment.SelectedItem.Text + "','" + DropDownList6.SelectedItem.Text + "','" + Dpdesign.SelectedItem.Text + "','" + DpProject.SelectedItem.Text + "','InActive','" + DropDownList7.SelectedItem.Text + "')";
MySqlCommand Cmd2 = new MySqlCommand(str2, cn);
Cmd2.ExecuteNonQuery();
cn.Close();
But i can't insert the selected dropdownlist data in the table....
there is no error ..
only inserting first item of the dropdown.