private void optionsToolStripMenuItem_Click(object sender, EventArgs e)
 {
     frmPreferances form = new frmPreferances();
     form.ShowDialog();
 }
        //Test connection to SB
        private void button1_Click(object sender, EventArgs e)
        {
            if (Properties.Settings.Default.dbServer == "")
            {
                if(MessageBox.Show("No database server configured. Press OK to do this now") == System.Windows.Forms.DialogResult.OK)
                {
                    frmPreferances form = new frmPreferances();
                    form.ShowDialog();
                }
            }
            else
            {
                try
                {
                    string dbServer = Properties.Settings.Default.dbServer;
                    string dbName = Properties.Settings.Default.dbName;
                    string dbUser = Properties.Settings.Default.dbUser;
                    string dbPass = Properties.Settings.Default.dbPassword;

                    //This basically makes sure that we can connect to SBI. They can't select a plan unless they do this.
                    Global.SetConnectionString("SBI", "Server="+dbServer+";Database="+dbName+";Integrated Security=SSPI;User ID="+dbUser+";Password="******"SELECT intPlanId, strPlanName FROM tblProdPlanName WHERE ysnPlanActive = 1").Tables[0];
                    cmbPlanName.DisplayMember = "strPlanName";
                    cmbPlanName.ValueMember = "intPlanID";

                    btnConnect.BackColor = System.Drawing.Color.Green;
                    btnSearch.Enabled = true;

                    cmbPlanName.SelectedIndex = Properties.Settings.Default.defPlan;
                } catch
                { MessageBox.Show("There was a problem connecting to the database. Check the connection settings"); }
            }
        }