hi,
when i add a row in a table of a dataset (using dt.rows.add), i expect the
primary key value to be gernarated automatically as i have set it to
Autonumber in access. But instead of generating autonumber, it does not do
anything, which results in null value in the primary key col of new row.
Although remedy to the above is, not to include the primary key in the
selectCommand so that Access does it itself. But i need to include the
primary key in the table because i have to set parent - child relationalship
with another table.
Could someone advise please how can the primarykey of a table in a dataset
to be populated by a unique identifier and not by a null value.
TIA
Irfan