首先不要使用这样的内联查询。这会将您的应用程序暴露给 SQL Injection 攻击。



同时调试代码并查看 SelectedItem.Text

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.

First of all don't use inline queries like this. This exposes your application to SQL Injection attack.

Also debug your code and see what are the values coming for the SelectedItem.Text.