存储过程中遇到的问题.
存储过程为:
CREATE PROCEDURE InsertUser
@UserName NVARCHAR(20),
@pwd NVARCHAR(20),
@UserIntro NVARCHAR(1000)
AS
SET XACT_ABORT ON
BEGIN TRANSACTION
declare @UserId int
SELECT @UserId=max(UserId)+1 from UserList
INSERT INTO [UserList]
VALUES (@UserId,@UserName,@pwd,@UserIntro)
COMMIT TRANSACTION
RETURN 0
GO
调用它的函数为:
public static bool ExecuteInsertUserList(string UserName,string Pwd,string UserIntro)
{
SqlConnection Conn=open_Conn();
SqlCommand Cmd=new SqlCommand("InsertUser",Conn);
Cmd.CommandType=CommandType.StoredProcedure;
Cmd.Parameters.Add("@UserName",SqlDbType.NVarChar,20,UserName);
Cmd.Parameters.Add("@pwd",SqlDbType.NVarChar,20,Pwd);
Cmd.Parameters.Add("@UserIntro",SqlDbType.NVarChar,1000,UserIntro);
try
{
Cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
//throw e;
return false;
}
return false;
}
错误为:
过程 'InsertUser' 需要参数 '@UserName',但未提供该参数。