Csharp/C Sharp/GUI Windows Form/DataGrid Data Binding

DataGrid Binding

<source lang="csharp"> /* User Interfaces in C#: Windows Forms and Custom Controls by Matthew MacDonald Publisher: Apress ISBN: 1590590457

• /

using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data; namespace DataGridBinding {

   /// <summary>
   /// Summary description for DataGridBinding.
   /// </summary>
   public class DataGridBinding : System.Windows.Forms.Form
   {
       internal System.Windows.Forms.DataGrid grid;
       /// <summary>
       /// Required designer variable.
       /// </summary>
       private System.ruponentModel.Container components = null;
       public DataGridBinding()
       {
           //
           // Required for Windows Form Designer support
           //
           InitializeComponent();
           //
           // TODO: Add any constructor code after InitializeComponent call
           //
       }
       /// <summary>
       /// Clean up any resources being used.
       /// </summary>
       protected override void Dispose( bool disposing )
       {
           if( disposing )
           {
               if (components != null) 
               {
                   components.Dispose();
               }
           }
           base.Dispose( disposing );
       }
       #region Windows Form Designer generated code
       /// <summary>
       /// Required method for Designer support - do not modify
       /// the contents of this method with the code editor.
       /// </summary>
       private void InitializeComponent()
       {
           this.grid = new System.Windows.Forms.DataGrid();
           ((System.ruponentModel.ISupportInitialize)(this.grid)).BeginInit();
           this.SuspendLayout();
           // 
           // grid
           // 
           this.grid.Anchor = (((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
               | System.Windows.Forms.AnchorStyles.Left) 
               | System.Windows.Forms.AnchorStyles.Right);
           this.grid.DataMember = "";
           this.grid.HeaderForeColor = System.Drawing.SystemColors.ControlText;
           this.grid.Location = new System.Drawing.Point(10, 17);
           this.grid.Name = "grid";
           this.grid.Size = new System.Drawing.Size(272, 232);
           this.grid.TabIndex = 1;
           // 
           // DataGridBinding
           // 
           this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
           this.ClientSize = new System.Drawing.Size(292, 266);
           this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                         this.grid});
           this.Name = "DataGridBinding";
           this.Text = "DataGridBinding";
           this.Load += new System.EventHandler(this.DataGridBinding_Load);
           ((System.ruponentModel.ISupportInitialize)(this.grid)).EndInit();
           this.ResumeLayout(false);
       }
       #endregion
       /// <summary>
       /// The main entry point for the application.
       /// </summary>
       [STAThread]
       static void Main() 
       {
           Application.Run(new DataGridBinding());
       }
       private void DataGridBinding_Load(object sender, System.EventArgs e)
       {
           DataSet dsStore = new DataSet();
           
           dsStore.ReadXmlSchema(Application.StartupPath + "\\store.xsd");
           dsStore.ReadXml(Application.StartupPath + "\\store.xml");
           
           // Create a relation between categories and products.
           DataRelation dr = new DataRelation("Products in this category", 
               dsStore.Tables["Categories"].Columns["CategoryID"], 
               dsStore.Tables["Products"].Columns["CategoryID"]);
           
           // Add the relation to the DataSet.
           dsStore.Relations.Add(dr);
           
           // Bind the data grid.
           grid.DataSource = dsStore.Tables["Categories"];
       }
   }

}

      </source>

<A href="http://www.nfex.ru/Code/CSharpDownload/DataGridBinding.zip">DataGridBinding.zip( 45 k)</a>

DataGrid Binding: Custom DataGrid Column Form

<source lang="csharp"> /* User Interfaces in C#: Windows Forms and Custom Controls by Matthew MacDonald Publisher: Apress ISBN: 1590590457

• /

using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data; namespace DataGridBinding {

   /// <summary>
   /// Summary description for CustomDataGridColumnForm.
   /// </summary>
   public class CustomDataGridColumnForm : System.Windows.Forms.Form
   {
       internal System.Windows.Forms.DataGrid grid;
       /// <summary>
       /// Required designer variable.
       /// </summary>
       private System.ruponentModel.Container components = null;
       public CustomDataGridColumnForm()
       {
           //
           // Required for Windows Form Designer support
           //
           InitializeComponent();
           //
           // TODO: Add any constructor code after InitializeComponent call
           //
       }
       /// <summary>
       /// Clean up any resources being used.
       /// </summary>
       protected override void Dispose( bool disposing )
       {
           if( disposing )
           {
               if(components != null)
               {
                   components.Dispose();
               }
           }
           base.Dispose( disposing );
       }
       #region Windows Form Designer generated code
       /// <summary>
       /// Required method for Designer support - do not modify
       /// the contents of this method with the code editor.
       /// </summary>
       private void InitializeComponent()
       {
           this.grid = new System.Windows.Forms.DataGrid();
           ((System.ruponentModel.ISupportInitialize)(this.grid)).BeginInit();
           this.SuspendLayout();
           // 
           // grid
           // 
           this.grid.Anchor = (((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
               | System.Windows.Forms.AnchorStyles.Left) 
               | System.Windows.Forms.AnchorStyles.Right);
           this.grid.DataMember = "";
           this.grid.HeaderForeColor = System.Drawing.SystemColors.ControlText;
           this.grid.Location = new System.Drawing.Point(10, 17);
           this.grid.Name = "grid";
           this.grid.Size = new System.Drawing.Size(272, 232);
           this.grid.TabIndex = 1;
           // 
           // CustomDataGridColumnForm
           // 
           this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
           this.ClientSize = new System.Drawing.Size(292, 266);
           this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                         this.grid});
           this.Name = "CustomDataGridColumnForm";
           this.Text = "CustomDataGridColumnForm";
           this.Load += new System.EventHandler(this.CustomDataGridColumnForm_Load);
           ((System.ruponentModel.ISupportInitialize)(this.grid)).EndInit();
           this.ResumeLayout(false);
       }
       #endregion
       [STAThread]
       static void Main() 
       {
           Application.Run(new CustomDataGridColumnForm());
       }
       private void CustomDataGridColumnForm_Load(object sender, System.EventArgs e)
       {
           DataSet dsStore = new DataSet();
           
           dsStore.ReadXmlSchema(Application.StartupPath + "\\store.xsd");
           dsStore.ReadXml(Application.StartupPath + "\\store.xml");
           
           // Create the column collection.
           DataGridTableStyle columns = new DataGridTableStyle();
           columns.MappingName = "Products";
           
           // Create and configure the columns you want to display.
           DataGridPriceIconColumn priceCol = new DataGridPriceIconColumn(100);
           priceCol.HeaderText = "Price";
           priceCol.MappingName = "UnitCost";
           
           // Add the columns to the collection.
           columns.GridColumnStyles.Add(priceCol);
           
           // Configure the DataGrid to use these column settings.
           grid.TableStyles.Add(columns);  
           
           grid.ReadOnly = true;
           
           // Bind the grid.
           grid.DataSource = dsStore.Tables["Products"];
           
       }
   }

public class DataGridPriceIconColumn : DataGridColumnStyle {

   public decimal NicePrice;
   public DataGridPriceIconColumn(decimal nicePrice)
   {
       this.NicePrice = nicePrice;
   }
   protected override void Abort(int rowNum)
   {
       // Do nothing.
   }
   protected override bool Commit(CurrencyManager dataSource, int rowNum)
   {
       return true;
   }
   protected override void Edit(CurrencyManager source,
       int rowNum, System.Drawing.Rectangle bounds,
       bool readOnly, string instantText, bool cellIsVisible)
   {
       // Do nothing.
   }
   protected override void Edit(CurrencyManager source,
       int rowNum, System.Drawing.Rectangle bounds, bool readOnly)
   {
       // Do nothing.
   }
   protected override void Edit(CurrencyManager source,
                           int rowNum, System.Drawing.Rectangle bounds,
                           bool readOnly, string instantText)
   {
       // Do nothing.
   }
   protected override int GetMinimumHeight()
   {
       return 20;
   }
   protected override int GetPreferredHeight(System.Drawing.Graphics g,
       object value)
   {
       return 20;
   }
   protected override System.Drawing.Size GetPreferredSize(
       System.Drawing.Graphics g, object value)
   {
       return new Size(100, 20);
   }
   protected override void Paint(System.Drawing.Graphics g,
       System.Drawing.Rectangle bounds, CurrencyManager source, int rowNum,
       System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush,
       bool alignToRight)
   {
       // Clear the cell.
       g.FillRegion(backBrush, new Region(bounds));
       decimal price = (decimal)this.GetColumnValueAtRow(source, rowNum);
       Icon priceIcon;
       if (price < NicePrice)
       {
           priceIcon = new Icon(Application.StartupPath + "\\happy2.ico");
           // Draw the optional "nice price" icon.
           g.DrawIcon(priceIcon, new Rectangle(bounds.X, bounds.Y, 16, 16));
       }
       // Draw the text.
       g.DrawString(price.ToString("C"), new Font("Tahoma", (float)8.25), 
           Brushes.Black, bounds.X + 20, bounds.Y + 2);
   }
   protected override void Paint(System.Drawing.Graphics g,
       System.Drawing.Rectangle bounds, CurrencyManager source,
       int rowNum, bool alignToRight)
   {
       this.Paint(g, bounds, source, rowNum, Brushes.White, Brushes.Black,
           alignToRight);
   }
   protected override void Paint(System.Drawing.Graphics g,
       System.Drawing.Rectangle bounds, CurrencyManager source, int rowNum)
   {
       this.Paint(g, bounds, source, rowNum, Brushes.White, Brushes.Black, false);
   }

}

}

      </source>

<A href="http://www.nfex.ru/Code/CSharpDownload/DataGridBinding.zip">DataGridBinding.zip( 45 k)</a>