Stored Procedure call

[Steven K]

Hello,

With ASP, I could indicate that a variable was a stored procedure with
parameters by using "adcmdStoredProc", and set the data variable with one
line using the Execute command (cnnSearch is the connection):

Set spSearch = cnnSearch.Execute("sp_web_Search " &
"'FindRegionSubRegion','','',''", adcmdStoredProc)

ASP .Net
Following the help text in quickstart, I am now using two lines:
spSearch = New SqlDataAdapter("sp_web_Search " &
"'FindRegionSubRegion','','',''", cnnSearch)
spSearch.SelectCommand.CommandType = CommandType.StoredProcedure

The question I have is, with ASP .Net, is it possible to set the CommandType
in the first line somewhat like I could do with ASP?

--
Thanks in advance,

Steven

[Chris Jackson]

Unfortunately, there is no constructor for the SqlDataAdapter class that
takes a CommandType argument, and the default is Text. For the time being,
you are stuck with two lines of code.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"Steven K" <sk****@troop.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hello,

With ASP, I could indicate that a variable was a stored procedure with
parameters by using "adcmdStoredProc", and set the data variable with one
line using the Execute command (cnnSearch is the connection):

Set spSearch = cnnSearch.Execute("sp_web_Search " &
"'FindRegionSubRegion','','',''", adcmdStoredProc)

ASP .Net
Following the help text in quickstart, I am now using two lines:
spSearch = New SqlDataAdapter("sp_web_Search " &
"'FindRegionSubRegion','','',''", cnnSearch)
spSearch.SelectCommand.CommandType = CommandType.StoredProcedure

The question I have is, with ASP .Net, is it possible to set the
CommandType
in the first line somewhat like I could do with ASP?

--
Thanks in advance,

Steven

[richlm]

I agree - can't see how to do this directly in 1 line using classes in
System.Data.
Take a look at the Data Access Application Block - with that you can do
something like:

DataSet ds =
SqlHelper.ExecuteDataset(conn,CommandType.StoredPr ocedure,"sp_web_Search","F
indRegionSubRegion","a","b","c");
(using a variable argument list for the stored procedure parameters)

http://msdn.microsoft.com/library/de...ml/daab-rm.asp

Richard.

"Steven K" <sk****@troop.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hello,

With ASP, I could indicate that a variable was a stored procedure with
parameters by using "adcmdStoredProc", and set the data variable with one
line using the Execute command (cnnSearch is the connection):

Set spSearch = cnnSearch.Execute("sp_web_Search " &
"'FindRegionSubRegion','','',''", adcmdStoredProc)

ASP .Net
Following the help text in quickstart, I am now using two lines:
spSearch = New SqlDataAdapter("sp_web_Search " &
"'FindRegionSubRegion','','',''", cnnSearch)
spSearch.SelectCommand.CommandType = CommandType.StoredProcedure

The question I have is, with ASP .Net, is it possible to set the CommandType in the first line somewhat like I could do with ASP?

--
Thanks in advance,

Steven