VB.Net/Database ADO.net/Data Bind to ComboBox

Материал из VB Эксперт
Перейти к: навигация, поиск

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>