primary key must be unique..

[Yvonne Scherer]

Hi.
I want to set a column of my datatable to primary key.
If this column has not unique values I get an exception.
How can I check the values of the column? Is there a property
which tells me, if the values in the column are unique or not?

Thanks
Yvonne

 

[Mary Chipman]

I don't know if there's an easy way to test after the data is loaded,
but you can ensure that you only get unique values by using a SELECT
DISTINCT instead of plain SELECT when you load the data from the data
source.

-- Mary
MCW Technologies
http://www.mcwtech.com