Can't get data from database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • smartguy05
    New Member
    • Aug 2010
    • 1

    Can't get data from database

    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
    Last edited by debasisdas; Aug 26 '10, 06:36 AM. Reason: Formatted using code tags.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Please check this, just might help you.

    Comment

    Working...