如何将数据库表值添加到组合框项 [英] how to add database table values to combobox items

问题描述

如何使用
在运行时添加数据库表值以在组合框下拉视图中列出

vb.net编码

how to add database table values to list out in the combobox dropdown view at runtime by using


vb.net coding

推荐答案

Google！ http://www. google.co.uk/search?gcx=w&sourceid=chrome&ie=UTF-8&q=link+combobox+to+database [

Google! http://www.google.co.uk/search?gcx=w&sourceid=chrome&ie=UTF-8&q=link+combobox+to+database[^]

Loads of results.

In future, please try to do at least basic research before wasting your time and ours.

这很简单，只需从数据库中创建DataView，然后将ComboBox绑定到此DataView .
以下方法创建DataView:

It''s very simple just create DataView from your DataBase and after that bind your ComboBox to this DataView.
Following Method Creates DataView :

Public Sub CreateDataView()
   Dim objda As OleDbDataAdapter = New OleDbDataAdapter
   Dim objdataset As DataSet = New DataSet
   objda.SelectCommand = New OleDbCommand
   objda.SelectCommand.Connection = Conn 'Conn is your Connection Object.   
   Conn.Open() 'Open DataBase Connection
   objda.SelectCommand.CommandText = "Select * FROM TableName"
   objda.Fill(objdataset, "TableName")
   dv = New DataView(objdataset.Tables("TableName"))
End Sub

在Form Load Event上调用此方法，然后在下面的代码中编写以下代码以将ComboBox与DataView绑定:

Call this method on Form Load Event and below that write following code to bind your ComboBox with DataView :

Me.ComboBox1.DataBindings.Clear()
Me.ComboBox1.DataBindings.Add("Text", dv, "FieldName")

希望对您有帮助. :)

I hope it will help you. :)

这篇关于如何将数据库表值添加到组合框项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！