Can someone tell me where to post a code question for the following

[jbonifacejr]

Sorry if this angers anyone. I'm posting here and to the .NET group. I
am unable to get a return value from a stored procedure in .NET using
the following Sproc and .NET code
Here is the code in my stored proc.

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[sprocRetArtistS erial]
-- Add the parameters for the stored procedure here
@sArtist varchar(50),
@sRetArtist bigint OUTPUT
AS
BEGIN
SET @sRetArtist = (SELECT artSerial FROM tblArtists WHERE artName =
@sArtist)
END
I am calling it like this....

Dim iArtSer As Integer
Dim sProc As ADODB.Command
sProc = New ADODB.Command
sProc.CommandTe xt = "sprocRetArtist Serial"
sProc.CommandTy pe = ADODB.CommandTy peEnum.adCmdSto redProc
sProc.ActiveCon nection = oConn 'the connection is open and
global

sProc.Parameter s.Append(sProc. CreateParameter ("@sArtist",
ADODB.DataTypeE num.adVarChar,
ADODB.Parameter DirectionEnum.a dParamInput, 50, "Iron Maiden"))
sProc.Parameter s.Append(sProc. CreateParameter ("@sRetArtis t",
ADODB.DataTypeE num.adBigInt,
ADODB.Parameter DirectionEnum.a dParamOutput))

sProc.Execute()
iArtSer = sProc("@sRetArt ist).Value

[Cor Ligthert [MVP]]

When you want a Microsoft newsgroup than you can think about,
microsoft.publi c.data.ado.

Be aware that your code is not the modernst, you can also look for an older
book from Bill Vaughn (not the newer ones)

Cor
"jbonifacej r" <jb*********@ho tmail.comschree f in bericht
news:11******** **************@ o5g2000hsb.goog legroups.com...

Sorry if this angers anyone. I'm posting here and to the .NET group. I
am unable to get a return value from a stored procedure in .NET using
the following Sproc and .NET code
Here is the code in my stored proc.

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[sprocRetArtistS erial]
-- Add the parameters for the stored procedure here
@sArtist varchar(50),
@sRetArtist bigint OUTPUT
AS
BEGIN
SET @sRetArtist = (SELECT artSerial FROM tblArtists WHERE artName =
@sArtist)
END
I am calling it like this....

Dim iArtSer As Integer
Dim sProc As ADODB.Command
sProc = New ADODB.Command
sProc.CommandTe xt = "sprocRetArtist Serial"
sProc.CommandTy pe = ADODB.CommandTy peEnum.adCmdSto redProc
sProc.ActiveCon nection = oConn 'the connection is open and
global

sProc.Parameter s.Append(sProc. CreateParameter ("@sArtist",
ADODB.DataTypeE num.adVarChar,
ADODB.Parameter DirectionEnum.a dParamInput, 50, "Iron Maiden"))
sProc.Parameter s.Append(sProc. CreateParameter ("@sRetArtis t",
ADODB.DataTypeE num.adBigInt,
ADODB.Parameter DirectionEnum.a dParamOutput))

sProc.Execute()
iArtSer = sProc("@sRetArt ist).Value

[RobinS]

Why are you using ADODB in .Net instead of ADO.Net?

Robin S.
----------------------------
"jbonifacej r" <jb*********@ho tmail.comwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...

Sorry if this angers anyone. I'm posting here and to the .NET group. I
am unable to get a return value from a stored procedure in .NET using
the following Sproc and .NET code
Here is the code in my stored proc.

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[sprocRetArtistS erial]
-- Add the parameters for the stored procedure here
@sArtist varchar(50),
@sRetArtist bigint OUTPUT
AS
BEGIN
SET @sRetArtist = (SELECT artSerial FROM tblArtists WHERE artName =
@sArtist)
END
I am calling it like this....

Dim iArtSer As Integer
Dim sProc As ADODB.Command
sProc = New ADODB.Command
sProc.CommandTe xt = "sprocRetArtist Serial"
sProc.CommandTy pe = ADODB.CommandTy peEnum.adCmdSto redProc
sProc.ActiveCon nection = oConn 'the connection is open and
global

sProc.Parameter s.Append(sProc. CreateParameter ("@sArtist",
ADODB.DataTypeE num.adVarChar,
ADODB.Parameter DirectionEnum.a dParamInput, 50, "Iron Maiden"))
sProc.Parameter s.Append(sProc. CreateParameter ("@sRetArtis t",
ADODB.DataTypeE num.adBigInt,
ADODB.Parameter DirectionEnum.a dParamOutput))

sProc.Execute()
iArtSer = sProc("@sRetArt ist).Value