Hello Guys...

 Under VB.Net+Ado.Net (SqlClient) how do to get de value returned from a SP
 This is my SP

as

        Begin
                Return 1        -- Value already exists, Exit Function
        End
        Else
        Begin
                Return 0
        End

 Thankssssssssssssssss
  Genival - Japan

This demonstrates how to return the data from a SP to a datareader :

Private objCONN As SqlConnection
Private objCMD As SqlCommand
Public reader As SqlDataReader

objCONN = New SqlConnection(connection_string)
objCMD.Connection = objCONN

objCMD.CommandText = "spGLBCONExistsCountry"

reader = objCMD.ExecuteReader()

 While objDR.reader.Read
   debug.writeline(reader("fieldname"))
 End While

Hope it gives a clue

Allan

Sorry forgot one thing :

objCMD.CommandType = CommandType.StoredProcedure

Allan