Coneccion de Combobox a base de datos
Publicado por Luz (1 intervención) el 11/02/2005 21:14:15
Tengo el siguiente codigo para conectarme desde un combobox a una base de datos en sybase, pero no me presenta datos en el combox, necesito ayuda. Gracias!!!
dim. myConnection As String
' If the connection string is null, use a default.
If myConnection = "" Then
myConnection = "PWD=rala78;DSN=DESARROLLO;UID=lbarrien;SRVR=DESARROLLO;DB=PRUEBA"
End If
Dim myConn As New Odbc.OdbcConnection(myConnection)
Dim mySelectQuery As String = "SELECT NOMB_DEPA FROM DEPA "
Dim myOdbcCommand As New Odbc.OdbcCommand(mySelectQuery)
myOdbcCommand.Connection = myConn
myConn.Open()
Me.CmbDepartamento.Items.Add(myOdbcCommand.ExecuteScalar)
Me.CmbDepartamento.Refresh()
'myOdbcCommand.ExecuteReader.NextResult()
myOdbcCommand.Connection.Close()
dim. myConnection As String
' If the connection string is null, use a default.
If myConnection = "" Then
myConnection = "PWD=rala78;DSN=DESARROLLO;UID=lbarrien;SRVR=DESARROLLO;DB=PRUEBA"
End If
Dim myConn As New Odbc.OdbcConnection(myConnection)
Dim mySelectQuery As String = "SELECT NOMB_DEPA FROM DEPA "
Dim myOdbcCommand As New Odbc.OdbcCommand(mySelectQuery)
myOdbcCommand.Connection = myConn
myConn.Open()
Me.CmbDepartamento.Items.Add(myOdbcCommand.ExecuteScalar)
Me.CmbDepartamento.Refresh()
'myOdbcCommand.ExecuteReader.NextResult()
myOdbcCommand.Connection.Close()
Valora esta pregunta


0