Consulta VB
Publicado por P@blo (7 intervenciones) el 26/05/2006 19:41:59
En el siguiente codigo corro un store procedure de SQL pero abriendo un formulario, como hago para que haga lo mismo sin abrir el formulario o como cierro el formulario automaticamente.
Dim cnn As ADODB.Connection
Private Sub Form_Load()
Set cnn = New ADODB.Connection
With cnn
.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=xxxxxxx;Initial Catalog=EtiquetasSQL;Data Source=W2K_BASES"
End With
Dim Cmd As ADODB.Command
Set Cmd = New ADODB.Command
With Cmd
.ActiveConnection = cnn
.CommandText = "pablo"
.CommandType = adCmdStoredProc
.Execute
End With
End Sub
Muchas gracias y slds.
Pablo
Dim cnn As ADODB.Connection
Private Sub Form_Load()
Set cnn = New ADODB.Connection
With cnn
.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=xxxxxxx;Initial Catalog=EtiquetasSQL;Data Source=W2K_BASES"
End With
Dim Cmd As ADODB.Command
Set Cmd = New ADODB.Command
With Cmd
.ActiveConnection = cnn
.CommandText = "pablo"
.CommandType = adCmdStoredProc
.Execute
End With
End Sub
Muchas gracias y slds.
Pablo
Valora esta pregunta


0