I am trying to get the output from a stored procedure. When I enter a value into the stored procedure directly in SQL server management studio it works fine, but when I do it using my code I get nothing. But if I use cmd.parameters( "@oOCR").va lue then I get the first 5 characters, but the last 5 are all zeros. Here is my current code:
Code:
Public Sub GetPlayerCardNumber(ByVal input As String)
Dim con As SqlConnection = New SqlConnection("Data Source=" & DB1 & ";Initial Catalog=WinOasis;Persist Security Info=True;User ID=" _
& DBUsername & "; password=" & DBPassword)
Dim cmd As SqlCommand
Dim Ireturn As String
Dim SQLRdr As SqlDataReader
If con.State = ConnectionState.Closed Then con.Open()
cmd = New SqlCommand("GW_Magtoocr", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@iMag", SqlDbType.Char, 18)
cmd.Parameters("@iMag").Value = input
cmd.Parameters.Add("@oOCR", SqlDbType.VarChar, 10)
cmd.Parameters("@oOCR").Value = "4"
cmd.Parameters("@iMag").Direction = ParameterDirection.Input
cmd.Parameters("@oOCR").Direction = ParameterDirection.InputOutput
cmd.ExecuteNonQuery()
SQLRdr = cmd.ExecuteReader
While SQLRdr.Read
Ireturn = SQLRdr.GetValue(1)
End While
MsgBox(Ireturn)
con.Close()
'SQLRdr.Close()
End Sub
Comment