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?

[Thread1]

you may check this one http://msdn2.microsoft.com/en-us/lib...t0(VS.71).aspx

[aniskhan]

Post

[cjard]

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?

call this instead:
int nRowsUpdated = dataAdapter.Update(datatable);

and note how your id fields are all now popualted. magic