Hi... Kind of new to the data controls in DotNet, so hopefully this isn't too hard..
I've a table with an integer column that needs to be unique.
I can bind it to a datagrid, and let the user add/delete/edit stuff.
At the moment, he'll exit the dialog, I'll send the data back to the d/b, and it'll throw an exception if there's a duplicate..
So, how do I check for this and display a nicer message? I can trap for an exception when I save the data back, but does it supply enough info. that I can tell which record failed?
(I'm using MyGeneration and it's DooDads architecture to actually play with tables.. Though that probably doesn't matter?)