Mixing
Inserting data through a stored procedure returns 'to many arguments specified' error
I am trying to insert data into my database through a stored procedure:
Dim connectionString As String
connectionString = ConfigurationManager.ConnectionStrings("AIConnectionString").ConnectionString.ToString()
Dim cmd As New SqlClient.SqlCommand
Dim con As New SqlClient.SqlConnection(connectionString)
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertQ"
cmd.Parameters.Add(New SqlParameter("@Questions", tBoxQuestion1.Text))
cmd.ExecuteNonQuery()
con.Close()
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertA"
cmd.Parameters.Add(New SqlParameter("@Answers", tBoxAnswer1.Text))
cmd.ExecuteNonQuery()
con.Close()
Basically when someone enters text into tBoxQuestion1 and tBoxAnswer1/tBoxAnswer2 and they click 'done', it will upload the text into my database through the stored procedures 'AIAaronInsertA, and AIAaronInsertQ. Here is the AIAaronInsertA Stored procedure:
USE [AIAaronDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AIAaronInsertA]
(
@Answers varchar(200)
)
AS
begin
insert into AIAnswers
(
Answers
)
values
(
@Answers
)
end
GO
The other stored procedure is is almost identical. But when I click 'done' it gives me this error:
System.Data.SqlClient.SqlException: 'Procedure or function AIAaronInsertA has too many arguments specified.'
Anyone know a solution to this?
database vb.net
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
add a comment |
I am trying to insert data into my database through a stored procedure:
Dim connectionString As String
connectionString = ConfigurationManager.ConnectionStrings("AIConnectionString").ConnectionString.ToString()
Dim cmd As New SqlClient.SqlCommand
Dim con As New SqlClient.SqlConnection(connectionString)
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertQ"
cmd.Parameters.Add(New SqlParameter("@Questions", tBoxQuestion1.Text))
cmd.ExecuteNonQuery()
con.Close()
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertA"
cmd.Parameters.Add(New SqlParameter("@Answers", tBoxAnswer1.Text))
cmd.ExecuteNonQuery()
con.Close()
Basically when someone enters text into tBoxQuestion1 and tBoxAnswer1/tBoxAnswer2 and they click 'done', it will upload the text into my database through the stored procedures 'AIAaronInsertA, and AIAaronInsertQ. Here is the AIAaronInsertA Stored procedure:
USE [AIAaronDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AIAaronInsertA]
(
@Answers varchar(200)
)
AS
begin
insert into AIAnswers
(
Answers
)
values
(
@Answers
)
end
GO
The other stored procedure is is almost identical. But when I click 'done' it gives me this error:
System.Data.SqlClient.SqlException: 'Procedure or function AIAaronInsertA has too many arguments specified.'
Anyone know a solution to this?
database vb.net
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
add a comment |
I am trying to insert data into my database through a stored procedure:
Dim connectionString As String
connectionString = ConfigurationManager.ConnectionStrings("AIConnectionString").ConnectionString.ToString()
Dim cmd As New SqlClient.SqlCommand
Dim con As New SqlClient.SqlConnection(connectionString)
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertQ"
cmd.Parameters.Add(New SqlParameter("@Questions", tBoxQuestion1.Text))
cmd.ExecuteNonQuery()
con.Close()
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertA"
cmd.Parameters.Add(New SqlParameter("@Answers", tBoxAnswer1.Text))
cmd.ExecuteNonQuery()
con.Close()
Basically when someone enters text into tBoxQuestion1 and tBoxAnswer1/tBoxAnswer2 and they click 'done', it will upload the text into my database through the stored procedures 'AIAaronInsertA, and AIAaronInsertQ. Here is the AIAaronInsertA Stored procedure:
USE [AIAaronDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AIAaronInsertA]
(
@Answers varchar(200)
)
AS
begin
insert into AIAnswers
(
Answers
)
values
(
@Answers
)
end
GO
The other stored procedure is is almost identical. But when I click 'done' it gives me this error:
System.Data.SqlClient.SqlException: 'Procedure or function AIAaronInsertA has too many arguments specified.'
Anyone know a solution to this?
database vb.net
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
I am trying to insert data into my database through a stored procedure:
Dim connectionString As String
connectionString = ConfigurationManager.ConnectionStrings("AIConnectionString").ConnectionString.ToString()
Dim cmd As New SqlClient.SqlCommand
Dim con As New SqlClient.SqlConnection(connectionString)
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertQ"
cmd.Parameters.Add(New SqlParameter("@Questions", tBoxQuestion1.Text))
cmd.ExecuteNonQuery()
con.Close()
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "AIAaronInsertA"
cmd.Parameters.Add(New SqlParameter("@Answers", tBoxAnswer1.Text))
cmd.ExecuteNonQuery()
con.Close()
Basically when someone enters text into tBoxQuestion1 and tBoxAnswer1/tBoxAnswer2 and they click 'done', it will upload the text into my database through the stored procedures 'AIAaronInsertA, and AIAaronInsertQ. Here is the AIAaronInsertA Stored procedure:
USE [AIAaronDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AIAaronInsertA]
(
@Answers varchar(200)
)
AS
begin
insert into AIAnswers
(
Answers
)
values
(
@Answers
)
end
GO
The other stored procedure is is almost identical. But when I click 'done' it gives me this error:
System.Data.SqlClient.SqlException: 'Procedure or function AIAaronInsertA has too many arguments specified.'
Anyone know a solution to this?
database vb.net
database vb.net
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
edited Nov 20 '18 at 20:24
LarsTech
69.9k12105158
69.9k12105158
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
asked Nov 20 '18 at 20:07
Aaron YorkAaron York
195
195
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You keep adding parameters to the existing SQLCommand object.
Try making a new one:
...
cmd = New SqlClient.SqlCommand
cmd.Connection = con
or clear the existing parameters:
cmd.Parameters.Clear()
cmd = New SqlClient.SqlCommand
cmd.Connection = con
I would have a preference for a new object placed in a Using - End Using block.
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400759%2finserting-data-through-a-stored-procedure-returns-to-many-arguments-specified%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You keep adding parameters to the existing SQLCommand object.
Try making a new one:
...
cmd = New SqlClient.SqlCommand
cmd.Connection = con
or clear the existing parameters:
cmd.Parameters.Clear()
cmd = New SqlClient.SqlCommand
cmd.Connection = con
I would have a preference for a new object placed in a Using - End Using block.
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
add a comment |
You keep adding parameters to the existing SQLCommand object.
Try making a new one:
...
cmd = New SqlClient.SqlCommand
cmd.Connection = con
or clear the existing parameters:
cmd.Parameters.Clear()
cmd = New SqlClient.SqlCommand
cmd.Connection = con
I would have a preference for a new object placed in a Using - End Using block.
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
add a comment |
You keep adding parameters to the existing SQLCommand object.
Try making a new one:
...
cmd = New SqlClient.SqlCommand
cmd.Connection = con
or clear the existing parameters:
cmd.Parameters.Clear()
cmd = New SqlClient.SqlCommand
cmd.Connection = con
I would have a preference for a new object placed in a Using - End Using block.
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
You keep adding parameters to the existing SQLCommand object.
Try making a new one:
...
cmd = New SqlClient.SqlCommand
cmd.Connection = con
or clear the existing parameters:
cmd.Parameters.Clear()
cmd = New SqlClient.SqlCommand
cmd.Connection = con
I would have a preference for a new object placed in a Using - End Using block.
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
answered Nov 20 '18 at 20:23
LarsTechLarsTech
69.9k12105158
69.9k12105158
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
add a comment |
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
Once again, thanks so much LarsTech! It worked perfectly!
– Aaron York
Nov 20 '18 at 23:00
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400759%2finserting-data-through-a-stored-procedure-returns-to-many-arguments-specified%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
