Re: number of parameters in stored procedure
From: Rick Sawtell (quickening_at_msn.com)
Date: 01/11/05
- Next message: Chuck: "Port 1433 won't bind"
- Previous message: Andrew J. Kelly: "Re: cacheRemove"
- In reply to: JIM.H.: "Q: number of parameters in stored procedure"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 13:52:12 -0600
"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:CD0A7CF4-2C24-45EE-83DD-EAD09D4DAFDE@microsoft.com...
> Hello,
> I am using a stored procedure with 28 input parameter to insert to a SQL
> table. It gives too many argument error when I compile my asp.net
> application.
>
> My asp.net application accepts data entry about employees and tries to
> import is into a table by calling a stored procedure. If there is a
> restriction in number of parameters, what else could I use to get data
> from
> user and import into a table?
> Thanks,
> Jim.
>
How are you creating/calling the sproc in ASP.NET? Are you instantiating a
command object and 28 parameter objects, or are you simple calling a sproc
with a connection.Execute command or something else?
Check your commas etc. ;-)
Rick Sawtell
MCT, MCSD, MCDBA
- Next message: Chuck: "Port 1433 won't bind"
- Previous message: Andrew J. Kelly: "Re: cacheRemove"
- In reply to: JIM.H.: "Q: number of parameters in stored procedure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
