hi there.

I basically want, whatever output SQL gives, to be placed in a paramater in Vb.NET

is it possible?

i have a storeproc in SQL which does a query based on the ID (which is the input param sent from Vb.NET), after that, the result given in SQL, i wish for that value (result) to be given back to VB.NET in a variable.

how do i do that?

this is what i have for now:

Code:
        Dim mySQLCommand1 As New SqlClient.SqlCommand("getGeneralOwnerID", sqlconn)
        sqlconn.Open()

        mySQLCommand.CommandText = "getGeneralOwnerID"
        mySQLCommand.CommandType = CommandType.StoredProcedure
        Dim genid As New SqlClient.SqlParameter("@mainID", SqlDbType.Int)

        genid.Value = CInt(lblID.Text)
        genid.Direction = ParameterDirection.Input
        mySQLCommand.Parameters.Add(genid)
        sqlconn.Close()

in SQL, what would the syntax be for telling it to OUTPUT the result back to VB.NET?