Non riesco a farlo funzionare :master:

Sub Button_Click (sender As Object, e As EventArgs)
Dim myConnection as SqlConnection
Dim myCommand as SqlCommand
dim myParameter as SqlParameter

myConnection = New SqlConnection ("connessione")
myCommand = new SqlCommand ("StrUpdate", myConnection)
myCommand.CommandType = CommandType.StoredProcedure

myCommand.Parameters.Add("@nomevar1", textbox1.Text)
myCommand.Parameters.Add("@nomevar2", textbox2.Text)

myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
response.Clear()
End If
End Sub

e nella stored procedure:

CREATE PROCEDURE strUpdate
(
@nomevar1 varchar(100),
@nomevar2 varchar(50)
)
AS
DECLARE @nomevar3 int
SELECT @nomevar3= '3'

UPDATE tabella1 SET nomecam1 = @nomevar1 WHERE nomecam2 = @nomevar3
UPDATE tabella2 SET nomecam3 = @nomevar2 WHERE nomecam4 = @nomevar3

dove nomecam2 e nomecam4 hanno in relazione il valore di @nomevar3

dove sbaglio???