Using stored procedures

[yablonka]

Hello,

I created a stored procedure which receive a few parameters and inserts them into the DB according to some conditions,
BUT - Im very new to VB.NET, how do I call the store procedure at runtime and how do I pass the parameters???

Thank you,

 

[Derek Stone]

The process is quite similar to executing a SQL statement.

Dim oConnection As SqlConnection = New SqlConnection()
Dim oConnection As SqlCommand = New SqlCommand()
Dim oDataReader As SqlDataReader
			
oConnection.Open()
			
oCommand.CommandType = CommandType.StoredProcedure
oCommand.CommandText = "storedProcedureName"
oCommand.Connection = oConnection

Dim oParameter1 As SqlParameter = oCommand.Parameters.Add("@iInteger", SqlDbType.Int)
oParameter1.Value = 1
			
oDataReader = oCommand.ExecuteReader()
			
While (oDataReader.Read())
	 If the stored procedure does not return rows "oDataReader" is unnecessary
	 and a call to "oCommand.ExecuteNonQuery()" or "oCommand.ExecuteScalar()"
	 should be used instead
End While
			
oDataReader.Close()
oConnection.Close()