且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用存储过程删除错误?

更新时间:2023-02-06 23:17:37

使用
comm = new SqlCommand("dbo.InsertHelpDesk1", conn);



还要检查过程的模式名称.如果不是dbo,则需要将其更改为dbo.让我知道会发生什么

[edit]我知道这只是一个衬里,但是请格式化所有代码块-这是一个很好的习惯,因此您不要忘记多行代码



Also check the schema name of procedure . If its not dbo then you need to change it to dbo. Let me know what happens

[edit] I know it is only a one liner, but please format all code blocks - it is a good habit to get into so you don''t forget on mulitlined code


提起SQL Server Management Studio,并检查是否执行了存储过程插入代码:即该过程是否确实存在于您通过连接字符串引用的数据库中.

错误消息非常明显:该过程不存在.您可能没有创建它,或者您已经在其他数据库中创建了它.
Bring up SQL Server Management Studio, and check that you executed the stored procedure insert code: i.e. that the procedure exists in exactly the database you are referencing via your connection string.

The error message is quite explicit: the procedure is not there. Either you didn''t cretae it, or you have created it in a different database.


I checked ur code.. It insert without any errors
Please check your Database whether the stored procedure is available
I checked ur code.. It insert without any errors
Please check your Database whether the stored procedure is available
Please check your web config file whether u have mention the database name<br />
properly



问候
Prince Antony



Regards
Prince Antony