By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,385 Members | 847 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,385 IT Pros & Developers. It's quick & easy.

mass adding parameters t sql procedures

P: n/a
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 !
Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Renjith,
Check out the Microsoft Data Application Block for .NET.

http://www.gotdotnet.com/workspaces/...c-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 !


Nov 19 '05 #2

P: n/a
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/...c-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 !


Nov 19 '05 #3

P: n/a
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

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.