求VB2015中，combobox1控件加载Access创建的表中的项目的方法 - 编程论坛

#2

xyxcc1772017-07-17 15:17

回复楼主 lhfwhrlzh

Dim strCon As String = "连接字符串"
        Dim connection As New OleDb.OleDbConnection(strCon)
        connection.Open()
        Dim strSql As String = "select username from user"
        Dim dt As New DataTable
        Dim da As New OleDb.OleDbDataAdapter(strSql, connection)
        da.Fill(dt)
        With combobox1
            .DataSource = dt
            .DisplayMember = "username"
            .ValueMember = "username"
        End With
        connection.Close()

#3

lhj564598972017-07-28 15:22

2楼赞 .DisplayMember = "username"不用就可以

#4

lhfwhrlzh2018-02-05 00:04

回复 2楼 xyxcc177

谢谢！