组合框到ms访问 [英] combo box to ms access

问题描述

组合框(vb.net)我需要掉入ms access中存储的选项

combo box(vb.net)i need to fall option that stored in ms access how to do that

推荐答案

莫里什，

您需要使用数据集填充组合框.
这是您的操作方法.

Hi Morrish,

You need to fill the combobox using Dataset.
Here''s how you could do it.

Dim conn As New SqlConnection(connString)

Dim strSQL As String = "SELECT * FROM Disk"
Dim da As New SqlDataAdapter(strSQL, conn)
Dim ds As New DataSet
da.Fill(ds, "Disk")

With ComboBox1
    .DataSource = ds.Tables("Disk")
    .DisplayMember = "Disk_Name"
    .ValueMember = "Disk_Key"
    .SelectedIndex = 0
End With

这篇关于组合框到ms访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！