the best way to set the primary key in a datatable or dataset

[Peted]

Hi

im hoping someone can provide or point to an code example of the best
(ie easiest quickest minimal code) way of setting the primary key of a
datatable or dataset targeted to .Net 3.5.

The dataset/datatable would either be already existing OR at the point
of created when the primary key is set

The code examples i found on the net seem to be overly convoluted for
what i would think was something easily set using a property or
something, or am i silly to think this

Peted

 

[Alberto Poblacion]

im hoping someone can provide or point to an code example of the best
(ie easiest quickest minimal code) way of setting the primary key of a
datatable or dataset targeted to .Net 3.5.

The dataset/datatable would either be already existing OR at the point
of created when the primary key is set

The code examples i found on the net seem to be overly convoluted for
what i would think was something easily set using a property or
something, or am i silly to think this

It's reasonably easy. You just add the column or columns to the
PrimaryKey property of the datatable:

theDataTable.PrimaryKey = new DataColumn[]{theDataTable.Columns[0]};