VS环境下一个注册界面的后台
使用RadioButton控件分两种注册身份
经测试发现普通用户注册没问题 医生用户点了注册没反应后台代码: string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();//在配置文件中获得连接字符
using (SqlConnection conn = new SqlConnection(connStr))
{
if (rbtn_zj.Checked)
{
string pass = ClsMD5.Encrypt(txt_pwd.Text, "hongying*wangluo");//密文
str = "insert into T_doctors(type,dUserName,dPwd,dpassword,dMail,dTrueName,dGander,dHospital,dHAddress,dDepartment,dMajor,dAbout,dPhone,dProfessional,dLiecense)values(@type,@dUserName,@dPwd,@dpassword,@dMail,@dTrueName,@dGander,@dHospital,@dHAddress,@dDepartment,@dMajor,@dAbout,@dPhone,@dProfessional,@dLiecense)";
int result = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, str, new SqlParameter("@type", rbtn_zj.Text), new SqlParameter("@dUserName", ys_Name.Text), new SqlParameter("@dPwd", ys_pwd.Text), new SqlParameter("@dpassword", pass), new SqlParameter("@dMail", ys_mail.Text), new SqlParameter("@dTureName", true_name.Text), new SqlParameter("@dGander", rdfemal.Text), new SqlParameter("@dHospital", txt_hospital.Text), new SqlParameter("@dHAddress", txt_adress.Text), new SqlParameter("@dDepartment", list_keshi.SelectedValue), new SqlParameter("@dMajor", txt_major.Text), new SqlParameter("@dAbout", txt_jianli.Text), new SqlParameter("@dPhone", txt_photo.Text), new SqlParameter("@dProfessional", list_zhicheng.SelectedValue), new SqlParameter("@dLiecense", FileUpload1.FileName));
Response.Write("<script type='text/javascript'>alert('恭喜你,您成功注册了医生用户,点此转到登陆界面>>>');document.location='DengLu.aspx';</script>");
}
if (rbtn_pt.Checked)
{
string pass = ClsMD5.Encrypt(txt_pwd.Text, "hongying*wangluo");//密文
str = "insert into T_users(type,userName,uPwd,password,uMail)values(@type,@userName,@uPwd,@password,@uMail)";
int result = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, str, new SqlParameter("@type", rbtn_pt.Text), new SqlParameter("@userName", txt_username.Text), new SqlParameter("@uPwd", txt_pwd.Text), new SqlParameter("@password", pass), new SqlParameter("@uMail", txt_mail.Text));
Response.Write("<script type='text/javascript'>alert('恭喜你,您成功注册了普通用户,点此转到登陆界面>>>');document.location='DengLu.aspx';</script>");
//Response.Redirect("DengLu.aspx");//重定向到登录界面
}
}
使用RadioButton控件分两种注册身份
经测试发现普通用户注册没问题 医生用户点了注册没反应后台代码: string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();//在配置文件中获得连接字符
using (SqlConnection conn = new SqlConnection(connStr))
{
if (rbtn_zj.Checked)
{
string pass = ClsMD5.Encrypt(txt_pwd.Text, "hongying*wangluo");//密文
str = "insert into T_doctors(type,dUserName,dPwd,dpassword,dMail,dTrueName,dGander,dHospital,dHAddress,dDepartment,dMajor,dAbout,dPhone,dProfessional,dLiecense)values(@type,@dUserName,@dPwd,@dpassword,@dMail,@dTrueName,@dGander,@dHospital,@dHAddress,@dDepartment,@dMajor,@dAbout,@dPhone,@dProfessional,@dLiecense)";
int result = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, str, new SqlParameter("@type", rbtn_zj.Text), new SqlParameter("@dUserName", ys_Name.Text), new SqlParameter("@dPwd", ys_pwd.Text), new SqlParameter("@dpassword", pass), new SqlParameter("@dMail", ys_mail.Text), new SqlParameter("@dTureName", true_name.Text), new SqlParameter("@dGander", rdfemal.Text), new SqlParameter("@dHospital", txt_hospital.Text), new SqlParameter("@dHAddress", txt_adress.Text), new SqlParameter("@dDepartment", list_keshi.SelectedValue), new SqlParameter("@dMajor", txt_major.Text), new SqlParameter("@dAbout", txt_jianli.Text), new SqlParameter("@dPhone", txt_photo.Text), new SqlParameter("@dProfessional", list_zhicheng.SelectedValue), new SqlParameter("@dLiecense", FileUpload1.FileName));
Response.Write("<script type='text/javascript'>alert('恭喜你,您成功注册了医生用户,点此转到登陆界面>>>');document.location='DengLu.aspx';</script>");
}
if (rbtn_pt.Checked)
{
string pass = ClsMD5.Encrypt(txt_pwd.Text, "hongying*wangluo");//密文
str = "insert into T_users(type,userName,uPwd,password,uMail)values(@type,@userName,@uPwd,@password,@uMail)";
int result = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, str, new SqlParameter("@type", rbtn_pt.Text), new SqlParameter("@userName", txt_username.Text), new SqlParameter("@uPwd", txt_pwd.Text), new SqlParameter("@password", pass), new SqlParameter("@uMail", txt_mail.Text));
Response.Write("<script type='text/javascript'>alert('恭喜你,您成功注册了普通用户,点此转到登陆界面>>>');document.location='DengLu.aspx';</script>");
//Response.Redirect("DengLu.aspx");//重定向到登录界面
}
}
解决方案 »
- 从剪切板中读取Metafile类型图片,读不出来
- 微信API 链接网址接入 大侠请进
- page的StyleSheetTheme问题
- 关于C#windows API的所有例子,提供一个也给分
- 大家帮忙看看简单问题
- web服务的问题
- 200分开帖讨论留言群发工具的工作原理
- cshape_gis(GIS开发者) xingbing(葡萄酒) gesnpt(gesnpt) 进来领分
- 怎么样开发SNMP的软件,获取UPS的相关数据
- 怎么以字符(“<br>数字.”),分割字符串,用正则表达式可以吗?怎么用?
- 函数传参可以宏替换?
- 我在flowlayoutpanel里面动态放了好多label,但都没有自动换行怎么办
insert语句已经检查好几遍了 确定无误
现在怀疑 是不是 取值的时候有语法问题?
"insert into T_doctors(type,dUserName,dPwd,dpassword,dMail,dTrueName,dGander,dHospital,dHAddress,dDepartment,dMajor,dAbout,dPhone,dProfessional,dLiecense) values(@type,@dUserName,@dPwd,@dpassword,@dMail,@dTrueName,@dGander,@dHospital,@dHAddress,@dDepartment,@dMajor,@dAbout,@dPhone,@dProfessional,@dLiecense)";
你把values前面插入一个空格试试(两段SQL命令都需要加空格),看能不能执行,或者报什么异常错误?
情况一直是 无任何报错 前台运行状况没问题 普通用户注册没问题 医生用户点击不会弹出成功确认框 数据库也不会存入数据
现在又开始怀疑是不是前台RadioButton控件的设置有问
先确定sql语句没有错误,把语句复制到sql查询器里面调试下,试试。
在看下SqlHelper.ExecuteNonQuery啊。
我以前就是出现了一个全角的空格在sql里面,查奔溃了。