Autoincrement in Datasets

Question

If a table column is set as autoincrement and i only retrieve a subset of of the table in a 'typed dataset' then when I try to insert a new row into the dataset the autoincrment count is all screwed up. The insert does not work properly and the changes are not saved. I do not wish to load up the whole table into the dataset because there can be thousands of rows in there. Does any one have a suggestion??? Thanks,