Get Unique ID

Question

Hello,

I am using the following code for inserting a record in a sql server database:

DataRow newCustomersRow = dataSet1.Tables["tMailings"].NewRow();
newCustomersRow["MailingName"] = fieldName.Text.ToString();
newCustomersRow["MailingEmail"] = fieldEmail.Text.ToString();
dataSet1.Tables["tMailings"].Rows.Add(newCustomersRow);

mySqlDataAdapter.RowUpdated += new SqlRowUpdatedEventHandler(handleRowUpdated);
mySqlDataAdapter.Update(dataSet1, "tMailings");
mySqlDataAdapter.RowUpdated -= new SqlRowUpdatedEventHandler(handleRowUpdated);

After the update I want to retrieve the UniqueId "MailingId" from the table tMailings.
I can't get this to work!!!

Can anybody help me??

TNX