como ejecutar un procedimiento almacenado desde visual basic.2008

[Aquaventus]

te falta abrir la conexion :

Código vb.net:

Try
Dim cnn As New SqlConnection
 
cnn.ConnectionString = "data source= " & cmbservidor.Text & ";" & "database= " & txtbasededatos.Text & ";" & " user= " & txtusuario.Text & ";" & " Password= " & txtcontraseña.Text
 
obj = "execute SP_Contabilidad values(" + mes + "," + "," + diaI + "," + diaF + "," + tipo + ")"
cnn.Open()
Dim cmd As New SqlCommand(obj, cnn)
cnn.Close()
Catch ex As Exception
cnn.Close()
MsgBox(ex.Message)
End Try