DataGrid Column Style setting : DataBinding DataGrid : ADO.Net C# Examples

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

public  class  DataGridColumnStyle  :  System.Windows.Forms.Form
{
        private  System.Windows.Forms.DataGrid  employeeDataGrid;
    private  System.ComponentModel.Container  components  =  null;

    public  DataGridColumnStyle()
    {
        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];

                DataGridTableStyle  tableStyle  =  new  DataGridTableStyle();
                tableStyle.MappingName  =  dataTable.TableName;

                GridColumnStylesCollection  columnStyles  =  tableStyle.GridColumnStyles;

                DataGridTextBoxColumn  columnStyle  =  new  DataGridTextBoxColumn();
                columnStyle.MappingName="ID";
                columnStyle.HeaderText  =  "Employee  ID";
                columnStyles.Add(columnStyle);

                columnStyle  =  new  DataGridTextBoxColumn();
                columnStyle.MappingName  =  "FirstName";
                columnStyle.HeaderText="Employee  First  Name";
                columnStyles.Add(columnStyle);

                GridTableStylesCollection  tableStyles  =    employeeDataGrid.TableStyles;
                tableStyles.Add(tableStyle);
                
                employeeDataGrid.DataSource=dataTable;
        }

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

    private  void  InitializeComponent()
    {
                this.employeeDataGrid  =  new  System.Windows.Forms.DataGrid();
                ((System.ComponentModel.ISupportInitialize)(this.employeeDataGrid)).BeginInit();
                this.SuspendLayout();
                //  
                //  employeeDataGrid
                //  
                this.employeeDataGrid.DataMember  =  "";
                this.employeeDataGrid.HeaderForeColor  =  System.Drawing.SystemColors.ControlText;
                this.employeeDataGrid.Location  =  new  System.Drawing.Point(8,  16);
                this.employeeDataGrid.Name  =  "employeeDataGrid";
                this.employeeDataGrid.Size  =  new  System.Drawing.Size(448,  176);
                this.employeeDataGrid.TabIndex  =  0;
                //  
                //  DataGridColumnStyle
                //  
                this.AutoScaleBaseSize  =  new  System.Drawing.Size(5,  13);
                this.ClientSize  =  new  System.Drawing.Size(464,  205);
                this.Controls.AddRange(new  System.Windows.Forms.Control[]  {
                                                                                                                                            this.employeeDataGrid});
                this.Name  =  "DataGridColumnStyle";
                this.Text  =  "DataGridColumnStyle";
                ((System.ComponentModel.ISupportInitialize)(this.employeeDataGrid)).EndInit();
                this.ResumeLayout(false);

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