protected void Button_Click(Object sender,EventArgs e){
Conn=new SqlConnection("server=; uid=syc;pwd=6332255;database=syc");
SqlCommand Acmd=new SqlCommand("insert into guser (userid,username,sex,nl,cardid,addr,workplace,userfrom,intime,indays,houseid,initpay) values(@userid,@username,@sex,@nl,@cardid,@add,@workplace,@userfrom,@intime,@indays,@houseid,@initpay)",Conn);
Acmd.Parameters.Add(new SqlParameter("@userid",SqlDbType.Int));
Acmd.Parameters["@userid"].Value=Request.Params["userid"];
Acmd.Parameters.Add(new SqlParameter("@username",SqlDbType.Char,30));
Acmd.Parameters["@username"].Value=Request.Params["username"];
Acmd.Parameters.Add(new SqlParameter("@sex",SqlDbType.SmallInt));
Acmd.Parameters["@sex"].Value=Request.Params["sex"];
Acmd.Parameters.Add(new SqlParameter("@nl",SqlDbType.SmallInt));
Acmd.Parameters["@nl"].Value=Request.Params["nl"];
Acmd.Parameters.Add(new SqlParameter("@cardid",SqlDbType.NVarChar,53));
Acmd.Parameters["@cardid"].Value=Request.Params["cardid"];
Acmd.Parameters.Add(new SqlParameter("@addr",SqlDbType.NVarChar,53));
Acmd.Parameters["@addr"].Value=Request.Params["addr"];
Acmd.Parameters.Add(new SqlParameter("@workplace",SqlDbType.NVarChar,53));
Acmd.Parameters["@workplace"].Value=Request.Params["workplace"];
Acmd.Parameters.Add(new SqlParameter("@userfrom",SqlDbType.NVarChar,53));
Acmd.Parameters["@userfrom"].Value=Request.Params["userfrom"];
Acmd.Parameters.Add(new SqlParameter("@intime",SqlDbType.DateTime));
Acmd.Parameters["@intime"].Value=System.DateTime.Now;
Acmd.Parameters.Add(new SqlParameter("@indays",SqlDbType.SmallInt));
Acmd.Parameters["@indays"].Value=Request.Params["indays"];
Acmd.Parameters.Add(new SqlParameter("@houseid",SqlDbType.Int));
Acmd.Parameters["@houseid"].Value=Request.Params["houseid"];
Acmd.Parameters.Add(new SqlParameter("@initpay",SqlDbType.Int));
Acmd.Parameters["@initpay"].Value=Request.Params["initpay"];
Conn.Open(); Acmd.ExecuteScalar();
Response.Write("<script>alert('登记成功');location.href='index.asp';</script>");~~~~~~~~~~~~~~~~~~~~~~~~~~~~上面的代码编译错误:~~~~~~~~~~~~~~~~~~~~~~~~~~异常详细信息: System.Data.SqlClient.SqlException: 必须声明变量 '@add'。源错误: 行 93: Acmd.ExecuteScalar();
我不知道这个@add 是什么意思,望师傅帮小第解决一下
Conn=new SqlConnection("server=; uid=syc;pwd=6332255;database=syc");
SqlCommand Acmd=new SqlCommand("insert into guser (userid,username,sex,nl,cardid,addr,workplace,userfrom,intime,indays,houseid,initpay) values(@userid,@username,@sex,@nl,@cardid,@add,@workplace,@userfrom,@intime,@indays,@houseid,@initpay)",Conn);
Acmd.Parameters.Add(new SqlParameter("@userid",SqlDbType.Int));
Acmd.Parameters["@userid"].Value=Request.Params["userid"];
Acmd.Parameters.Add(new SqlParameter("@username",SqlDbType.Char,30));
Acmd.Parameters["@username"].Value=Request.Params["username"];
Acmd.Parameters.Add(new SqlParameter("@sex",SqlDbType.SmallInt));
Acmd.Parameters["@sex"].Value=Request.Params["sex"];
Acmd.Parameters.Add(new SqlParameter("@nl",SqlDbType.SmallInt));
Acmd.Parameters["@nl"].Value=Request.Params["nl"];
Acmd.Parameters.Add(new SqlParameter("@cardid",SqlDbType.NVarChar,53));
Acmd.Parameters["@cardid"].Value=Request.Params["cardid"];
Acmd.Parameters.Add(new SqlParameter("@addr",SqlDbType.NVarChar,53));
Acmd.Parameters["@addr"].Value=Request.Params["addr"];
Acmd.Parameters.Add(new SqlParameter("@workplace",SqlDbType.NVarChar,53));
Acmd.Parameters["@workplace"].Value=Request.Params["workplace"];
Acmd.Parameters.Add(new SqlParameter("@userfrom",SqlDbType.NVarChar,53));
Acmd.Parameters["@userfrom"].Value=Request.Params["userfrom"];
Acmd.Parameters.Add(new SqlParameter("@intime",SqlDbType.DateTime));
Acmd.Parameters["@intime"].Value=System.DateTime.Now;
Acmd.Parameters.Add(new SqlParameter("@indays",SqlDbType.SmallInt));
Acmd.Parameters["@indays"].Value=Request.Params["indays"];
Acmd.Parameters.Add(new SqlParameter("@houseid",SqlDbType.Int));
Acmd.Parameters["@houseid"].Value=Request.Params["houseid"];
Acmd.Parameters.Add(new SqlParameter("@initpay",SqlDbType.Int));
Acmd.Parameters["@initpay"].Value=Request.Params["initpay"];
Conn.Open(); Acmd.ExecuteScalar();
Response.Write("<script>alert('登记成功');location.href='index.asp';</script>");~~~~~~~~~~~~~~~~~~~~~~~~~~~~上面的代码编译错误:~~~~~~~~~~~~~~~~~~~~~~~~~~异常详细信息: System.Data.SqlClient.SqlException: 必须声明变量 '@add'。源错误: 行 93: Acmd.ExecuteScalar();
我不知道这个@add 是什么意思,望师傅帮小第解决一下
解决方案 »
- SQL2000 自动定时备份数据库 怎么操作
- 快疯了,开始还好好地,现在突然IIS下的网站在局域网内访问不了了。
- gridview中显示多表查询返回的结果.
- 100M文件上传,各路大侠有没有好的解决方案...
- 调查※学习:您的开发平台vs2005+sql2000 or vs2008+sql2005
- [windows验证]用asp.net怎么向windows2003中添加用户
- “找不到用来与FrontPage服务器扩展通信的组件”是什么意思?
- 知道怎么设置一个DATAGRID,字超过单元格宽度后就自动换行?
- .NET下html5求助
- 鼠标坐标在屏幕上画一点
- 有个工作机会大家来看看!
- 我把调试好的.net网站上传至买的空间上 为什么显示出错!
改为:
Acmd.Parameters.Add(new SqlParameter("@add",SqlDbType.NVarChar,53));