Csharp/C Sharp by API/System.Windows.Forms/DataGridTableStyle

DataGridTableStyle.GridColumnStyles

<source lang="csharp"> using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; public class DataGridColumnAssignment : System.Windows.Forms.Form {

   private System.Windows.Forms.DataGrid employeeDataGrid;
 private System.ruponentModel.Container components = null;
 public DataGridColumnAssignment()
 {
   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.ruponentModel.ISupportInitialize)(this.employeeDataGrid)).BeginInit();
       this.SuspendLayout();
       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;
       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 = "DataGridColumnAssignment";
       this.Text = "DataGridColumnAssignment";
       ((System.ruponentModel.ISupportInitialize)(this.employeeDataGrid)).EndInit();
       this.ResumeLayout(false);
   }
 [STAThread]
 static void Main() 
 {
   Application.Run(new DataGridColumnAssignment());
 }

}

 </source>

DataGridTableStyle.MappingName

<source lang="csharp"> using System; using System.Drawing; using System.Collections; using System.ruponentModel; 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.ruponentModel.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.ruponentModel.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.ruponentModel.ISupportInitialize)(this.employeeDataGrid)).EndInit();
       this.ResumeLayout(false);
   }
 [STAThread]
 static void Main() 
 {
   Application.Run(new DataGridColumnStyle());
 }

}

 </source>