Datagrid - no duplicates

[Nathan]

Hi,

I have a datagrid representing data in a dataset that is filled from an
Access database table. Some of the columns in the table have been set not
to allow duplicates. If I enter a duplictate, I get an error message when
updating the database. How do I get an error message to show as soon as a
duplicate is entered into the grid?

Thanks for your help.

Nathan

 

[Cor Ligthert]

Nathan,

Always keep in mind that your dataset is disconnected. Therefore an other
user can add at the same moment a value in your database, while it even does
not yet exist in your dataset.

The only thing that comes in my mind is update it more (by instance on a row
change event) and catch the errors.

Just my thought,

Cor

 

[Nathan]

Thanks for the input. Updating more often won't work for the way I've got
things coded. I think I'll just have to build my own function.