VB.Net/Database ADO.net/Data bind to ListBox
Bind data to ListBox
<source lang="vbnet"> Imports System Imports System.Data Imports System.Windows.Forms Imports System.Data.SqlClient public class MainClass
Shared Sub Main() Dim form1 As Form = New Form1 Application.Run(form1) End Sub
End Class
Public Class Form1
Inherits System.Windows.Forms.Form
- Region " Windows Form Designer generated code "
Public Sub New() MyBase.New() "This call is required by the Windows Form Designer. InitializeComponent() "Add any initialization after the InitializeComponent() call End Sub "Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If 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. Friend WithEvents ListBox1 As System.Windows.Forms.ListBox Friend WithEvents TextBox1 As System.Windows.Forms.TextBox Friend WithEvents TextBox2 As System.Windows.Forms.TextBox Friend WithEvents DataSet1 As System.Data.DataSet <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.ListBox1 = New System.Windows.Forms.ListBox Me.TextBox1 = New System.Windows.Forms.TextBox Me.TextBox2 = New System.Windows.Forms.TextBox Me.DataSet1 = New System.Data.DataSet CType(Me.DataSet1, System.ruponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() " "ListBox1 " Me.ListBox1.Location = New System.Drawing.Point(8, 8) Me.ListBox1.Name = "ListBox1" Me.ListBox1.Size = New System.Drawing.Size(272, 95) Me.ListBox1.TabIndex = 0 " "TextBox1 " Me.TextBox1.Location = New System.Drawing.Point(8, 112) Me.TextBox1.Name = "TextBox1" Me.TextBox1.Size = New System.Drawing.Size(128, 20) Me.TextBox1.TabIndex = 1 Me.TextBox1.Text = "TextBox1" " "TextBox2 " Me.TextBox2.Location = New System.Drawing.Point(152, 112) Me.TextBox2.Name = "TextBox2" Me.TextBox2.Size = New System.Drawing.Size(128, 20) Me.TextBox2.TabIndex = 2 Me.TextBox2.Text = "TextBox2" " "DataSet1 " Me.DataSet1.DataSetName = "NewDataSet" Me.DataSet1.Locale = New System.Globalization.CultureInfo("en-GB") " "Form1 " Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 149) Me.Controls.Add(Me.TextBox2) Me.Controls.Add(Me.TextBox1) Me.Controls.Add(Me.ListBox1) Me.Name = "Form1" Me.Text = "Form1" CType(Me.DataSet1, System.ruponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub
- End Region
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load "Create Connection object Dim thisConnection As New SqlConnection _ ("server=(local)\SQLEXPRESS;" & _ "integrated security=sspi;" & _ "database=MyDatabase") " Sql Query Dim sql As String = _ "SELECT FirstName, LastName FROM Employee" " Create Data Adapter Dim da As New SqlDataAdapter(sql, thisConnection) " Fill Dataset and Create DataTable da.Fill(DataSet1, "Employee") Dim dt As DataTable = DataSet1.Tables("Employee") ListBox1.DataSource = dt ListBox1.DisplayMember = "FirstName" " Bind to firstname column of the employees table TextBox1.DataBindings.Add("text", dt, "FirstName") " Bind to lastname column of the employees table TextBox2.DataBindings.Add("text", dt, "LastName") End Sub
End Class
</source>
Multi-Control Data Binding
<source lang="vbnet"> Imports System.Data.SqlClient Imports System.Windows.Forms <Global.Microsoft.VisualBasic.rupilerServices.DesignerGenerated()> _ Partial Class BoundForm
Inherits System.Windows.Forms.Form <System.Diagnostics.DebuggerStepThrough()> _ Private Sub InitializeComponent() Me.gridDB = New System.Windows.Forms.DataGridView Me.Label3 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Label1 = New System.Windows.Forms.Label Me.dtBirth = New System.Windows.Forms.DateTimePicker Me.lstID = New System.Windows.Forms.ListBox Me.txtLastName = New System.Windows.Forms.TextBox Me.txtFirstName = New System.Windows.Forms.TextBox CType(Me.gridDB, System.ruponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() " Me.gridDB.Anchor = CType((((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Bottom) _ Or System.Windows.Forms.AnchorStyles.Left) _ Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles) Me.gridDB.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize Me.gridDB.Location = New System.Drawing.Point(12, 126) Me.gridDB.Name = "gridDB" Me.gridDB.Size = New System.Drawing.Size(348, 132) Me.gridDB.TabIndex = 17 " "Label3 " Me.Label3.Location = New System.Drawing.Point(116, 77) Me.Label3.Name = "Label3" Me.Label3.Size = New System.Drawing.Size(68, 16) Me.Label3.TabIndex = 16 Me.Label3.Text = "Birth Date:" " "Label2 " Me.Label2.Location = New System.Drawing.Point(116, 45) Me.Label2.Name = "Label2" Me.Label2.Size = New System.Drawing.Size(68, 16) Me.Label2.TabIndex = 15 Me.Label2.Text = "Last Name:" " "Label1 " Me.Label1.Location = New System.Drawing.Point(116, 17) Me.Label1.Name = "Label1" Me.Label1.Size = New System.Drawing.Size(68, 16) Me.Label1.TabIndex = 14 Me.Label1.Text = "First Name:" " "dtBirth " Me.dtBirth.Format = System.Windows.Forms.DateTimePickerFormat.[Short] Me.dtBirth.Location = New System.Drawing.Point(192, 73) Me.dtBirth.Name = "dtBirth" Me.dtBirth.Size = New System.Drawing.Size(132, 21) Me.dtBirth.TabIndex = 13 " "lstID " Me.lstID.Location = New System.Drawing.Point(12, 9) Me.lstID.Name = "lstID" Me.lstID.Size = New System.Drawing.Size(68, 108) Me.lstID.TabIndex = 12 " "txtLastName " Me.txtLastName.Location = New System.Drawing.Point(192, 41) Me.txtLastName.Name = "txtLastName" Me.txtLastName.Size = New System.Drawing.Size(132, 21) Me.txtLastName.TabIndex = 11 " "txtFirstName " Me.txtFirstName.Location = New System.Drawing.Point(192, 13) Me.txtFirstName.Name = "txtFirstName" Me.txtFirstName.Size = New System.Drawing.Size(132, 21) Me.txtFirstName.TabIndex = 10 " "BoundForm " Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!) Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font Me.ClientSize = New System.Drawing.Size(372, 266) Me.Controls.Add(Me.gridDB) Me.Controls.Add(Me.Label3) Me.Controls.Add(Me.Label2) Me.Controls.Add(Me.Label1) Me.Controls.Add(Me.dtBirth) Me.Controls.Add(Me.lstID) Me.Controls.Add(Me.txtLastName) Me.Controls.Add(Me.txtFirstName) Me.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte)) Me.Name = "BoundForm" Me.Text = "BoundForm" CType(Me.gridDB, System.ruponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) Me.PerformLayout() End Sub Friend WithEvents gridDB As System.Windows.Forms.DataGridView Friend WithEvents Label3 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Label1 As System.Windows.Forms.Label Friend WithEvents dtBirth As System.Windows.Forms.DateTimePicker Friend WithEvents lstID As System.Windows.Forms.ListBox Friend WithEvents txtLastName As System.Windows.Forms.TextBox Friend WithEvents txtFirstName As System.Windows.Forms.TextBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim Connect As String = "Data Source=localhost;Integrated Security=True;Initial Catalog=Northwind;" Dim con As New SqlConnection(Connect) Dim SQL As String = "SELECT * FROM Employees" Dim cmd As New SqlCommand(SQL, con) Dim adapter As New SqlDataAdapter(cmd) Dim dsNorthwind As New DataSet() con.Open() adapter.Fill(dsNorthwind, "Employees") con.Close() gridDB.DataSource = dsNorthwind.Tables("Employees") txtFirstName.DataBindings.Add("Text", dsNorthwind.Tables("Employees"), "FirstName") txtLastName.DataBindings.Add("Text", dsNorthwind.Tables("Employees"), "LastName") lstID.DataSource = dsNorthwind.Tables("Employees") lstID.DisplayMember = "EmployeeID" dtBirth.DataBindings.Add("Value", dsNorthwind.Tables("Employees"), "BirthDate") End Sub
End Class
</source>