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>