Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Binding DataSet to DataGrid

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.Windows.Forms.Label label1;         private System.Windows.Forms.Button button1;     public Form1()     {             this.dataGrid1 = new System.Windows.Forms.DataGrid();             this.label1 = new System.Windows.Forms.Label();             this.button1 = new System.Windows.Forms.Button();             ((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(16, 56);             this.dataGrid1.Name = "dataGrid1";             this.dataGrid1.Size = new System.Drawing.Size(264, 168);             this.dataGrid1.TabIndex = 0;             //              this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 24F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));             this.label1.Location = new System.Drawing.Point(8, 8);             this.label1.Name = "label1";             this.label1.Size = new System.Drawing.Size(296, 40);             this.label1.TabIndex = 1;             this.label1.Text = "Databases in Code";             //              this.button1.Location = new System.Drawing.Point(80, 240);             this.button1.Name = "button1";             this.button1.Size = new System.Drawing.Size(120, 23);             this.button1.TabIndex = 2;             this.button1.Text = "Connect to database";             this.button1.Click += new System.EventHandler(this.button1_Click);             //              this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);             this.ClientSize = new System.Drawing.Size(292, 273);             this.Controls.Add(this.button1);             this.Controls.Add(this.label1);             this.Controls.Add(this.dataGrid1);             this.Name = "Form1";             this.Text = "Form1";             ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();             this.ResumeLayout(false);         }     [STAThread]     static void Main()      {       Application.Run(new Form1());     }         private void button1_Click(object sender, System.EventArgs e)         {             DataSet dataset1 = new DataSet("dataset1");             string connectionString = "workstation id=STEVE;packet size=4096;integrated security=SSPI;initial catalog=pubs;persist security info=False";             SqlConnection connection1 = new SqlConnection(connectionString);             SqlCommand command1 = new SqlCommand("SELECT * FROM authors");             command1.CommandType = CommandType.Text;             connection1.Open();             command1.Connection = connection1;             SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();             sqlDataAdapter1.SelectCommand = command1;             sqlDataAdapter1.Fill(dataset1, "authors");             dataGrid1.SetDataBinding(dataset1, "authors");         }   }