string sConnectionString = System.Configuration.ConfigurationManager.AppSettings["ForumConnString"].ToString();
string sUserID = Guid.NewGuid().ToString();
string sUserName=UserName.Text;
string sUserPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(UserPassword.Text, "MD5");
int SelectedValue;
if(RadioButton1.Checked)
{
SelectedValue = 0; //性别为男
}
else
{
SelectedValue = 1; //性别为女
}
using(SqlConnection conn=new SqlConnection(sConnectionString))
{
conn.Open();
string sql="insert into tb_Login(UserID,UserName,UserPassword,UserSex,UserEmail) values (@UserID,@UserName,@UserPassword,@UserSex,@UserEmail)";
using (SqlCommand cmd = new SqlCommand(sql,conn))
{
cmd.Parameters.AddWithValue("@UserID", sUserID);
cmd.Parameters.AddWithValue("@UserName", sUserName);
cmd.Parameters.AddWithValue("@UserPassword", sUserPassword);
cmd.Parameters.AddWithValue("@UserSex", SelectedValue);
cmd.Parameters.AddWithValue("@UserEmail", UserEmail);
int i = Convert.ToInt32(cmd.ExecuteNonQuery());
if (i > 0)
{
Response.Write("<script>alert('注册成功')</script>");
}
else
{
Response.Write("<script>alert('注册失败')</script>");
}
}
Session["UserID"] = sUserID;
Session["UserName"] = sUserName;
}
错误提示：不存在从对象类型 System.Web.UI.WebControls.TextBox 到已知的托管提供程序本机类型的映射。
