VB.Net/Database ADO.net/Data bind to ListBox

Материал из VB Эксперт
Версия от 15:44, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

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
  1. 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
  1. 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>