Table Mapping : DataTable « Database ADO.net « Visual C++ .NET






Table Mapping

 

#include "stdafx.h"

using namespace System;
using namespace System::Data;
using namespace System::Data::Common;
using namespace System::Data::OleDb;
using namespace System::Data::SqlClient;

void main()
{
    OleDbConnection^ myConnection = nullptr;
    myConnection = gcnew OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Music.mdb");
    myConnection->Open();
    OleDbDataAdapter^ dataAdapter = gcnew OleDbDataAdapter("SELECT * FROM Music", myConnection);
    DataSet^ myDataSet = gcnew DataSet();
    DataTable^ newMusicTable = myDataSet->Tables->Add("New Music");
    newMusicTable->Columns->Add("Title");
    newMusicTable->Columns->Add("Duration");
    DataTableMapping^ myMapping = dataAdapter->TableMappings->Add("Music", "New Music");
    myMapping->ColumnMappings->Add("Title", "Title");
    myMapping->ColumnMappings->Add("Duration", "Duration");
    dataAdapter->MissingSchemaAction = MissingSchemaAction::Ignore;
    dataAdapter->Fill(myDataSet, "Music");
    for ( int i = 0; i < newMusicTable->Rows->Count; i++ ){
        Console::WriteLine(newMusicTable->Rows[i]["Title"]);
        Console::WriteLine(newMusicTable->Rows[i]["Duration"]);
    }
    myConnection->Close();
}

   
  








Related examples in the same category

1.Add columns to DataTable
2.Add primary key constraints to DataTable
3.Add foreign key to the DataTable
4.Data Relations