Binding ListBox to a Database table : DataBinding ListBox : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.SqlClient;
using  System.Drawing;
using  System.Collections;
using  System.ComponentModel;
using  System.Windows.Forms;
using  System.Data;

public  class  ListBoxBindingTable  :  System.Windows.Forms.Form
{
    private  System.Windows.Forms.ListBox  employeeList;

    private  System.ComponentModel.Container  components  =  null;

    public  ListBoxBindingTable()
    {
        InitializeComponent();

        string  connectionString  =  "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";

        string  commandString  =  "Select  ID,  FirstName  from  Employee";

        SqlDataAdapter  dataAdapter  =  new  SqlDataAdapter(commandString,  connectionString);

        DataSet  dataSet  =  new  DataSet();

        dataAdapter.Fill(dataSet,"Employee");

        DataTable  dataTable  =  dataSet.Tables[0];
        employeeList.DataSource=  dataTable;
        employeeList.DisplayMember  =  "Employee";


    }

    protected  override  void  Dispose(  bool  disposing  )
    {
        if(  disposing  )
        {
            if  (components  !=  null)  
            {
                components.Dispose();
            }
        }
        base.Dispose(  disposing  );
    }

    private  void  InitializeComponent()
    {
        this.employeeList  =  new  System.Windows.Forms.ListBox();
        this.SuspendLayout();

        this.employeeList.Location  =  new  System.Drawing.Point(8,  8);
        this.employeeList.Name  =  "employeeList";
        this.employeeList.Size  =  new  System.Drawing.Size(272,  95);
        this.employeeList.TabIndex  =  0;

        this.AutoScaleBaseSize  =  new  System.Drawing.Size(5,  13);
        this.ClientSize  =  new  System.Drawing.Size(292,  133);
        this.Controls.AddRange(new  System.Windows.Forms.Control[]  {this.employeeList});
        this.Name  =  "ListBoxBindingTable";
        this.Text  =  "ListBoxBindingTable";
        this.ResumeLayout(false);

    }

    [STAThread]
    static  void  Main()  
    {
        Application.Run(new  ListBoxBindingTable());
    }
}