assigning primary key to more than one column

[gaffar]

Sir,

if we want to assign a primary key to a single cloumn. below code is used.

objTable1.Keys.Append("PrimaryKey", KeyTypeEnum.adKeyPrimary,
"PrimaryKey_Field")

if i want to assign primary to more than one column then what will be code.

 

[Ken Tucker [MVP]]

Hi,

The datatable's primarykey accepts an array of datacolumns. Link
shows an example.

http://msdn.microsoft.com/library/d...rfsystemdatadatatableclassprimarykeytopic.asp

Ken
------------------------
Sir,

if we want to assign a primary key to a single cloumn. below code is used.

objTable1.Keys.Append("PrimaryKey", KeyTypeEnum.adKeyPrimary,
"PrimaryKey_Field")

if i want to assign primary to more than one column then what will be code.

 

[gaffar]

Sir Can you help the same code in the Vb.net

 

[Ken Tucker [MVP]]

Hi,

Try something like this.
dsClient.Tables(0).PrimaryKey = New DataColumn()
{dsClient.Tables(0).Columns("FirstName"),
dsClient.Tables(0).Columns("LastName")}



Ken