根据下拉选择保存ID到数据库我用下面的代码将BusinessID绑定为ddlIndustry下拉列表的DataValueField。我要做的是将选定的ID保存到不同的表(公司)。我使用ddlIndustry.SelectedValue执行此操作。由于某种原因,第一个值总是被保存(1),而不是选定的值。你有什么想办法可能会发生这种情况吗?绑定行业();}privatevoidBindCountry(){XmlDocumentdoc=newXmlDocument();doc.Load(Server.MapPath("countries.xml"));foreach(XmlNodenodeindoc.SelectNodes("//country")){ddlCountry.Items.Add(newListItem(node.InnerText,node.Attributes["code"].InnerText));ddlCountry.SelectedIndex=94;}}privatevoidBindIndustry(){SqlCommandcmd=null;SqlConnectionconn=newSqlConnection(GetConnectionString());conn.Open();cmd=newSqlCommand("选择行业,BusinessIDFROMBusinessType",conn);cmd.CommandType=CommandType.Text;SqlDataAdapterda=newSqlDataAdapter(cmd);数据集ds=new数据集();da.Fill(ds);conn.Close();ddlIndustry.DataSource=ds;ddlIndustry.DataTextField="行业";ddlIndustry.DataValueField="企业ID";ddlIndustry.DataBind();//ddlIndustry.Items.Insert(0,newSystem.Web.UI.WebControls.ListItem("--请选择行业--","0"));}privatevoidExecuteCompanyDetailsInsert(){SqlConnectionconn=newSqlConnection(GetConnectionString());stringsql="INSERTINTOCompany(BusinessID,CompanyName,Email,AddressLine1,AddressLine2,Location,Telephone)VALUES"+"(@BusinessID,@CompanyName,@Email,@AddressLine1,@AddressLine2,@Location,@Telephone)";尝试{conn.Open();SqlCommandcmd=newSqlCommand(sql,conn);SqlParameter[]param=newSqlParameter[7];param[0]=newSqlParameter("@BusinessID",SqlDbType.Int);param[1]=newSqlParameter("@CompanyName",SqlDbType.VarChar,50);param[2]=newSqlParameter("@Email",SqlDbType.VarChar,50);param[3]=newSqlParameter("@AddressLine1",SqlDbType.VarChar,50);param[4]=newSqlParameter("@AddressLine2",SqlDbType.VarChar,50);param[5]=newSqlParameter("@Location",SqlDbType.VarChar,50);param[6]=newSqlParameter("@Telephone",SqlDbType.VarChar,50);参数[0].Value=ddlIndustry.SelectedValue;param[1].Value=company_name.Text;param[2].Value=company_email.Text;param[3].Value=address_line_1.Text;param[4].Value=address_line_2.Text;param[5].Value=ddlCountry.SelectedItem.Text;param[6].Value=telephone.Text;对于(inti=0;i
