SP Expects paramater not supplied error

[Cirene]

I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexceptio n: Procedure or function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@InstructionsOp erator",
CType(multiPage.FindControl("txtInstructionsOperat or"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@InstructionsCu stomer",
CType(multiPage.FindControl("txtInstructionsCustom er"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Requ ired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Show ",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Cowboy \(Gregory A. Beamer\)]

The only thing I can think of off hand is the value is the wrong format.

One way to check, if this is a developer SQL install, is to stoke up
Profiler and see what command is being sent to SQL Server. That will show
you if the parameter is missing or just incorrect.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
"Cirene" <ci****@nowhere.comwrote in message
news:ex**************@TK2MSFTNGP05.phx.gbl...

>I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexceptio n: Procedure or function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@InstructionsOp erator",
CType(multiPage.FindControl("txtInstructionsOperat or"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@InstructionsCu stomer",
CType(multiPage.FindControl("txtInstructionsCustom er"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Requ ired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Show ",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Cirene]

Never heard of that tool, but sounds good. Is there a way to see EXACTLY
which parameters are being passed into a stored proc using this tool?

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:BE**********************************@microsof t.com...

The only thing I can think of off hand is the value is the wrong format.

One way to check, if this is a developer SQL install, is to stoke up
Profiler and see what command is being sent to SQL Server. That will show
you if the parameter is missing or just incorrect.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
"Cirene" <ci****@nowhere.comwrote in message
news:ex**************@TK2MSFTNGP05.phx.gbl...

>>I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexcepti on: Procedure or
function 'InsertCompany' expects parameter '@ApptPhone1Required', which
was not supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@InstructionsO perator",
CType(multiPage.FindControl("txtInstructionsOpera tor"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@InstructionsC ustomer",
CType(multiPage.FindControl("txtInstructionsCusto mer"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Req uired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Sho w",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[=?Utf-8?B?WWFua2VlIEltcGVyaWFsaXN0IERvZw==?=]

check to see if the value you are passing in is null (or nothing) this will
give this error sometimes. I know that you should get a "not set to an
instance ... " because you are using find control", but other than you just
named the parameters wrong along the way this is all i can think of
--
Share The Knowledge. I need all the help I can get and so do you!
"Cirene" wrote:

I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexceptio n: Procedure or function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@InstructionsOp erator",
CType(multiPage.FindControl("txtInstructionsOperat or"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@InstructionsCu stomer",
CType(multiPage.FindControl("txtInstructionsCustom er"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Requ ired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Show ",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Cirene]

thanks - alot of the data webpages i do i have no code, just use the data
binding controls, etc...

so sometimes when i call a stored proc its hard to debug

this profiler things has caught my attention - wonder if it would tell me
all the PARAMS sent to the stored proc and EXACTLY what their values are

anyone have any insight????

thanks!!

"Yankee Imperialist Dog" <Ya******************@discussions.microsoft.com>
wrote in message news:AE**********************************@microsof t.com...

check to see if the value you are passing in is null (or nothing) this
will
give this error sometimes. I know that you should get a "not set to an
instance ... " because you are using find control", but other than you
just
named the parameters wrong along the way this is all i can think of
--
Share The Knowledge. I need all the help I can get and so do you!
"Cirene" wrote:

>I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexcepti on: Procedure or
function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@InstructionsO perator",
CType(multiPage.FindControl("txtInstructionsOpera tor"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@InstructionsC ustomer",
CType(multiPage.FindControl("txtInstructionsCusto mer"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Req uired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Sho w",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Jeff Dillon]

Response.Write all the parameter values, instead of calling the sproc

Jeff
"Cirene" <ci****@nowhere.comwrote in message
news:Ol****************@TK2MSFTNGP03.phx.gbl...

thanks - alot of the data webpages i do i have no code, just use the data
binding controls, etc...

so sometimes when i call a stored proc its hard to debug

this profiler things has caught my attention - wonder if it would tell me
all the PARAMS sent to the stored proc and EXACTLY what their values are

anyone have any insight????

thanks!!

"Yankee Imperialist Dog" <Ya******************@discussions.microsoft.com>
wrote in message
news:AE**********************************@microsof t.com...

>check to see if the value you are passing in is null (or nothing) this
will
give this error sometimes. I know that you should get a "not set to an
instance ... " because you are using find control", but other than you
just
named the parameters wrong along the way this is all i can think of
--
Share The Knowledge. I need all the help I can get and so do you!
"Cirene" wrote:

>>I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexcept ion: Procedure or
function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@Instructions Operator",
CType(multiPage.FindControl("txtInstructionsOper ator"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@Instructions Customer",
CType(multiPage.FindControl("txtInstructionsCust omer"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Re quired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Sh ow",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Cirene]

you mean go ahead and write code to add the param values manually?

"Jeff Dillon" <je********@hotmailremove.comwrote in message
news:%2******************@TK2MSFTNGP05.phx.gbl...

Response.Write all the parameter values, instead of calling the sproc

Jeff
"Cirene" <ci****@nowhere.comwrote in message
news:Ol****************@TK2MSFTNGP03.phx.gbl...

>thanks - alot of the data webpages i do i have no code, just use the data
binding controls, etc...

so sometimes when i call a stored proc its hard to debug

this profiler things has caught my attention - wonder if it would tell me
all the PARAMS sent to the stored proc and EXACTLY what their values are

anyone have any insight????

thanks!!

"Yankee Imperialist Dog" <Ya******************@discussions.microsoft.com>
wrote in message
news:AE**********************************@microso ft.com...

>>check to see if the value you are passing in is null (or nothing) this
will
give this error sometimes. I know that you should get a "not set to an
instance ... " because you are using find control", but other than you
just
named the parameters wrong along the way this is all i can think of
--
Share The Knowledge. I need all the help I can get and so do you!
"Cirene" wrote:

I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexcep tion: Procedure or
function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@Instruction sOperator",
CType(multiPage.FindControl("txtInstructionsOpe rator"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@Instruction sCustomer",
CType(multiPage.FindControl("txtInstructionsCus tomer"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1R equired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1S how",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.

Thanks

[Paul Shapiro]

Yes, SQL Server Profiler can show the text of every command passed to the
server. It's an essential debugging and performance management tool. You can
copy any SQL statements that were passed into the server, and then run the
same command in SQL Manager so you can troubleshoot issues. However, there
is a bit of a learning curve getting it to display the info you want, and if
it's a busy server, getting it NOT to display all the other server
communication. Look in SQL's Books Online for usage info.

"Cirene" <ci****@nowhere.comwrote in message
news:Ol****************@TK2MSFTNGP03.phx.gbl...

thanks - alot of the data webpages i do i have no code, just use the data
binding controls, etc...

so sometimes when i call a stored proc its hard to debug

this profiler things has caught my attention - wonder if it would tell me
all the PARAMS sent to the stored proc and EXACTLY what their values are

anyone have any insight????

thanks!!

"Yankee Imperialist Dog" <Ya******************@discussions.microsoft.com>
wrote in message
news:AE**********************************@microsof t.com...

>check to see if the value you are passing in is null (or nothing) this
will
give this error sometimes. I know that you should get a "not set to an
instance ... " because you are using find control", but other than you
just
named the parameters wrong along the way this is all i can think of
--
Share The Knowledge. I need all the help I can get and so do you!
"Cirene" wrote:

>>I have a stored procedure named insertcompany.

I keep getting the error:
Sys.webforms.pagerequestmanagerservererrorexcept ion: Procedure or
function
'InsertCompany' expects parameter '@ApptPhone1Required', which was not
supplied.

But, I DID supply it along with all others.... (here's a snippet)

MyCommand.Parameters.AddWithValue("@Instructions Operator",
CType(multiPage.FindControl("txtInstructionsOper ator"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@Instructions Customer",
CType(multiPage.FindControl("txtInstructionsCust omer"), TextBox).Text)
MyCommand.Parameters.AddWithValue("@ApptPhone1Re quired",
CType(multiPage.FindControl("checkbox1"), CheckBox).Checked)
MyCommand.Parameters.AddWithValue("@ApptPhone1Sh ow",
CType(multiPage.FindControl("checkbox2"), CheckBox).Checked)

Any ideas what is wrong with this? The other params seem to work fine.