How do I create/set the PrimaryKey ?

[Chris]

Hello,
The following code works fine, but I need to set the `ISBN` to be the
primary key. I'm using ADO, C# and haven't come across anything that google
could help me with.

Any pointers/tips/help would be appreciated....Thank you for your time....

public bool CreateDataBase()

{

Catalog myCatalog = new ADOX.CatalogClass();

ADOX.IndexClass myIndex = new ADOX.IndexClass();

string dbPath =
System.IO.Directory.GetCurrentDirectory()+@"\BookC ollection.mdb";

// build the database

myCatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0 ;"+"Data
Source="+dbPath+";"+"Jet OLEDB:Engine Type=5");

// build the tables

Table myTable = new TableClass();

myTable.Columns.Append("ISBN",DataTypeEnum.adVarWC har,20);

myTable.Columns["ISBN"].ParentCatalog=myCatalog;

myTable.Columns.Append("Title",DataTypeEnum.adVarW Char,20);

myTable.Columns.Append("Author",DataTypeEnum.adVar WChar,20);

myTable.Columns.Append("Publisher",DataTypeEnum.ad VarWChar,20);

myTable.Columns.Append("Cost",DataTypeEnum.adCurre ncy,10);

myTable.Name = "BookCollection";

// append the tables

myCatalog.Tables.Append(myTable);

return true;

}

[Chris Jobson]

There's an example at
http://www.eggheadcafe.com/forums/Fo...15611&INTID=14

Chris Jobson

"Chris" <cl******@hotmail.com> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...

Hello,
The following code works fine, but I need to set the `ISBN` to be the
primary key. I'm using ADO, C# and haven't come across anything that
google could help me with.

Any pointers/tips/help would be appreciated....Thank you for your time....

public bool CreateDataBase()

{

Catalog myCatalog = new ADOX.CatalogClass();

ADOX.IndexClass myIndex = new ADOX.IndexClass();

string dbPath =
System.IO.Directory.GetCurrentDirectory()+@"\BookC ollection.mdb";

// build the database

myCatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0 ;"+"Data
Source="+dbPath+";"+"Jet OLEDB:Engine Type=5");

// build the tables

Table myTable = new TableClass();

myTable.Columns.Append("ISBN",DataTypeEnum.adVarWC har,20);

myTable.Columns["ISBN"].ParentCatalog=myCatalog;

myTable.Columns.Append("Title",DataTypeEnum.adVarW Char,20);

myTable.Columns.Append("Author",DataTypeEnum.adVar WChar,20);

myTable.Columns.Append("Publisher",DataTypeEnum.ad VarWChar,20);

myTable.Columns.Append("Cost",DataTypeEnum.adCurre ncy,10);

myTable.Name = "BookCollection";

// append the tables

myCatalog.Tables.Append(myTable);

return true;

}

[Chris]

Thanks Chris for the help. All is well and Merry Christmas! :D

-Chris

"Chris Jobson" <ch**********@btinternet.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

There's an example at
http://www.eggheadcafe.com/forums/Fo...15611&INTID=14

Chris Jobson

"Chris" <cl******@hotmail.com> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...

Hello,
The following code works fine, but I need to set the `ISBN` to be the
primary key. I'm using ADO, C# and haven't come across anything that
google could help me with.

Any pointers/tips/help would be appreciated....Thank you for your
time....

public bool CreateDataBase()

{

Catalog myCatalog = new ADOX.CatalogClass();

ADOX.IndexClass myIndex = new ADOX.IndexClass();

string dbPath =
System.IO.Directory.GetCurrentDirectory()+@"\BookC ollection.mdb";

// build the database

myCatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0 ;"+"Data
Source="+dbPath+";"+"Jet OLEDB:Engine Type=5");

// build the tables

Table myTable = new TableClass();

myTable.Columns.Append("ISBN",DataTypeEnum.adVarWC har,20);

myTable.Columns["ISBN"].ParentCatalog=myCatalog;

myTable.Columns.Append("Title",DataTypeEnum.adVarW Char,20);

myTable.Columns.Append("Author",DataTypeEnum.adVar WChar,20);

myTable.Columns.Append("Publisher",DataTypeEnum.ad VarWChar,20);

myTable.Columns.Append("Cost",DataTypeEnum.adCurre ncy,10);

myTable.Name = "BookCollection";

// append the tables

myCatalog.Tables.Append(myTable);

return true;

}