Mega Code Archive

 

Categories / Visual C++ .NET / ADO Database

 

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); }