mass adding parameters t sql procedures

ive this procedure which needs some 10+ inputs as parameters. if i go by the
normal method of passing params to procedures in asp.net like
this(http://support.microsoft.com/kb/320916/EN-US/) it'll be really long.
isnt there some shorter way to specify the parameters like when we do EXEC in
Sql Query Analyser ? eg: EXEC CustomProcedure 1,'A%'

how can i do this?

thanx

--
Renjith Chembakarayil
- Is the world Round or Flat ? .. ive my doubts !Renjith,
Check out the Microsoft Data Application Block for .NET.

http://www.gotdotnet.com/workspaces...7c-aaeb21d1f431

It allows you to write one line SQL calls like this:

Dim dsData As DataSet = SqlHelper.ExecuteDataset(ConnectString,
"StoredProcedure", param1, param2)

This eliminates a lot of repetitive SQL boiler plate code, and answers
your question.
Jason

Renjith Chembakarayil wrote:
> ive this procedure which needs some 10+ inputs as parameters. if i go
by the
> normal method of passing params to procedures in asp.net like
> this(http://support.microsoft.com/kb/320916/EN-US/) it'll be really
long.
> isnt there some shorter way to specify the parameters like when we do
EXEC in
> Sql Query Analyser ? eg: EXEC CustomProcedure 1,'A%'
> how can i do this?
> thanx
> --
> Renjith Chembakarayil
> - Is the world Round or Flat ? .. ive my doubts !
Jason,
thanx man .. that is what i wanted ..

but i got a slight problem .. i downloaded & installed Data Application
Block v2 and later even the first version -- but still i cant load or import
the 'Microsoft.ApplicationBlocks.Data.dll' into my asp.net pages and i cant
find this dll anywhere on my hard disk. where am i supposed t find the dll &
load it ?

"Jason" wrote:

> Renjith,
> Check out the Microsoft Data Application Block for .NET.
> http://www.gotdotnet.com/workspaces...7c-aaeb21d1f431
> It allows you to write one line SQL calls like this:
> Dim dsData As DataSet = SqlHelper.ExecuteDataset(ConnectString,
> "StoredProcedure", param1, param2)
> This eliminates a lot of repetitive SQL boiler plate code, and answers
> your question.
> Jason
>
> Renjith Chembakarayil wrote:
> > ive this procedure which needs some 10+ inputs as parameters. if i go
> by the
> > normal method of passing params to procedures in asp.net like
> > this(http://support.microsoft.com/kb/320916/EN-US/) it'll be really
> long.
> > isnt there some shorter way to specify the parameters like when we do
> EXEC in
> > Sql Query Analyser ? eg: EXEC CustomProcedure 1,'A%'
> > how can i do this?
> > thanx
> > --
> > Renjith Chembakarayil
> > - Is the world Round or Flat ? .. ive my doubts !
>
Renjith,
Personally, I use v3.1. But in any case, check your program files
folder for either

C:\Program Files\Microsoft Application Blocks for .NET
C:\Program Files\GotDotNet\

You'll want to Add a reference to the dll file(s) into your project,
then rebuild and it should work.

Jason