Add foreign key to the DataTable : DataTable « Database ADO.net « Visual C++ .NET

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

Add foreign key to the DataTable

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

void main()
{
    DataSet^ myDataSet = gcnew DataSet("Game Data");
    myDataSet->Tables->Add("Player");
    myDataSet->Tables->Add("Score");

    DataTable^ playerTable = myDataSet->Tables["Player"];
    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->Constraints->Add("PlayerPK", primaryKey, true);

    // Add columns to 2nd table
    DataTable^ ScoreTable = myDataSet->Tables["Score"];
    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};

    ScoreTable->Constraints->Add("PlayerFK", primaryKey, foreignKey);
    // (Same as establish a data relation)
    //myDataSet->Relations->Add("Player-Score", PrimaryKey, ForeignKey);

}

   
  

Related examples in the same category