execute a delete stored procedure?

[RMasters]

I am trying to execute a stored procedure that requires an input parameter, the purpose of the procedure is to delete a record in a table (based on the ID that I pass it)
I cannot find an example of this anywhere.

The stored procedure works fine, my problem is running it from code.

I would really appreciate some help.

 

[FRANDAZZO]

Dim oConn as System.Data.SqlClient.SqlConnection()
Dim oCMD as System.Data.SqlClient.SqlCommand()

'set your conn string and establish a sql connection

With oCmd
.Connection = oConn
.CommandText = "APP_DeleteUser"
.CommandType = CommandType.StoredProcedure.Parameters.Add("@UserId", System.Data.SqlDbType.Int).Value = yourId
.ExecuteNonQuery()

End With

 

[FRANDAZZO]

One more thing.

Set Command to nothing:
If Not IsNothing(oCmd) Then oCmd = Nothing

Close db connection:
oConn.Close

Set Connection to nothing:
If Not IsNothing(oConn) Then oConn= Nothing

 

[RMasters]

thanks frandazzo