Getting IDs for newinserted rows

[martho]

Hello!

I insert some new rows into a DataTable and then insert the rows into the database via

changes = dataTable.GetChanges();
if (changes != null)
{         int nRowsUpdated = dataAdapter.Update(changes);
}

This works fine. But now I need to know to values of the "auto_incremet primary key" the database gave to this new rows. So how can I get the ids of the records I just inserted?