private static int GetID()
        {
            int           id  = GenerateID.GetID(table);
            SqlConnection sql = new SqlConnection(constr);

            sql.Open();
            String        command       = "SELECT *  FROM " + table + " ;";
            SqlCommand    sql1          = new SqlCommand(command, sql);
            SqlDataReader sqlDataReader = sql1.ExecuteReader();

            ;
            int ID = 1;

            while (sqlDataReader.Read())
            {
                ID = (int)sqlDataReader[0] + 1;
            }
            sqlDataReader.Close();
            sql.Close();
            sql1.Dispose();
            return(ID);
        }