Private Sub folios_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection(Form1.conex)
Dim query As String = "select rut_empresa from empresas"
con.Open()
Using cmd As New SqlCommand(query, con)
Dim rs As SqlDataReader = cmd.ExecuteReader
While rs.Read
cbRutEmpresas.Items.Add(rs("rut_empresa").ToString)
End While
rs.Close()
End Using
con.Close()
End Sub
Private Sub folios_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection(Form1.conex)
Dim query As String = "select rut_empresa from empresas"
con.Open()
Using cmd As New SqlCommand(query, con)
Dim adapter As New SqlDataAdapter(cmd)
Dim table As New DataTable()
adapter.Fill(table)
cbRutEmpresas.DataSource = table
cbRutEmpresas.DisplayMember = "id" ' columna id de la tabla empresas
cbRutEmpresas.ValueMember = "rut_empresa" ' columna rut_empresa de la tabla rut_empresa
End Using
con.Close()
End Sub
fuente1
fuente2
fuente3
Mostrando las entradas con la etiqueta SqlDataReader. Mostrar todas las entradas
Mostrando las entradas con la etiqueta SqlDataReader. Mostrar todas las entradas
martes, 19 de febrero de 2019
cargar un combobox con datos sql
Etiquetas:
ComboBox,
sql,
SqlDataReader
viernes, 21 de abril de 2017
Leer tabla sql
Dim query As String = "SELECT * FROM tabla"
Try
Dim con As New SqlConnection(conex)
con.Open()
Dim cmd As New SqlCommand(query, con)
Dim dr As SqlDataReader = cmd.ExecuteReader()
While dr.Read
Dim id As String = dr.GetValue(0).ToString.Trim
Dim name As String = dr.GetValue(1).ToString.Trim
Dim code As String = dr.GetValue(2).ToString.Trim
End While
dr.Close()
con.Close()
Catch ex As Exception
End Try
Etiquetas:
ExecuteReader,
SqlCommand,
SqlConnection,
SqlDataReader
Suscribirse a:
Comentarios (Atom)