Csharp/CSharp Tutorial/ADO.Net/DataTableMapping

ColumnMappings

<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; using System.Data.OleDb; using System.Data.rumon; public class DataColumnMappingDemo : System.Windows.Forms.Form {

 private System.Windows.Forms.DataGrid dataGrid1;
 private System.ruponentModel.Container components = null;
 public DataColumnMappingDemo()
 {
   InitializeComponent();
 }
 protected override void Dispose( bool disposing )
 {
   if( disposing )
   {
     if (components != null) 
     {
       components.Dispose();
     }
   }
   base.Dispose( disposing );
 }
 private void InitializeComponent()
 {
   this.dataGrid1 = new System.Windows.Forms.DataGrid();
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
   this.SuspendLayout();
   // 
   // dataGrid1
   // 
   this.dataGrid1.DataMember = "";
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(8, 16);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.Size = new System.Drawing.Size(432, 248);
   this.dataGrid1.TabIndex = 0;
   // 
   // DataColumnMappingDemo
   // 
   this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
   this.ClientSize = new System.Drawing.Size(448, 273);
   this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                   this.dataGrid1});
   this.Name = "DataColumnMappingDemo";
   this.Text = "DataColumnMappingDemo";
   this.Load += new System.EventHandler(this.DataColumnMappingDemo_Load);
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
   this.ResumeLayout(false);
 }
 [STAThread]
 static void Main() 
 {
   Application.Run(new DataColumnMappingDemo());
 }
 private void DataColumnMappingDemo_Load(object sender, System.EventArgs e)
 {
       string ConnectionString ="Integrated Security=SSPI;Initial Catalog=Northwind;Data Source=localhost;";
       SqlConnection conn = new SqlConnection(ConnectionString);
       conn.Open();
       DataTableMapping myMapping = new DataTableMapping("Table", "Orders");
       SqlDataAdapter adapter = new SqlDataAdapter("Select * From Orders", conn);
       adapter.TableMappings.Add(myMapping);
       myMapping.ColumnMappings.Add(new DataColumnMapping("OrderID", "mapID"));
       
       DataSet ds = new DataSet();
       adapter.Fill(ds);
       Console.WriteLine( ds.Tables["Orders"].Rows[0]["mapID"].ToString());
       dataGrid1.DataSource = ds.DefaultViewManager;
 }

}</source>

DataTableMapping and DataGrid

<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; using System.Data.OleDb; using System.Data.rumon; public class DataTableMappingDemo : System.Windows.Forms.Form {

 private System.Windows.Forms.DataGrid dataGrid1;
 private System.ruponentModel.Container components = null;
 public DataTableMappingDemo()
 {
   InitializeComponent();
 }
 protected override void Dispose( bool disposing )
 {
   if( disposing )
   {
     if (components != null) 
     {
       components.Dispose();
     }
   }
   base.Dispose( disposing );
 }
 private void InitializeComponent()
 {
   this.dataGrid1 = new System.Windows.Forms.DataGrid();
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
   this.SuspendLayout();
   // 
   // dataGrid1
   // 
   this.dataGrid1.DataMember = "";
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(8, 16);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.Size = new System.Drawing.Size(432, 248);
   this.dataGrid1.TabIndex = 0;
   // 
   // DataTableMapping
   // 
   this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
   this.ClientSize = new System.Drawing.Size(448, 273);
   this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                   this.dataGrid1});
   this.Name = "DataTableMapping";
   this.Text = "DataTableMapping";
   this.Load += new System.EventHandler(this.DataTableMapping_Load);
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
   this.ResumeLayout(false);
 }
 [STAThread]
 static void Main() 
 {
   Application.Run(new DataTableMappingDemo());
 }
 private void DataTableMapping_Load(object sender, System.EventArgs e)
 {
       string ConnectionString ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";
       SqlConnection conn = new SqlConnection(ConnectionString);
       conn.Open();
       DataTableMapping myMapping = new DataTableMapping("Employee", "mapEmployee");
       SqlDataAdapter adapter = new SqlDataAdapter("Select * From Employee", conn);
       adapter.TableMappings.Add(myMapping);
       DataSet ds = new DataSet();
       adapter.Fill(ds, "mapEmployee");
       dataGrid1.DataSource = ds.DefaultViewManager;
 }

}</source>

Table mapping

<source lang="csharp">using System; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; using System.Data.rumon; using System.Windows.Forms; class MainClass {

 static void Main(string[] args)
 {
   string ConnectionString ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";
   SqlConnection conn = new SqlConnection(ConnectionString);
   conn.Open();
   try
   {
     DataTableMapping myMapping = new DataTableMapping("Employee", "mapEmployee");
     SqlDataAdapter adapter = new SqlDataAdapter("Select * From Employee",  conn);
     adapter.TableMappings.Add(myMapping);
     DataSet ds = new DataSet();
     adapter.Fill(ds, "mapEmployee");
     Console.WriteLine(ds.Tables[0].ToString());
   }
   catch(SqlException ex)
   {
     Console.WriteLine(ex.Message.ToString());
   }
 }

}</source>