SHOW TABLE STATUS LIKE 'table_name'

SHOW TABLE STATUS LIKE 'table_name'

SHOW TABLE STATUS LIKE 'table_name'

LAST_INSERT_ID()

MAX(ID)+1

    static class Service
    {
        static public long Increment(string pConnectionString, string pNameTable)
        {
            System.Data.DataTable tableStatus = new System.Data.DataTable();
            tableStatus.TableName = "tableStatus";

            MySql.Data.MySqlClient.MySqlDataAdapter tableStatusTableAdapter =
                 new MySql.Data.MySqlClient.MySqlDataAdapter();

            MySql.Data.MySqlClient.MySqlCommand lComm = new MySql.Data.MySqlClient.MySqlCommand();
            lComm.CommandText = "SHOW TABLE STATUS LIKE '" + pNameTable + "'";
            MySql.Data.MySqlClient.MySqlConnection lConn = new MySql.Data.MySqlClient.MySqlConnection();
            lConn.ConnectionString = pConnectionString;
            lComm.Connection = lConn;
            tableStatusTableAdapter.SelectCommand = lComm;

            tableStatusTableAdapter.Fill(tableStatus);

            if (tableStatus.Rows.Count < 1) return 1;
            System.Data.DataRow lRow = tableStatus.Rows[0];
            if ((lRow[0].ToString() == pNameTable) && (lRow[10].ToString() != ""))
            {
                ulong AutoIncrementSeed = (ulong)lRow[10];
                return (long)AutoIncrementSeed;
            }
            return 1;
        }
    }

myDataSet.tab1.idKeyColumn.AutoIncrementSeed = Service.Increment(Properties.Settings.Default.myConnectionString, "tab1");