473,503 Members | 2,322 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with return value.

Hello All!

I have a value in a textbox(txbTableIDm.Text ) that I would like to use in a
paremiter in a SP I wrote, and then have the select statement work off that
parememter, retireive a diffrent value in another(txbCredits) texbox. Heres
the code:
Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand
Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If

ConCred.Open()
prmUser_To.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(prmUser_To)

<ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
txbCredits.Text = Convert.ToString(prmUser_To)
ConCred.Close()

End Sub

Just in case, here is the SP it's calling
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
Nvarchar(50) OUT
AS
SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
return (@Return_Credit)
GO

Any thoughts?

TIA!!

Rudy

Apr 22 '06 #1
7 1905
Standard question #2:
What error message do you get?

You have two parameters in the stored procedure, but you are only adding one
parameter to the command object. You have to add two parameters.
Apr 22 '06 #2
Hi Guffa!
My Bad. I was doing this late last night, first attempt.
This is what I have changed
ConCred.Open()
Dim Returned As New SqlParameter("@Returned_Credit",
SqlDbType.NVarChar, 50)

Returned.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(Returned)

<ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader<ERROR>
txbCredits.Text = Convert.ToString(Returned.Value)

ConCred.Close()
I'm getting an error of "An unhandled exception of type
'System.Data.SqlClient.SqlException' occurred in system.data.dll" at the
above line.
I'm pretty sure my SP is correct, but I'll double check that.

Thanks for your help on this!!!

Rudy

"Guffa" wrote:
Standard question #2:
What error message do you get?

You have two parameters in the stored procedure, but you are only adding one
parameter to the command object. You have to add two parameters.

Apr 22 '06 #3
Why do call cmdCred.ExecuteReader? You only need a single value returned.
By getting a returned DataReader, you need to call DataRead.Read() to get
the first row of data, it there is any.

In your case, you simply:

cmdCred.ExecuteNonQuery()
txbCredits.Text = Convert.ToString(prmUser_To.Value)

And more important, I think, is that your SP is not correct, That is why the
error on command execution line.

SP's return type is INTEGER, not other type (you used nvarchar). Have you
actually tested your SP? Since @Return_Cred is OUTPUT parameter, in SP, you
only need to assign a value to it. You do not need to use REUTRN keyword in
SP to return value of output parameter. RETURN is mainly used in SP to
indicate executing status, such as if the SP succeeded or not.

Oddly enough, when you save a SP with this kind of error (Return
NonIntegerValue), the syntext checker did not identify it, At run time, SQL
Server trys to convert whatever value type to INTEGER type. If converting
fails, you get runtime error.

Also, in your SP, @Return_Cred should be declared as OUTPUT, not OUT (it
might be a typo when you did the post, though).

Anyway, test your SP before call it from somewhere outside SQL Server.
"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
Hello All!

I have a value in a textbox(txbTableIDm.Text ) that I would like to use in
a
paremiter in a SP I wrote, and then have the select statement work off
that
parememter, retireive a diffrent value in another(txbCredits) texbox.
Heres
the code:
Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand
Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If

ConCred.Open()
prmUser_To.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(prmUser_To)

<ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
txbCredits.Text = Convert.ToString(prmUser_To)
ConCred.Close()

End Sub

Just in case, here is the SP it's calling
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
Nvarchar(50) OUT
AS
SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
return (@Return_Credit)
GO

Any thoughts?

TIA!!

Rudy

Apr 22 '06 #4
Thank you Norman. Some good info! I'll check out my SP and code.

Rudy

"Norman Yuan" wrote:
Why do call cmdCred.ExecuteReader? You only need a single value returned.
By getting a returned DataReader, you need to call DataRead.Read() to get
the first row of data, it there is any.

In your case, you simply:

cmdCred.ExecuteNonQuery()
txbCredits.Text = Convert.ToString(prmUser_To.Value)

And more important, I think, is that your SP is not correct, That is why the
error on command execution line.

SP's return type is INTEGER, not other type (you used nvarchar). Have you
actually tested your SP? Since @Return_Cred is OUTPUT parameter, in SP, you
only need to assign a value to it. You do not need to use REUTRN keyword in
SP to return value of output parameter. RETURN is mainly used in SP to
indicate executing status, such as if the SP succeeded or not.

Oddly enough, when you save a SP with this kind of error (Return
NonIntegerValue), the syntext checker did not identify it, At run time, SQL
Server trys to convert whatever value type to INTEGER type. If converting
fails, you get runtime error.

Also, in your SP, @Return_Cred should be declared as OUTPUT, not OUT (it
might be a typo when you did the post, though).

Anyway, test your SP before call it from somewhere outside SQL Server.
"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
Hello All!

I have a value in a textbox(txbTableIDm.Text ) that I would like to use in
a
paremiter in a SP I wrote, and then have the select statement work off
that
parememter, retireive a diffrent value in another(txbCredits) texbox.
Heres
the code:
Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand
Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If

ConCred.Open()
prmUser_To.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(prmUser_To)

<ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
txbCredits.Text = Convert.ToString(prmUser_To)
ConCred.Close()

End Sub

Just in case, here is the SP it's calling
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
Nvarchar(50) OUT
AS
SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
return (@Return_Credit)
GO

Any thoughts?

TIA!!

Rudy


Apr 22 '06 #5
Hello All!!

OK, I'm begining to understand how this works, with the help from people on
this forum. But, I'm still hving some problems. I'm going to repost my
code, and the SP, along with how I tested it. My sp was wrong before, but
now it's correct. I changed a couple of things in my code, but I'm still
getting a system error.

Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand

Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=xxxxx")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If
Dim CredRet As New SqlParameter
CredRet.ParameterName = "@Credits"
CredRet.SqlDbType = SqlDbType.NVarChar
CredRet.Size = 50
CredRet.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(CredRet)
txbCredits.Text = Convert.ToString(CredRet.Value)

ConCred.Open()

cmdCred.ExecuteNonQuery()<<ERRORS HERE>>
'txbCredits.Text = Convert.ToString(Returned.Value)
ConCred.Close()
End Sub

MY Sp
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Credits nvarchar(50)
OUTPUT
AS
SELECT @Credits = Credits FROM Bankroll WHERE UserID= @UserID
RETURN @@ERROR

My test in QA
ECLARE @RC int
DECLARE @UserID varchar(50)
DECLARE @Credits nvarchar(50)

SET @UserID = '78c9c996-6a5c-41e0-b4c1-2d1926bd5075'
EXECUTE @RC = footbet.dbo.GetCredit
@UserID, @Credits OUTPUT

SELECT @RC AS ReturnCode, @Credits AS Credits
This worked just fine.

And the only error I get is system error. I made sure there is a value in
the table to pass ot the textbox. The texbox name is correct. Any ideas
where else I might look that could be causing?

As always, TIA!!!
A confused Rudy

"Norman Yuan" wrote:
Why do call cmdCred.ExecuteReader? You only need a single value returned.
By getting a returned DataReader, you need to call DataRead.Read() to get
the first row of data, it there is any.

In your case, you simply:

cmdCred.ExecuteNonQuery()
txbCredits.Text = Convert.ToString(prmUser_To.Value)

And more important, I think, is that your SP is not correct, That is why the
error on command execution line.

SP's return type is INTEGER, not other type (you used nvarchar). Have you
actually tested your SP? Since @Return_Cred is OUTPUT parameter, in SP, you
only need to assign a value to it. You do not need to use REUTRN keyword in
SP to return value of output parameter. RETURN is mainly used in SP to
indicate executing status, such as if the SP succeeded or not.

Oddly enough, when you save a SP with this kind of error (Return
NonIntegerValue), the syntext checker did not identify it, At run time, SQL
Server trys to convert whatever value type to INTEGER type. If converting
fails, you get runtime error.

Also, in your SP, @Return_Cred should be declared as OUTPUT, not OUT (it
might be a typo when you did the post, though).

Anyway, test your SP before call it from somewhere outside SQL Server.
"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
Hello All!

I have a value in a textbox(txbTableIDm.Text ) that I would like to use in
a
paremiter in a SP I wrote, and then have the select statement work off
that
parememter, retireive a diffrent value in another(txbCredits) texbox.
Heres
the code:
Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand
Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If

ConCred.Open()
prmUser_To.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(prmUser_To)

<ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
txbCredits.Text = Convert.ToString(prmUser_To)
ConCred.Close()

End Sub

Just in case, here is the SP it's calling
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
Nvarchar(50) OUT
AS
SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
return (@Return_Credit)
GO

Any thoughts?

TIA!!

Rudy


Apr 23 '06 #6
If you code is directly copied from your code, then you have an obvious
error: you did not add SQLParameter "pmtUser" to the SqlCommand "cmdCred",
hence the error when callthe cmdCred.ExecuteNonQuery(), because you did not
spply a required parameter.

"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:1C**********************************@microsof t.com...
Hello All!!

OK, I'm begining to understand how this works, with the help from people
on
this forum. But, I'm still hving some problems. I'm going to repost my
code, and the SP, along with how I tested it. My sp was wrong before, but
now it's correct. I changed a couple of things in my code, but I'm still
getting a system error.

Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand

Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=xxxxx")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If
Dim CredRet As New SqlParameter
CredRet.ParameterName = "@Credits"
CredRet.SqlDbType = SqlDbType.NVarChar
CredRet.Size = 50
CredRet.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(CredRet)
txbCredits.Text = Convert.ToString(CredRet.Value)

ConCred.Open()

cmdCred.ExecuteNonQuery()<<ERRORS HERE>>
'txbCredits.Text = Convert.ToString(Returned.Value)
ConCred.Close()
End Sub

MY Sp
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Credits nvarchar(50)
OUTPUT
AS
SELECT @Credits = Credits FROM Bankroll WHERE UserID= @UserID
RETURN @@ERROR

My test in QA
ECLARE @RC int
DECLARE @UserID varchar(50)
DECLARE @Credits nvarchar(50)

SET @UserID = '78c9c996-6a5c-41e0-b4c1-2d1926bd5075'
EXECUTE @RC = footbet.dbo.GetCredit
@UserID, @Credits OUTPUT

SELECT @RC AS ReturnCode, @Credits AS Credits
This worked just fine.

And the only error I get is system error. I made sure there is a value in
the table to pass ot the textbox. The texbox name is correct. Any ideas
where else I might look that could be causing?

As always, TIA!!!
A confused Rudy

"Norman Yuan" wrote:
Why do call cmdCred.ExecuteReader? You only need a single value
returned.
By getting a returned DataReader, you need to call DataRead.Read() to get
the first row of data, it there is any.

In your case, you simply:

cmdCred.ExecuteNonQuery()
txbCredits.Text = Convert.ToString(prmUser_To.Value)

And more important, I think, is that your SP is not correct, That is why
the
error on command execution line.

SP's return type is INTEGER, not other type (you used nvarchar). Have you
actually tested your SP? Since @Return_Cred is OUTPUT parameter, in SP,
you
only need to assign a value to it. You do not need to use REUTRN keyword
in
SP to return value of output parameter. RETURN is mainly used in SP to
indicate executing status, such as if the SP succeeded or not.

Oddly enough, when you save a SP with this kind of error (Return
NonIntegerValue), the syntext checker did not identify it, At run time,
SQL
Server trys to convert whatever value type to INTEGER type. If converting
fails, you get runtime error.

Also, in your SP, @Return_Cred should be declared as OUTPUT, not OUT (it
might be a typo when you did the post, though).

Anyway, test your SP before call it from somewhere outside SQL Server.
"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
> Hello All!
>
> I have a value in a textbox(txbTableIDm.Text ) that I would like to use
> in
> a
> paremiter in a SP I wrote, and then have the select statement work off
> that
> parememter, retireive a diffrent value in another(txbCredits) texbox.
> Heres
> the code:
> Public Sub GetCredit()
> Dim ConCred As SqlConnection
> Dim strCred As String
> Dim cmdCred As SqlCommand
> Dim daCred As SqlDataAdapter
>
> ConCred = New
> SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
> cmdCred = New SqlCommand("GetCredit", ConCred)
> cmdCred.CommandType = CommandType.StoredProcedure
>
> Dim prmUser_To As New SqlParameter
> prmUser_To.ParameterName = "@UserID"
> prmUser_To.SqlDbType = SqlDbType.VarChar
> prmUser_To.Size = 50
> If txbTableIDm.Text <> "" Then
> prmUser_To.Value = (txbTableIDm.Text)
> End If
>
> ConCred.Open()
> prmUser_To.Direction = ParameterDirection.Output
> cmdCred.Parameters.Add(prmUser_To)
>
> <ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
> txbCredits.Text = Convert.ToString(prmUser_To)
> ConCred.Close()
>
> End Sub
>
> Just in case, here is the SP it's calling
> CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
> Nvarchar(50) OUT
> AS
> SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
> return (@Return_Credit)
> GO
>
> Any thoughts?
>
> TIA!!
>
> Rudy
>


Apr 24 '06 #7
Thanks Norman! I did catch that this afternoon, and it fixed my problem.
Thanks to everyone for helping me out!!

Rudy

"Norman Yuan" wrote:
If you code is directly copied from your code, then you have an obvious
error: you did not add SQLParameter "pmtUser" to the SqlCommand "cmdCred",
hence the error when callthe cmdCred.ExecuteNonQuery(), because you did not
spply a required parameter.

"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:1C**********************************@microsof t.com...
Hello All!!

OK, I'm begining to understand how this works, with the help from people
on
this forum. But, I'm still hving some problems. I'm going to repost my
code, and the SP, along with how I tested it. My sp was wrong before, but
now it's correct. I changed a couple of things in my code, but I'm still
getting a system error.

Public Sub GetCredit()
Dim ConCred As SqlConnection
Dim strCred As String
Dim cmdCred As SqlCommand

Dim daCred As SqlDataAdapter

ConCred = New
SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=xxxxx")
cmdCred = New SqlCommand("GetCredit", ConCred)
cmdCred.CommandType = CommandType.StoredProcedure

Dim prmUser_To As New SqlParameter
prmUser_To.ParameterName = "@UserID"
prmUser_To.SqlDbType = SqlDbType.VarChar
prmUser_To.Size = 50
If txbTableIDm.Text <> "" Then
prmUser_To.Value = (txbTableIDm.Text)
End If
Dim CredRet As New SqlParameter
CredRet.ParameterName = "@Credits"
CredRet.SqlDbType = SqlDbType.NVarChar
CredRet.Size = 50
CredRet.Direction = ParameterDirection.Output
cmdCred.Parameters.Add(CredRet)
txbCredits.Text = Convert.ToString(CredRet.Value)

ConCred.Open()

cmdCred.ExecuteNonQuery()<<ERRORS HERE>>
'txbCredits.Text = Convert.ToString(Returned.Value)
ConCred.Close()
End Sub

MY Sp
CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Credits nvarchar(50)
OUTPUT
AS
SELECT @Credits = Credits FROM Bankroll WHERE UserID= @UserID
RETURN @@ERROR

My test in QA
ECLARE @RC int
DECLARE @UserID varchar(50)
DECLARE @Credits nvarchar(50)

SET @UserID = '78c9c996-6a5c-41e0-b4c1-2d1926bd5075'
EXECUTE @RC = footbet.dbo.GetCredit
@UserID, @Credits OUTPUT

SELECT @RC AS ReturnCode, @Credits AS Credits
This worked just fine.

And the only error I get is system error. I made sure there is a value in
the table to pass ot the textbox. The texbox name is correct. Any ideas
where else I might look that could be causing?

As always, TIA!!!
A confused Rudy

"Norman Yuan" wrote:
Why do call cmdCred.ExecuteReader? You only need a single value
returned.
By getting a returned DataReader, you need to call DataRead.Read() to get
the first row of data, it there is any.

In your case, you simply:

cmdCred.ExecuteNonQuery()
txbCredits.Text = Convert.ToString(prmUser_To.Value)

And more important, I think, is that your SP is not correct, That is why
the
error on command execution line.

SP's return type is INTEGER, not other type (you used nvarchar). Have you
actually tested your SP? Since @Return_Cred is OUTPUT parameter, in SP,
you
only need to assign a value to it. You do not need to use REUTRN keyword
in
SP to return value of output parameter. RETURN is mainly used in SP to
indicate executing status, such as if the SP succeeded or not.

Oddly enough, when you save a SP with this kind of error (Return
NonIntegerValue), the syntext checker did not identify it, At run time,
SQL
Server trys to convert whatever value type to INTEGER type. If converting
fails, you get runtime error.

Also, in your SP, @Return_Cred should be declared as OUTPUT, not OUT (it
might be a typo when you did the post, though).

Anyway, test your SP before call it from somewhere outside SQL Server.
"Rudy" <Ru**@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
> Hello All!
>
> I have a value in a textbox(txbTableIDm.Text ) that I would like to use
> in
> a
> paremiter in a SP I wrote, and then have the select statement work off
> that
> parememter, retireive a diffrent value in another(txbCredits) texbox.
> Heres
> the code:
> Public Sub GetCredit()
> Dim ConCred As SqlConnection
> Dim strCred As String
> Dim cmdCred As SqlCommand
> Dim daCred As SqlDataAdapter
>
> ConCred = New
> SqlConnection("Server=localhost;UID=xxxx;PWD=xxxxx x;database=dbSTMBL")
> cmdCred = New SqlCommand("GetCredit", ConCred)
> cmdCred.CommandType = CommandType.StoredProcedure
>
> Dim prmUser_To As New SqlParameter
> prmUser_To.ParameterName = "@UserID"
> prmUser_To.SqlDbType = SqlDbType.VarChar
> prmUser_To.Size = 50
> If txbTableIDm.Text <> "" Then
> prmUser_To.Value = (txbTableIDm.Text)
> End If
>
> ConCred.Open()
> prmUser_To.Direction = ParameterDirection.Output
> cmdCred.Parameters.Add(prmUser_To)
>
> <ERROR>Dim reader As SqlDataReader = cmdCred.ExecuteReader
> txbCredits.Text = Convert.ToString(prmUser_To)
> ConCred.Close()
>
> End Sub
>
> Just in case, here is the SP it's calling
> CREATE PROCEDURE dbo.GetCredit @UserID varchar(50), @Return_Credit
> Nvarchar(50) OUT
> AS
> SELECT @Return_Credit = Credits FROM Bankroll WHERE UserID= @UserID
> return (@Return_Credit)
> GO
>
> Any thoughts?
>
> TIA!!
>
> Rudy
>


Apr 24 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3816
by: JesusFreak | last post by:
From: us_traveller@yahoo.com (JesusFreak) Newsgroups: microsoft.public.scripting.jscript Subject: toolbar script problem NNTP-Posting-Host: 192.92.126.136 Recently, I downloaded the following...
12
8450
by: SJD | last post by:
I've just read Christoph Schittko's article on XmlSerializer: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxmlnet/html/trblshtxsd.asp . . . and very informative it is too....
57
4233
by: Xarky | last post by:
Hi, I am writing a linked list in the following way. struct list { struct list *next; char *mybuff; };
0
3910
by: Lokkju | last post by:
I am pretty much lost here - I am trying to create a managed c++ wrapper for this dll, so that I can use it from c#/vb.net, however, it does not conform to any standard style of coding I have seen....
0
1543
by: michael | last post by:
Hi. I have a problem using the CollectioEditor. In my custom control I have a public property that returns ItemList. ItemList is inherited from CollectionBase and contains very simple items...
0
1582
by: Lucas, Todd | last post by:
Hello everyone! I'm having a problem with a WebControl that I'm designing for a Menu. I've been at it for about 3 weeks now, and can't seem to get around this problem. So I'm hoping that someone...
0
1630
by: Mike Hofer | last post by:
Hi everyone. I could really use some help. First, the backstory: ===================== I *really* need a 3-state checkbox for my ASP.NET application. Specifically, I need one that lets me set...
2
4427
by: ajikoe | last post by:
Hi, I tried to follow the example in swig homepage. I found error which I don't understand. I use bcc32, I already include directory where my python.h exist in bcc32.cfg. /* File : example.c...
12
2223
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my...
31
15306
by: ajos | last post by:
hi frnds, i have a form,which has 2 input text boxes, the values are entering the text boxes,when i leave the 2 text boxes blank and hit submit a java script gives the message that the 2 fields are...
0
7207
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7291
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7357
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7468
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5598
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4690
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3171
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1522
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
402
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.