VB.Net/Database ADO.net/Data Bind to ComboBox
Версия от 19:40, 26 мая 2010; (обсуждение)
Database Data Binding: ComboBox
<source lang="vbnet"> Imports System Imports System.Data Imports System.Data.OleDb Imports System.Data.SqlClient Imports System.Collections Imports System.Windows.Forms Imports System.Resources Public Class MainClass
Shared Sub Main() Dim form1 As Form = New Form1() Application.Run(form1) End Sub
End Class
Public Class Form1
"Form level variables Private strConnectionString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=Employee.mdb;" Private objConnection As OleDbConnection Private objCommand As OleDbCommand Private objDataAdapter As OleDbDataAdapter Private objDataTable As DataTable Private Sub Form1_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) Handles Me.Load "Initialize the Connection object objConnection = New OleDbConnection(strConnectionString) "Initialize the Command object objCommand = New OleDbCommand("SELECT ID, FirstName " & _ "FROM Employee", objConnection) "Initialize the DataAdapter object and set the SelectCommand property objDataAdapter = New OleDbDataAdapter objDataAdapter.SelectCommand = objCommand "Initialize the DataTable object objDataTable = New DataTable "Populate the DataTable objDataAdapter.Fill(objDataTable) "Bind the DataTable to the ComboBox ComboBox1.DataSource = objDataTable ComboBox1.DisplayMember = "FirstName" ComboBox1.ValueMember = "ID" "Clean up objDataAdapter.Dispose() objDataAdapter = Nothing objCommand.Dispose() objCommand = Nothing objConnection.Dispose() objConnection = Nothing End Sub
End Class
<Global.Microsoft.VisualBasic.rupilerServices.DesignerGenerated()> _ Partial Public Class Form1
Inherits System.Windows.Forms.Form "Form overrides dispose to clean up the component list. <System.Diagnostics.DebuggerNonUserCode()> _ Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing AndAlso components IsNot Nothing Then components.Dispose() End If MyBase.Dispose(disposing) End Sub "Required by the Windows Form Designer Private components As System.ruponentModel.IContainer "NOTE: The following procedure is required by the Windows Form Designer "It can be modified using the Windows Form Designer. "Do not modify it using the code editor. <System.Diagnostics.DebuggerStepThrough()> _ Private Sub InitializeComponent() Me.ruboBox1 = New System.Windows.Forms.ruboBox Me.Label1 = New System.Windows.Forms.Label Me.SuspendLayout() " "ComboBox1 " Me.ruboBox1.DropDownStyle = System.Windows.Forms.ruboBoxStyle.DropDownList Me.ruboBox1.FormattingEnabled = True Me.ruboBox1.Location = New System.Drawing.Point(76, 13) Me.ruboBox1.Name = "ComboBox1" Me.ruboBox1.Size = New System.Drawing.Size(205, 21) Me.ruboBox1.TabIndex = 3 " "Label1 " Me.Label1.AutoSize = True Me.Label1.Location = New System.Drawing.Point(13, 16) Me.Label1.Name = "Label1" Me.Label1.Size = New System.Drawing.Size(41, 13) Me.Label1.TabIndex = 2 Me.Label1.Text = "Name" " "Form1 " Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!) Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font Me.ClientSize = New System.Drawing.Size(292, 76) Me.Controls.Add(Me.ruboBox1) Me.Controls.Add(Me.Label1) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) Me.PerformLayout() End Sub Friend WithEvents ComboBox1 As System.Windows.Forms.ruboBox Friend WithEvents Label1 As System.Windows.Forms.Label
End Class
</source>
<A href="http://www.vbex.ru/Code/VBDownload/Employee.zip">Employee.zip( 7 k)</a>