Data Relations : DataTable « Database ADO.net « Visual C++ .NET

1. Visual C++ .NET
2. Database ADO.net
3. DataTable

Data Relations

 
#include "stdafx.h"
using namespace System;
using namespace System::Data;

void main()
{
    DataSet^ myDataSet = gcnew DataSet("Game Data");

    DataTable^ playerTable = myDataSet->Tables->Add("Player");
    DataTable^ scoreTable = myDataSet->Tables->Add("Score");

    DataColumn^ firstNameColumn1 = playerTable->Columns->Add("First Name",String::typeid);
    DataColumn^ lastNameColumn1 = playerTable->Columns->Add("Last Name",String::typeid);
    playerTable->Columns->Add("Email", String::typeid);

    array<DataColumn^>^ primaryKey = {firstNameColumn1, lastNameColumn1};
    playerTable->PrimaryKey = primaryKey;

    DataColumn^ firstNameColumn2 = scoreTable->Columns->Add("First Name",String::typeid);
    DataColumn^ lastNameColumn2 = scoreTable->Columns->Add("Last Name",String::typeid);
    scoreTable->Columns->Add("Points", int::typeid);

    array<DataColumn^>^ foreignKey = {firstNameColumn2, lastNameColumn2};
    myDataSet->Relations->Add("Player-Score", primaryKey, foreignKey);

    myDataSet->Tables["Score"]->Constraints->Add("Unique",foreignKey, true);
}

   
  

Related examples in the same category