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?
