如題
可以像TextBox一样绑定数据字段!
将combobox1绑定到DataSet1中的表MyTable中的CompanyName列.代码如下:
comboBox1.dataSource=DataSet1
comboBox1.displayMember="MyTable.CompanyName"
将combobox1绑定到DataView1或DataTable1的CompanyName列.代码如下:
comboBox1.dataSource=DataView1 或 comboBox1.dataSource=DataTable1
comboBox1.displayMember="CompanyName"
Private Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.iobj_customerquery = New Class_CustomerQuery(Me.GetSession)
Class_CustomerQuery(Me.GetSession) 是一個聯接數據庫類
Dim ldst_result As New DataSet
Dim ldtb_result As DataTable
Dim lstg_sql As New System.Text.StringBuilder(1000)
lstg_sql.Append(" select customer_name , customer_code from customer ")
ldtb_result = Me.GetSession.GetDatabaseConnection.ExecuteSQLStatementQuery(lstg_sql.ToString)
Me.cbx_customer_name.DataSource = ldtb_result
Me.cbx_customer_name.DisplayMember = "customer_name"
Me.cbx_customer_name.ValueMember = "customer_name"
End Sub
樓主需要聯接數據庫的類的話,可以聯繫我