ID (NuméroAuto)
Nom (texte)
Prénom (texte)

...
string sql = "INSERT INTO Contact(Nom, Prénom) VALUES(@Nom, @Prénom)";

OleDbCommand comm = new OleDbCommand(sql, conn);

comm.Parameters.Add("@Nom", nom);
comm.Parameters.Add("@Prénom", prenom);

comm.ExecuteNonQuery();

 protected static void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs args)
  {
    // Include a variable and a command to retrieve the identity value from the Access database.
    int newID = 0;
    OleDbCommand idCMD = new OleDbCommand("SELECT @@IDENTITY", nwindConn);

    if (args.StatementType == StatementType.Insert)
    {
      // Retrieve the identity value and store it in the CategoryID column.
      newID = (int)idCMD.ExecuteScalar();
      args.Row["CategoryID"] = newID;
    }
  }
}

If e.StatementType = StatementType.Insert Then
    ' Retrieve the identity value and store it in the IdIntervention column.

    Dim oCmd As New OleDbCommand("SELECT @@IDENTITY", e.Command.Connection)

    e.Row("IdIntervention") = oCmd.ExecuteScalar()
    e.Row.AcceptChanges()

End If

...
DataRow row = dataSet.Tables[0].NewRow();
string ID = row["ID"];

row["Nom"] = nom;
row["Prénom"] = prenom

dataSet.Tables[0].Rows.Add(row);
...