last record inserted in database

See more:

C#

SQL

MySQL

MS-Access

Me again...

On a form i have a ComboBox, i bind the combobox with some data from a database, next the combobox i have a button "insert new data"

which is the better way after in open the form and press the Save button, in my combobox in the main form to be auto selected the new record inserted

I use somthing like this.

private void GetNewId()
        {
            int newID = 0;
            Program.Connection.CommandText = "SELECT MAX(ClientId) AS ClientId FROM DateClientiAmanet";
            DataTable Table = new DataTable();
            Program.Connection.FillDataTable(Table, true);
            newID = Convert.ToInt32(Table.Rows[0]["ClientId"]);
            
            InformatiiDespreClient();
           
            cboNumeClient.SelectedValue = newID.ToString();
        }

Is ok,works,but i search on the internet and the "MAX(ClientId)" is not so good.
thanks.
[EDIT] Code block moved from answer[/EDIT]