Add primary key constraints to DataTable : DataTable « Database ADO.net « Visual C++ .NET

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

Add primary key constraints to 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);
    // (Same as creating the composite primary key)
    //playerTable->PrimaryKey = PrimaryKey;
}

   
  

Related examples in the same category