如何使用存储过程? [英] How to use stored procedure?

问题描述

我已经创建了一个存储过程，当我实现编码时遇到了错误....

我写了一个代码

I have created a stored procedure and when I implement in coding but got an error....

I wrote a code

SqlConnection conn;
           SqlCommand comm;
           string connectionString = ConfigurationManager.ConnectionStrings["Dorknozzle"].ConnectionString;
           conn = new SqlConnection(connectionString);
           comm = new SqlCommand("InsertHelpDesk2", conn);
           comm.CommandType = System.Data.CommandType.StoredProcedure;

comm.Parameters.Add("@EmployeeID", System.Data.SqlDbType.Int,50);
           comm.Parameters["@EmployeeID"].Value = 5;
           comm.Parameters.Add("@StationNumber", System.Data.SqlDbType.Int);
           comm.Parameters["@StationNumber"].Value = stationTextBox.Text;
           comm.Parameters.Add("@CategoryID", System.Data.SqlDbType.Int);
           comm.Parameters["@CategoryID"].Value = categorylist.SelectedItem.Value;
           comm.Parameters.Add("@SubjectID", System.Data.SqlDbType.Int);
           comm.Parameters["@SubjectID"].Value = subjectlist.SelectedItem.Value;
           comm.Parameters.Add("@Description", System.Data.SqlDbType.NVarChar, 50);
           comm.Parameters["@Description"].Value = descriptionTextBox.Text;
           comm.Parameters.Add("@StatusID", System.Data.SqlDbType.Int);
           comm.Parameters["@StatusID"].Value = 1;
      
               conn.Open();
               comm.ExecuteNonQuery();
               Response.Redirect("HelpDesk.aspx");
          
  conn.Close();

在MS-SQL 2008中我写了

and in MS-SQL 2008 i wrote

CREATE PROCEDURE InsertHelpDesk2
(
@EmployeeID int,
@StationNumber int,
@CategoryID int,
@SubjectID int,
@Description nvarchar(50),
@StatusID int
)
AS
INSERT INTO Dorknozzle1.dbo.HelpDesk1 (EmployeeID, StationNumber, CategoryID,
SubjectID, Description, StatusID)
VALUES (@EmployeeID, @StationNumber, @CategoryID, @SubjectID,
@Description, @StatusID)

我得到的错误是

我在
上遇到错误

error i got is

I am getting error on

comm.ExecuteNonQuery();

找不到存储过程"InsertHelpDesk2"

请告诉我我哪里错了

Could not find stored procedure ''InsertHelpDesk2''

please tell me where i am wrong

推荐答案

替换您的代码

Replace ur code

comm = new SqlCommand("InsertHelpDesk1", conn);

您已将存储过程命名为InsertHelpDesk1，并且给了InsertHelpDesk2这就是您收到错误的原因.

You have stored procedure by name InsertHelpDesk1 and you gave InsertHelpDesk2 that is why you got the error.

您好，

请检查数据库中是否存在存储过程，我认为在创建存储过程时，您没有选择适当的数据库.因此默认情况下会在主数据库中创建它.

感谢和问候，
Nilesh

Hi,

please check stored procedure is exist in database, i think when to create stored procedure, you does not select proper database. so it get created in master database by default.

thanks and Regards,
Nilesh

这篇关于如何使用存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！