private void generateOrdersButton_Click(object sender, EventArgs e) { DialogResult result = DialogResult.Yes; //determine if orders have already been generated previously ValueHolder valHolder = new ValueHolder(""); ParameterCollection pc = new ParameterCollection("unitnum", SessionManager.Instance.GetActivePatient().unitnum); pc.Add("table", "tblSurgicalClinic"); pc.Add("column", "createdOrders"); //pull one value from the database (fast) valHolder.DoLoadWithSpAndParams("sp_3_LoadRelativeValue", pc); Boolean alreadyGeneratedOrders = ((valHolder.relativeValue).ToLower() == "yes"); if (alreadyGeneratedOrders) { //optionally set the DialogBox result to not "Yes" result = MessageBox.Show("Overwrite orders generated previously?", "RiskApps3", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); } if (result == DialogResult.Yes) { generateOrdersButton.Enabled = false; loadingCircle1.Active = true; loadingCircle1.Visible = true; backgroundWorker1.RunWorkerAsync(); } }