Bind DataSet to DataGrid : Data Bind DataGrid « Database ADO.net



using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;



    public class Form1 : System.Windows.Forms.Form

    {

        private System.Windows.Forms.DataGrid dataGrid1;

        private System.ComponentModel.Container components = null;



        public Form1()

        {

            InitializeComponent();

        }



        private void InitializeComponent(){

         this.dataGrid1 = new System.Windows.Forms.DataGrid();

         ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();

         this.SuspendLayout();

         this.dataGrid1.DataMember = "";

         this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;

         this.dataGrid1.Location = new System.Drawing.Point(8, 8);

         this.dataGrid1.Name = "dataGrid1";

         this.dataGrid1.Size = new System.Drawing.Size(608, 256);

         this.dataGrid1.TabIndex = 0;

         this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

         this.ClientSize = new System.Drawing.Size(624, 272);

         this.Controls.Add(this.dataGrid1);

         this.Name = "Form1";

         this.Text = "Form1";

         this.Load += new System.EventHandler(this.Form1_Load);

         ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();

         this.ResumeLayout(false);



      }



      static void Main() {

            Application.Run(new Form1());

      }



      private void Form1_Load(object sender, System.EventArgs e){

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



         string sql = @"select * from employee";



         SqlConnection conn = new SqlConnection(connString);

         SqlDataAdapter da = new SqlDataAdapter(sql, conn);

         DataSet ds = new DataSet();

         da.Fill(ds, "customers");



         // Bind the data table to the data grid

         dataGrid1.SetDataBinding(ds, "customers");

      }

    }
Bind DataSet to DataGrid : Data Bind DataGrid « Database ADO.net « C# / C Sharp
