存储过程执行时总提示未提供该参数

zywhao 2009-12-11 12:45:25

今天遇到一个问题。存储过程执行时总是提示
消息 201，级别 16，状态 4，过程 prtbUser_Add，第 0 行
过程或函数 'prtbUser_Add' 需要参数 '@UserIM'，但未提供该参数。

ALTER PROCEDURE [dbo].[prtbUser_Add] 

	@UserPwd varchar(30),

	@UserEmail varchar(30),

	@UserIM varchar(50),

	@UserStatus int,

	@UserQuesion varchar(50),

	@UserAnswer varchar(50),

	@UserInfo varchar(100),

	@UserMobile varchar(13),

	@CompanyName varchar(50),

	@Address varchar(100),

	@UserIsAva bit,

	@Userphone varchar(13),

	@UserFax varchar(13),

	@UserType int,

	@UserValiGuid varchar(50)

AS

BEGIN

	

	SET NOCOUNT ON;



    INSERT INTO tbUser

           (UserType

		   ,UserPwd

           ,UserEmail

           ,UserIM

           ,UserStatus

           ,UserQuesion

           ,UserAnswer

           ,UserInfo

           ,UserMobile

           ,CompanyName

           ,Address

           ,UserIsAva

           ,Userphone

           ,UserFax

		   ,UserValiGuid)

     VALUES

           (@UserType

		   ,@UserPwd

           ,@UserEmail

           ,@UserIM

           ,@UserStatus

           ,@UserQuesion

           ,@UserAnswer

           ,@UserInfo

           ,@UserMobile

           ,@CompanyName

           ,@Address

           ,@UserIsAva

           ,@Userphone

           ,@UserFax

		   ,@UserValiGuid)



		return 1

	

END

在asp.net 页面中传值时值为

虽然提示有错误，但插入却成功了。执行存储过程返回值为-1

请问是哪儿的问题

...全文

544 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

wuyq11 2009-12-11

打赏
举报

参数要Replace("'","''")

charwei 2009-12-11

打赏
举报

你在asp.net调用存储过程时，少传了个参数

happy664618843 2009-12-11

打赏
举报

参数未给它赋值 LZ再细心检查下

wuyq11 2009-12-11

打赏
举报

不存在参数
调试看看SQL语句

zhucemajiaburongyi 2009-12-11

打赏
举报

你有个参数没传

zywhao 2009-12-11

打赏
举报

难道存储过程传值时不能传 ''吗？

zywhao 2009-12-11

打赏
举报

Database db = DatabaseFactory.CreateDatabase();

            DbCommand cmd = db.GetStoredProcCommand("prtbUser_Add");

            db.AddInParameter(cmd, "@UserType", DbType.Int32, _objUser.UserType);

            db.AddInParameter(cmd, "@UserPwd", DbType.String, _objUser.UserPwd);

            db.AddInParameter(cmd, "@UserEmail", DbType.String, _objUser.UserEmail);

            db.AddInParameter(cmd, "@UserIM", DbType.String, _objUser.UserIM);

            db.AddInParameter(cmd, "@UserStatus", DbType.Int32, _objUser.UserStatus);

            db.AddInParameter(cmd, "@UserQuesion", DbType.String, _objUser.UserQuesion);

            db.AddInParameter(cmd, "@UserAnswer", DbType.String, _objUser.UserAnswer);

            db.AddInParameter(cmd, "@UserInfo", DbType.String, _objUser.UserInfo);

            db.AddInParameter(cmd, "@UserMobile", DbType.String, _objUser.UserMobile);

            db.AddInParameter(cmd, "@CompanyName", DbType.String, _objUser.CompanyName);

            db.AddInParameter(cmd, "@Address", DbType.String, _objUser.Address);

            db.AddInParameter(cmd, "@UserIsAva", DbType.Boolean, _objUser.UserIsAva);

            db.AddInParameter(cmd, "@Userphone", DbType.String, _objUser.Userphone);

            db.AddInParameter(cmd, "@UserFax", DbType.String, _objUser.UserFax);

            db.AddInParameter(cmd, "@UserValiGuid", DbType.String, _objUser.UserValiGuid);



         

                int a=db.ExecuteNonQuery(cmd);