DataTable.Column.Unique

[Aurora]

I have a DataTable with two columns : GroupID which is primary key and
second GroupName which I would like to hold groups name in a unique way, so
that it may not be two groups with same name.
Is there a way to set this feature using DataTable class?
I have tried . dt.Column["GroupName"].Unique = true;


and I get as below

System.Data.InvalidConstraintException was unhandled
Message="Column 'GroupName' contains non-unique values."
Source="System.Data"

Thanks,
Aurora

 

[Cor Ligthert[MVP]]

Aurora,

Thanks for the information, but most of us know this already.

Cor

 

[Aurora]

Thre is question. How do I solve the problem?

Aurora

Aurora,

Thanks for the information, but most of us know this already.

Cor

I have a DataTable with two columns : GroupID which is primary key and
second GroupName which I would like to hold groups name in a unique way,
so that it may not be two groups with same name.
Is there a way to set this feature using DataTable class?
I have tried . dt.Column["GroupName"].Unique = true;


and I get as below

System.Data.InvalidConstraintException was unhandled
Message="Column 'GroupName' contains non-unique values."
Source="System.Data"

Thanks,
Aurora

 

[Cor Ligthert[MVP]]

That depends what you expect.

There is an error given, so it means you try to add a columname that already
expect.
It is up to you what you want to do with it.

Cor

Thre is question. How do I solve the problem?

Aurora

Aurora,

Thanks for the information, but most of us know this already.

Cor

I have a DataTable with two columns : GroupID which is primary key and
second GroupName which I would like to hold groups name in a unique way,
so that it may not be two groups with same name.
Is there a way to set this feature using DataTable class?
I have tried . dt.Column["GroupName"].Unique = true;


and I get as below

System.Data.InvalidConstraintException was unhandled
Message="Column 'GroupName' contains non-unique values."
Source="System.Data"

Thanks,
Aurora

 

[Miha Markic]

Hi Aurora,

Looks like your table is already populated with conflicting values. Set the
Unique=true before populating the data.