ALTER proc [dbo].[insertuser]
(
@username NVarChar(50),
@userpw NVarChar(50),
@usertel NVarChar(50),
@usermail NVarChar(50),
@userqq nchar(10),
@userip NVarChar(50),
@userquanxian nchar(10),
@adddatetime DateTime
)
As
Insert Into hluser(username,userpw,usertel,usermail,userqq,userip,userquanxian,adddatetime) Values (@username,@userpw,@usertel,@usermail,@userqq,@userip,@userquanxian,@adddatetime)
---------------------------------------------------------------------
string username = this.txtuname.Text;
string userpw = this.txtuserpassword.Text;
string usermob = this.txttelephone.Text;
string usermail = this.txtemail.Text;
string userqq = this.txtqq.Text;
string userip = Request.UserHostAddress;
string userqx = "1";
DateTime usernow = DateTime.Now; System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
userpw = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(userpw.ToString(), "md5"); try
{
SqlDbConnection mydb = new SqlDbConnection();
mydb.conn.Open();
SqlCommand cmd = new SqlCommand("insertuser", mydb.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@username", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userpw", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@usertel", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@usermail", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userqq", SqlDbType.NChar, 10);
cmd.Parameters.Add("@userip", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userquanxian", SqlDbType.NChar, 10);
cmd.Parameters.Add("@adddatetime", SqlDbType.DateTime); cmd.Parameters["@username"].Value = username.ToString();
cmd.Parameters["@userpw"].Value = userpw;
cmd.Parameters["@usertel"].Value = usermob.ToString();
cmd.Parameters["@usermail"].Value = usermail.ToString();
cmd.Parameters["@userqq"].Value = userqq.ToString();
cmd.Parameters["@userip"].Value = userip.ToString();
cmd.Parameters["@userquanxian"].Value = userqx.ToString();
cmd.Parameters["@adddatetime"].Value = usernow;
cmd.ExecuteNonQuery();
//cmd.Dispose();
//mydb.conn.Close();
}
catch
{
Response.Write("数据连接已断开,注册失败,请和系统管理员联系!");
return;
}--------------------------------------------------------------------------------无法添加记录,报"数据连接已断开,注册失败,请和系统管理员联系!"
请大侠们帮忙看下怎么改好。。谢谢。。急死了。
(
@username NVarChar(50),
@userpw NVarChar(50),
@usertel NVarChar(50),
@usermail NVarChar(50),
@userqq nchar(10),
@userip NVarChar(50),
@userquanxian nchar(10),
@adddatetime DateTime
)
As
Insert Into hluser(username,userpw,usertel,usermail,userqq,userip,userquanxian,adddatetime) Values (@username,@userpw,@usertel,@usermail,@userqq,@userip,@userquanxian,@adddatetime)
---------------------------------------------------------------------
string username = this.txtuname.Text;
string userpw = this.txtuserpassword.Text;
string usermob = this.txttelephone.Text;
string usermail = this.txtemail.Text;
string userqq = this.txtqq.Text;
string userip = Request.UserHostAddress;
string userqx = "1";
DateTime usernow = DateTime.Now; System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
userpw = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(userpw.ToString(), "md5"); try
{
SqlDbConnection mydb = new SqlDbConnection();
mydb.conn.Open();
SqlCommand cmd = new SqlCommand("insertuser", mydb.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@username", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userpw", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@usertel", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@usermail", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userqq", SqlDbType.NChar, 10);
cmd.Parameters.Add("@userip", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@userquanxian", SqlDbType.NChar, 10);
cmd.Parameters.Add("@adddatetime", SqlDbType.DateTime); cmd.Parameters["@username"].Value = username.ToString();
cmd.Parameters["@userpw"].Value = userpw;
cmd.Parameters["@usertel"].Value = usermob.ToString();
cmd.Parameters["@usermail"].Value = usermail.ToString();
cmd.Parameters["@userqq"].Value = userqq.ToString();
cmd.Parameters["@userip"].Value = userip.ToString();
cmd.Parameters["@userquanxian"].Value = userqx.ToString();
cmd.Parameters["@adddatetime"].Value = usernow;
cmd.ExecuteNonQuery();
//cmd.Dispose();
//mydb.conn.Close();
}
catch
{
Response.Write("数据连接已断开,注册失败,请和系统管理员联系!");
return;
}--------------------------------------------------------------------------------无法添加记录,报"数据连接已断开,注册失败,请和系统管理员联系!"
请大侠们帮忙看下怎么改好。。谢谢。。急死了。
解决方案 »
- 使用ISAPI实现URL Rewrite的问题,急!
- 求助~~在ASP.NET中使用了MAGICAJAX控件,如何让一个层在弹出后几秒,自动消失?
- 谁能帮我过滤关键字的补补完,谢谢啦!
- 如何打开网页就让某个超链接获得焦点
- +++++++++ 关于string串装换成二进制的问题~~ ++++++++++
- 我已经安装IIS 为什么不能使用ASP.NET 2.0 请教下
- 求一个带渐变效果的导航栏
- 如何做分级显示的列表??
- DataPager的性能如何?是真分页还是假分页?有对底层做过研究的大大没?
- 如果不用客户端脚本,是不是必须将Web Control那些组件的AutoPastback属性设置为True,才能激发事件?
- 如何刷新GridView?
- 64位Windows 7下使用TortoiseSVN出现的问题
2、没写错,原因找到了,不是这些程序问题真无语