一个错误搞了我好久,就是修改更新会员信息,出了这样一个错误:“DropDoLisex”有一个无效 SelectedValue,因为它不在项目列表中。参数名: value
后台代码给出来了,求解决啊
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
String sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlconnstr); DataSet ds = new DataSet();
DataTable dt;
SqlDataAdapter sqld = new SqlDataAdapter("select * from [User] ", sqlconn);
SqlCommandBuilder cb = new SqlCommandBuilder(sqld);
sqld.Fill(ds, "user");
dt = ds.Tables["user"];
DataRow dr = dt.NewRow();
FileUpload fupimg = (FileUpload)FormView1.FindControl("FileUpload1");
TextBox txtrealName = (TextBox)FormView1.FindControl("txtrealname");
DropDownList ddlsex = (DropDownList)FormView1.FindControl("DropDoLisex");
TextBox txtBirth = (TextBox)FormView1.FindControl("txtbirth");
TextBox txtPhone = (TextBox)FormView1.FindControl("txtphone");
TextBox txtEmail = (TextBox)FormView1.FindControl("txtemail");
TextBox txtAddress = (TextBox)FormView1.FindControl("txtaddress");
ddlsex.SelectedIndex = ddlsex.Items.IndexOf(ddlsex.Items.FindByValue("DropDoLisex")); dr["realname"] = txtrealName.Text;
dr["sex"] = char.Parse(ddlsex.SelectedValue);
dr["birth"] = txtBirth.Text;
dr["phone"] = txtPhone.Text;
dr["email"] = txtEmail.Text;
dr["address"] = txtAddress.Text;
dr["image"] = fupimg.FileName;
if (fupimg.HasFile == true)
{
fupimg.SaveAs(Server.MapPath(("~/images/") + fupimg.FileName));
}
sqld.Update(ds, "user");
this.FormView1.ChangeMode(FormViewMode.ReadOnly);
FormView1.DataSource = Datacon.GetUserInfo(id);
FormView1.DataBind();
}
后台代码给出来了,求解决啊
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
String sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlconnstr); DataSet ds = new DataSet();
DataTable dt;
SqlDataAdapter sqld = new SqlDataAdapter("select * from [User] ", sqlconn);
SqlCommandBuilder cb = new SqlCommandBuilder(sqld);
sqld.Fill(ds, "user");
dt = ds.Tables["user"];
DataRow dr = dt.NewRow();
FileUpload fupimg = (FileUpload)FormView1.FindControl("FileUpload1");
TextBox txtrealName = (TextBox)FormView1.FindControl("txtrealname");
DropDownList ddlsex = (DropDownList)FormView1.FindControl("DropDoLisex");
TextBox txtBirth = (TextBox)FormView1.FindControl("txtbirth");
TextBox txtPhone = (TextBox)FormView1.FindControl("txtphone");
TextBox txtEmail = (TextBox)FormView1.FindControl("txtemail");
TextBox txtAddress = (TextBox)FormView1.FindControl("txtaddress");
ddlsex.SelectedIndex = ddlsex.Items.IndexOf(ddlsex.Items.FindByValue("DropDoLisex")); dr["realname"] = txtrealName.Text;
dr["sex"] = char.Parse(ddlsex.SelectedValue);
dr["birth"] = txtBirth.Text;
dr["phone"] = txtPhone.Text;
dr["email"] = txtEmail.Text;
dr["address"] = txtAddress.Text;
dr["image"] = fupimg.FileName;
if (fupimg.HasFile == true)
{
fupimg.SaveAs(Server.MapPath(("~/images/") + fupimg.FileName));
}
sqld.Update(ds, "user");
this.FormView1.ChangeMode(FormViewMode.ReadOnly);
FormView1.DataSource = Datacon.GetUserInfo(id);
FormView1.DataBind();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货