编译出现异常,求助!
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
SqlCommand cm=new SqlCommand("useradd",cn);
cm.CommandType=CommandType.StoredProcedure;
cm.Parameters.Add("@UID",SqlDbType.VarChar);
cm.Parameters.Add("@UPassword",SqlDbType.VarChar);
cm.Parameters.Add("@UQuestion",SqlDbType.VarChar);
cm.Parameters.Add("@UAnswer",SqlDbType.VarChar);
cm.Parameters.Add("@USex",SqlDbType.Bit);
cm.Parameters.Add("@UEmail",SqlDbType.VarChar);
cm.Parameters.Add("@UCityID",SqlDbType.Int);
cm.Parameters["@UID"].Value=tbx_uid.Text.ToString();
cm.Parameters["@UPassword"].Value=tbx_upassword.Text.ToString();
cm.Parameters["@UQuestion"].Value=tbx_question.Text.ToString();
cm.Parameters["@UAnswer"].Value=tbx_answer.Text.ToString();
cm.Parameters["@USex"].Value=ddl_sex.SelectedItem.Value.ToString();
cm.Parameters["@UEmail"].Value=tbx_email.Text.ToString();
cm.Parameters["@UCityID"].Value=tbx_city.Text.ToString();
cm.ExecuteNonQuery();
cn.Close();
存储过程为:
CREATE procedure adduser
@UID varchar,
@UPassword varchar,
@UPower int,
@UQuestion varchar,
@UAnswer varchar,
@USex bit,
@UEmail varchar,
@UCityID int
AS
insert into Users(UID,UPassword,UPower,UQuestion,UAnswer,USex,UEmail,UCityID) values
(@UID,
@UPassword,
2,
@UQuestion,
@UAnswer,
@USex,
@UEmail,
@UCityID
)
GO
异常详细信息: System.FormatException: 该字符串未被识别为有效的布尔值。
源错误:
行 116: cm.Parameters["@UCityID"].Value=tbx_city.Text.ToString();
行 117:
行 118: cm.ExecuteNonQuery(); //此行编译时为红色显示
行 119:
行 120: cn.Close();