ALTER PROC [dbo].[GetID] 
AS
BEGIN
SELECT MAX(record_id) FROM  [dbo].[sampletbl]
END

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ACSConnectionString"].ConnectionString);
SqlCommand comm2 = new SqlCommand();

            comm2.CommandText = "GetID";
            comm2.CommandType = CommandType.StoredProcedure;
            comm2.Connection = conn;

            // необходимо добавить следующую запись в БД  
            string idinserter = "ХК05-" + comm2.CommandText + "/21"; 

            SqlParameter sentnumParam = new SqlParameter("sentnumber", idinserter);

            comm.Parameters.Add(sentnumParam);
            
            conn.Open();
            comm2.ExecuteNonQuery();
            conn.Close();

ALTER PROC [dbo].[DataInsert]
(@organ varchar (100), @subject varchar(200), @sentnumber varchar(20), @entrydate smalldatetime)
AS
BEGIN
INSERT INTO [dbo].[sampletbl] (organ, subject, sentnumber, entrydate)
VALUES (@organ, @subject, @sentnumber, @entrydate)
END

ALTER PROC [dbo].[GetID] 
AS
BEGIN
SELECT MAX(record_id) FROM  [dbo].[sampletbl]
END

            //sozdanie connectionsting-a
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ACSConnectionString"].ConnectionString);
            SqlCommand comm = new SqlCommand();

            // vizov xranimoi proceduri
            comm.CommandText = "DataInsert"; 
            comm.CommandType = CommandType.StoredProcedure;
            comm.Connection = conn;

            // vizov vtoroi xranimoi proceduri dlya polucheniya poslednego ID
            comm2.CommandText = "GetID";
            comm2.CommandType = CommandType.StoredProcedure;
            comm2.Connection = conn;
               
            string idinserter = "ХК05-" + comm2.CommandText + "/21";
            SqlParameter organParam = new SqlParameter("organ", organtxt.Text);
            SqlParameter subjectParam = new SqlParameter("subject", subjecttxt.Text);
            SqlParameter sentnumParam = new SqlParameter("sentnumber", idinserter);

            DateTime dt = DateTime.Now;
            datelbl.Text = dt.ToString("d", CultureInfo.CreateSpecificCulture("de-DE"));


            SqlParameter entrydateParam = new SqlParameter("entrydate", datelbl.Text);

            comm.Parameters.Add(organParam);
            comm.Parameters.Add(subjectParam);
            comm.Parameters.Add(sentnumParam);
            comm.Parameters.Add(entrydateParam);

            conn.Open();
            comm.ExecuteNonQuery();
            comm2.ExecuteNonQuery();
            conn.Close();

            GridView1.DataBind();

ALTER PROC [dbo].[DataInsert]
(@organ varchar (100), @subject varchar(200), @emp_id int, @entrydate smalldatetime)
AS
BEGIN
declare @sentnumber varchar(20)
SELECT @sentnumber=cast(MAX(record_id)+1 as varchar(20)) FROM  [dbo].[sampletbl]

INSERT INTO [dbo].[sampletbl] (organ, subject, sentnumber, emp_id, entrydate)
VALUES (@organ, @subject, 'ХК/05-' + @sentnumber + @emp_id, @emp_id, @entrydate)

END

ALTER PROC [dbo].[DataInsert]
(@organ varchar (100), @subject varchar(200), @emp_id int, @entrydate smalldatetime)
AS
BEGIN
declare @sentnumber varchar(20)
SELECT @sentnumber=cast(MAX(record_id)+1 as varchar(20)) FROM  [dbo].[sampletbl]

INSERT INTO [dbo].[sampletbl] (organ, subject, sentnumber, emp_id, entrydate)
VALUES (@organ, @subject, 'ХК/05-' + @sentnumber + '/' + cast(@emp_id as varchar(10)), @emp_id, @entrydate)

ALTER PROC [dbo].[DataInserter]
(@employee_id int, @doctype_id int, @docchar_id int, @authority varchar (100), @subject varchar (200), @entrydate datetime, @login varchar (50))
AS
BEGIN
DECLARE @sentnumber varchar (20)
SELECT @sentnumber = CAST(MAX(Letter_ID)+1 as varchar(20)) FROM [dbo].[SentLetters]

INSERT INTO [dbo].[SentLetters] (Employee_ID, DocType_ID, DocChar_ID, Authority, Subject, Sentnumber, Entrydate, Login)
VALUES (@employee_id, @doctype_id, @docchar_id, @authority, @subject, 'ХК/05-' + @sentnumber + '/' + cast(@employee_id as varchar(10)),@entrydate,@login)
END

  SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NameofCS"].ConnectionString);
        SqlCommand comm = new SqlCommand();
        
        // присоединяем ХП.
        comm.CommandText = "DataInserter";
        comm.CommandType = CommandType.StoredProcedure;
        comm.Connection = conn;

        // Добавление значений в поля таблицы
        SqlParameter employeeparam = new SqlParameter("employee_ID", int.Parse(ddlemployee.SelectedItem.Value));
        SqlParameter doctypeparam = new SqlParameter("doctype_ID", int.Parse(ddldoctype.SelectedItem.Value));
        SqlParameter doccharparam = new SqlParameter("docchar_ID", int.Parse(ddlemployee.SelectedItem.Value));
        SqlParameter authorityparam = new SqlParameter("authority", txtauthority.Text);
        SqlParameter subjectparam = new SqlParameter("subject", txtsubject.Text);
        SqlParameter sentnumberparam = new SqlParameter("sentnumber", @sentnumber);
        SqlParameter entrydateparam = new SqlParameter("entrydate", txtentrydate.Text);
        SqlParameter loginparam = new SqlParameter("login", "jsomon");

        comm.Parameters.Add(employeeparam);
        comm.Parameters.Add(doctypeparam);
        comm.Parameters.Add(doccharparam);
        comm.Parameters.Add(authorityparam);
        comm.Parameters.Add(subjectparam);
        comm.Parameters.Add(sentnumberparam);
        comm.Parameters.Add(entrydateparam);
        comm.Parameters.Add(loginparam);
       
        // открываем коннекшен, и выполняем команду записи
        conn.Open();
        comm.ExecuteNonQuery();
        //закрываем коннекшен
        conn.Close();

Ошибка сервера в приложении '/'.

Для процедуры или функции DataInserter указано слишком много аргументов.

Описание: Необработанное исключение при выполнении текущего веб-запроса. Изучите трассировку стека для получения дополнительных сведений о данной ошибке и о вызвавшем ее фрагменте кода. 

Сведения об исключении: System.Data.SqlClient.SqlException: Для процедуры или функции DataInserter указано слишком много аргументов.

Ошибка источника: 


Строка 46:         // открываем коннекшен, и выполняем команду записи
Строка 47:         conn.Open();
[color=red]Строка 48:         comm.ExecuteNonQuery();[/color]
Строка 49:         //закрываем коннекшен
Строка 50:         conn.Close();

Исходный файл: c:\Users\wert\Documents\Visual Studio 2013\WebSites\Letters\EnrollLetter.aspx.cs    Строка: 48 

Трассировка стека: 


[SqlException (0x80131904): Для процедуры или функции DataInserter указано слишком много аргументов.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1789294
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5340642
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +275
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +208
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +163
   EnrollLetter.Button1_Click(Object sender, EventArgs e) in c:\Users\wert\Documents\Visual Studio 2013\WebSites\Letters\EnrollLetter.aspx.cs:48
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9628614
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

 SqlParameter sentnumberparam = new SqlParameter("sentnumber", @sentnumber);

comm.Parameters.Add(employeeparam);
        comm.Parameters.Add(doctypeparam);
        comm.Parameters.Add(doccharparam);
        comm.Parameters.Add(authorityparam);
        comm.Parameters.Add(subjectparam);
        comm.Parameters.Add(sentnumberparam); // экстра запись 
        comm.Parameters.Add(entrydateparam);
        comm.Parameters.Add(loginparam);
       

Для процедуры или функции DataInserter указано слишком много аргументов.