C# ADO Example

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

using CenterSpace.NMath.Stats;

namespace ADOExample
{
  /// <summary>
  /// A .NET example in C# showing how to display a DataFrame in an ADO.NET DataGrid.
  /// </summary>
  /// <remarks>
  /// Changes to the grid are fed back into a new DataFrame. 
  /// Descriptive statistics are calculated and displayed next to the grid.
  /// </remarks>
  public class ADOExample : System.Windows.Forms.Form
  {
    private DataFrame data;

    private System.Windows.Forms.DataGrid dataGrid1;
    private System.Windows.Forms.Label title;
    private System.Windows.Forms.Button button1;
    private System.Windows.Forms.Label recordLongJumpLabel;
    private System.Windows.Forms.Label averageLongJumpLabel;
    private System.Windows.Forms.Label shortestLabel;
    private System.Windows.Forms.Label varianceLabel;
    private System.Windows.Forms.TextBox variance;
    private System.Windows.Forms.TextBox shortest;
    private System.Windows.Forms.TextBox record;
    private System.Windows.Forms.TextBox average;

    /// <summary>
    /// Required designer variable.
    /// </summary>
    private System.ComponentModel.Container components = null;

    public ADOExample()
    {
      // Required for Windows Form Designer support
      InitializeComponent();

      string filename = "..\\..\\ADOExample.dat";

      // Data consists of high jump, discus throw, long jump marks set
      // during olympic years from 1896 - 1984.
      data = DataFrame.Load(filename, true, false, "\t", true);

      // Adjust year to 4 digits.  Eg. -4 => 1896.
      int yearColumn = data.IndexOfColumn("Olympic_Year");
      for (int i = 0; i < data.Rows; i++)
      {
        double original = (double)data[i, yearColumn];
        data[i, yearColumn] = original + 1900;
      }

      // Permute columns so year comes first.
      data.PermuteColumns(1, 0);

      // Convert my DataFrame to a DataTable.
      DataTable table = data.ToDataTable();

      // Remove the index column.
      table.Columns.Remove(data.RowKeyHeader);

      // Bind to DataGrid.
      dataGrid1.DataSource = table;

      Recompute();
    }

    /// <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.dataGrid1 = new System.Windows.Forms.DataGrid();
      this.title = new System.Windows.Forms.Label();
      this.button1 = new System.Windows.Forms.Button();
      this.recordLongJumpLabel = new System.Windows.Forms.Label();
      this.averageLongJumpLabel = new System.Windows.Forms.Label();
      this.record = new System.Windows.Forms.TextBox();
      this.average = new System.Windows.Forms.TextBox();
      this.shortestLabel = new System.Windows.Forms.Label();
      this.varianceLabel = new System.Windows.Forms.Label();
      this.variance = new System.Windows.Forms.TextBox();
      this.shortest = new System.Windows.Forms.TextBox();
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
      this.SuspendLayout();
      // 
      // dataGrid1
      // 
      this.dataGrid1.BackgroundColor = System.Drawing.Color.White;
      this.dataGrid1.CaptionVisible = false;
      this.dataGrid1.DataMember = "";
      this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dataGrid1.Location = new System.Drawing.Point(24, 80);
      this.dataGrid1.Name = "dataGrid1";
      this.dataGrid1.RowHeadersVisible = false;
      this.dataGrid1.Size = new System.Drawing.Size(168, 312);
      this.dataGrid1.TabIndex = 0;
      // 
      // title
      // 
      this.title.Font = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
      this.title.Location = new System.Drawing.Point(72, 16);
      this.title.Name = "title";
      this.title.Size = new System.Drawing.Size(272, 23);
      this.title.TabIndex = 1;
      this.title.Text = "ADO Example";
      this.title.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
      // 
      // button1
      // 
      this.button1.Location = new System.Drawing.Point(232, 320);
      this.button1.Name = "button1";
      this.button1.Size = new System.Drawing.Size(112, 24);
      this.button1.TabIndex = 2;
      this.button1.Text = "Recompute";
      this.button1.Click += new System.EventHandler(this.RecomputeValues);
      // 
      // recordLongJumpLabel
      // 
      this.recordLongJumpLabel.Location = new System.Drawing.Point(232, 96);
      this.recordLongJumpLabel.Name = "recordLongJumpLabel";
      this.recordLongJumpLabel.Size = new System.Drawing.Size(80, 32);
      this.recordLongJumpLabel.TabIndex = 3;
      this.recordLongJumpLabel.Text = "Record";
      // 
      // averageLongJumpLabel
      // 
      this.averageLongJumpLabel.Location = new System.Drawing.Point(232, 144);
      this.averageLongJumpLabel.Name = "averageLongJumpLabel";
      this.averageLongJumpLabel.Size = new System.Drawing.Size(56, 24);
      this.averageLongJumpLabel.TabIndex = 4;
      this.averageLongJumpLabel.Text = "Average";
      // 
      // record
      // 
      this.record.Location = new System.Drawing.Point(320, 96);
      this.record.Name = "record";
      this.record.Size = new System.Drawing.Size(72, 20);
      this.record.TabIndex = 5;
      this.record.Text = "";
      // 
      // average
      // 
      this.average.Location = new System.Drawing.Point(320, 144);
      this.average.Name = "average";
      this.average.Size = new System.Drawing.Size(72, 20);
      this.average.TabIndex = 6;
      this.average.Text = "";
      // 
      // shortestLabel
      // 
      this.shortestLabel.Location = new System.Drawing.Point(232, 192);
      this.shortestLabel.Name = "shortestLabel";
      this.shortestLabel.Size = new System.Drawing.Size(56, 16);
      this.shortestLabel.TabIndex = 7;
      this.shortestLabel.Text = "Shortest";
      // 
      // varianceLabel
      // 
      this.varianceLabel.Location = new System.Drawing.Point(232, 240);
      this.varianceLabel.Name = "varianceLabel";
      this.varianceLabel.Size = new System.Drawing.Size(72, 24);
      this.varianceLabel.TabIndex = 8;
      this.varianceLabel.Text = "Variance";
      // 
      // variance
      // 
      this.variance.Location = new System.Drawing.Point(320, 240);
      this.variance.Name = "variance";
      this.variance.Size = new System.Drawing.Size(72, 20);
      this.variance.TabIndex = 9;
      this.variance.Text = "";
      // 
      // shortest
      // 
      this.shortest.Location = new System.Drawing.Point(320, 192);
      this.shortest.Name = "shortest";
      this.shortest.Size = new System.Drawing.Size(72, 20);
      this.shortest.TabIndex = 10;
      this.shortest.Text = "";
      // 
      // ADOExample
      // 
      this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
      this.ClientSize = new System.Drawing.Size(418, 416);
      this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                  this.shortest,
                                                                  this.variance,
                                                                  this.varianceLabel,
                                                                  this.shortestLabel,
                                                                  this.average,
                                                                  this.record,
                                                                  this.averageLongJumpLabel,
                                                                  this.recordLongJumpLabel,
                                                                  this.button1,
                                                                  this.title,
                                                                  this.dataGrid1});
      this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
      this.Name = "ADOExample";
      this.Text = "ADO Example";
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
      this.ResumeLayout(false);

    }
    #endregion

    /// <summary>
    /// The main entry point for the application.
    /// </summary>
    [STAThread]
    static void Main()
    {
      Application.Run(new ADOExample());
    }

    private void RecomputeValues(object sender, System.EventArgs e)
    {
      Recompute();
    }

    private void Recompute()
    {
      data = new DataFrame((DataTable)dataGrid1.DataSource);
      average.Text = StatsFunctions.Mean(data["Long_Jump"]).ToString();
      record.Text = StatsFunctions.MaxValue(data["Long_Jump"]).ToString();
      shortest.Text = StatsFunctions.MinValue(data["Long_Jump"]).ToString();
      variance.Text = StatsFunctions.Variance(data["Long_Jump"]).ToString();
    }

  }  // class

}  // namespace