Ejecutar una sentencia NO Select

' cadena de conexión
Dim connectString As String = "database=derivatives;server=SRV01;User ID=samfisher;pwd=echelon"
' Objeto connection
Dim connection As SqlConnection = new SqlConnection(connectString)
' obertura
connection.Open()
' Objeto Command
Dim command As SqlCommand = new SqlCommand("UPDATE usr_contract set ctr_n = ctr_n + 1", connection)
' ejecución
Dim affectedrows As Integer = command.ExecuteNonQuery()
Console.WriteLine("Número de filas afectadas {0}", affectedrows)
' cierre connection
connection.Close()