I have a widows forms project in which I have created a datasource for an as400/iseries table and dragged the table to the form as a datagrid.
This creates the simple bound datagrid that allows me to add, edit and delete rows.
The problem is that the primary key on the table is an aoutonumber field.
On the database a new unique value is generated each time a row is added.
But I don't know how to get the same behaviour out of a datagrid iwritten in visual studio.
I tried setting the default value for the column to Null in the schema for the dataset but the database won't accept a null value.
I tried setting the autoincrement property to True but this seems to use the dataset seed properties rather than the database
number next available.
Bet this is something simple but it is escaping me at the moment.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
