johnnyg123
asked on
access stored proc value from vb.net
I have a stored proc named spTierCredits_PlayerID
(I am passing in an input parameter named playerid)
that does a bunch of processing to dettermine an end value for
DECLARE @TotalTableSlotTierCredits AS DECIMAL(18, 2);
....
SET @TotalTableSlotTierCredits = isnull(@TotalTableTierCred its,0) + isnull(@TotalSlotTierCredi ts,0)
From what I have read I should be able to get this in a vb.net app without defining
@TotalTableSlotTierCredits as an output variable.
I am having some trouble though
strConn = ConfigurationManager.Conne ctionStrin gs("DBConn ectStringP layerTierI nfo").Conn ectionStri ng
Dim cn As New SqlClient.SqlConnection(st rConn)
cn.Open()
Dim strsql As String
strsql = "spTierCredits_PlayerID"
Dim param As New SqlClient.SqlParameter
Dim cmd As New SqlClient.SqlCommand(strsq l, cn)
cmd.CommandType = CommandType.StoredProcedur e
param = cmd.Parameters.Add("@playe rid", SqlDbType.VarChar, 0)
cmd.Parameters(0).Value = intPlayerid
Dim rdr As SqlClient.SqlDataReader = cmd.ExecuteReader()
If rdr.Read() = False Then
lblFeedback.Text = "No Player Id found for card swiped"
lblFeedback.CssClass = "errorMsg"
divFeedbackHolder.Visible = True
lblTotalTierCreditsValue.T ext = ""
rdr.Close()
txtCardID.Text = ""
Exit Sub
Else
intPlayerid = rdr.Item("PlayerID")
End If
rdr.Close()
cn.Close()
txtCardID.Text = ""
(I am passing in an input parameter named playerid)
that does a bunch of processing to dettermine an end value for
DECLARE @TotalTableSlotTierCredits
....
SET @TotalTableSlotTierCredits
From what I have read I should be able to get this in a vb.net app without defining
@TotalTableSlotTierCredits
I am having some trouble though
strConn = ConfigurationManager.Conne
Dim cn As New SqlClient.SqlConnection(st
cn.Open()
Dim strsql As String
strsql = "spTierCredits_PlayerID"
Dim param As New SqlClient.SqlParameter
Dim cmd As New SqlClient.SqlCommand(strsq
cmd.CommandType = CommandType.StoredProcedur
param = cmd.Parameters.Add("@playe
cmd.Parameters(0).Value = intPlayerid
Dim rdr As SqlClient.SqlDataReader = cmd.ExecuteReader()
If rdr.Read() = False Then
lblFeedback.Text = "No Player Id found for card swiped"
lblFeedback.CssClass = "errorMsg"
divFeedbackHolder.Visible = True
lblTotalTierCreditsValue.T
rdr.Close()
txtCardID.Text = ""
Exit Sub
Else
intPlayerid = rdr.Item("PlayerID")
End If
rdr.Close()
cn.Close()
txtCardID.Text = ""
Does your sproc return this value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.