Csharp/C Sharp by API/System.Data.Common/DataTableMapping
DataTableMapping.ColumnMappings.Add
<source lang="csharp">
using System; using System.Data; using System.Data.rumon; using System.Data.SqlClient;
public class UsingDataTableMappings { static void Main(string[] args) { SqlConnection SConn = new SqlConnection("Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true"); SqlDataAdapter da = new SqlDataAdapter("SELECT ID, Contact, Email FROM CaseInfo", SConn); DataSet ds = new DataSet(); DataTableMapping custMap = da.TableMappings.Add("CaseInfo", "MyDatabase"); custMap.ColumnMappings.Add("ID", "CaseNumber"); custMap.ColumnMappings.Add("Contact", "MyContact"); custMap.ColumnMappings.Add("Email", "Email Address"); da.Fill(ds); } } </source>