存储过程的问题
CREATE PROCEDURE SELECT_USER
@User_Name Varchar(20)
As
BEGIN TRANSACTION
select count(*) from [User] where User_Name = @User_Name
if (@@error <>0)
ROLLBACK TRANSACTION
else
COMMIT TRANSACTION
GO
存储过程如上
程序如下
string User_Name = Text1.Value;
string sqlstr = "SELECT_USER";
SqlConnection conn1 = new SqlConnection(conn);
conn1.Open();
SqlCommand com1 = new SqlCommand(sqlstr,conn1);
com1.CommandType = CommandType.StoredProcedure;
SqlParameter SelParam = new SqlParameter(@User_Name,SqlDbType.VarChar,20);
SelParam.Value = User_Name;
SelParam.Direction = ParameterDirection.Input;
com1.Parameters.Add(SelParam);
int num = com1.ExecuteNonQuery();
我在输入了USer_Name之后他却说输入的字段不是过程 SELECT_USER 的参数。
？？？？？？？？？？？？？？？？？？？？？？？？？
问题点数：0、回复次数：4Top
1 楼wzr20013309（大哥帮忙）回复于 2003-11-01 16:06:53 得分 0
UPTop
2 楼wzr20013309（大哥帮忙）回复于 2003-11-01 16:13:39 得分 0
UPTop
3 楼nstorm（网の风）回复于 2003-11-01 16:53:41 得分 0
改成如下：
string sqlstr = "SELECT_USER @User_Name";
Top
4 楼webdiyer（.net资源精华—www.dotneturls.com）回复于 2003-11-01 17:02:17 得分 0
SqlParameter SelParam = new SqlParameter(@User_Name,SqlDbType.VarChar,20);
改为：
SqlParameter SelParam = new SqlParameter("@User_Name",SqlDbType.VarChar,20);Top
