protected void btnReTransform_Click(object sender, EventArgs e)
        {
            foreach (ListItem item in bulReTransform.Items)
            {
                // Get the Hostname and the feedname from the text of the bulleted list
                string Host = HostnameFromCartItem(item.Text);
                string Feed = FeednameFromCartItem(item.Text);
                GMI_TRANSRecordHandler GMI_TRANS = new GMI_TRANSRecordHandler();
                try
                {
                    GMI_TRANS.PLSQLExecRetransformation(Host, txtUsername.Text);
                }
                catch (Oracle.DataAccess.Client.OracleException Oe)
                {
                    ExceptionMsg(Oe.ErrorCode.ToString());
                }
                finally { }

                System.Threading.Thread.Sleep(RetransSleepTime);
            }
            // Empty the Retransform set OR RELACE IT WITH LINK to AV?
            bulReTransform.Items.Clear();
            lblCommitMsgs.Text = "Transformation initiated. Refresh Search in 60 secs to observe new transform time";
            CommitControlsVisibility();
        }
        private void updateGridviewGMI_REF(GridView GV, string sqlQuery)
        {
            // Debug
            Status.Print(false, true, "SQLQRY: ", "[" + txtUsername.Text + "]" + sqlQuery);
            List <GMI_TRANSRecord> dataset = new List <GMI_TRANSRecord>();
            GMI_TRANSRecordHandler handler = new GMI_TRANSRecordHandler();

            dataset       = handler.GMI_TRANS_RecsAsList(sqlQuery);
            GV.DataSource = dataset;
            GV.DataBind();

            // Update the label for the number of records found
            lblDTRowCount.Text = dataset.Count.ToString();
            CommitControlsVisibility();
        }
        private void updateDataBoundTable(GridView GV, string sqlQuery)
        {
            // Debug
            Status.Print(false, true, "SQLQRY: ", "[" + txtUsername.Text + "]" + sqlQuery);
            List <GMI_TRANSRecord> dataset = new List <GMI_TRANSRecord>();
            GMI_TRANSRecordHandler handler = new GMI_TRANSRecordHandler();

            dataset       = handler.GMI_TRANS_RecsAsList(sqlQuery);
            GV.DataSource = dataset;
            GV.PageSize   = Convert.ToInt32(ddListPageRows.SelectedItem.Value);
            GV.DataBind();

            // Update the label for the number of records found
            lblDTRowCount.Text = dataset.Count.ToString();
            CommitControlsVisibility();
        }