Beispiel #1
0
        private void openToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmConnection frm = new frmConnection();

            frm.Owner = this;
            frm.Icon  = this.Icon;
            if (connstr.Length > 0)
            {
                frm.ConnectionString = connstr;
            }

            if (frm.ShowDialog() == DialogResult.OK)
            {
                connstr = frm.ConnectionString;

                //Get Data Source names.
                datasource = "";
                string[] parts = connstr.Trim().Trim(';').Split(';');
                foreach (string part in parts)
                {
                    int    del  = part.IndexOf('=');
                    string name = "";
                    string val  = "";
                    if (del > -1)
                    {
                        name = part.Substring(0, del).Trim();
                        val  = part.Substring(del + 1).Trim();
                    }
                    if (name.ToLower() == "data source")
                    {
                        datasource = val;
                    }
                }
                LoadTreeView();

                //Close all open query analyzers since they are still pointing to the old connection string.
                foreach (Form child in MdiChildren)
                {
                    child.Close();
                }

                //Open a blank query analyzer.
                ShowNewQaForm("");
            }

            bool enabled = connstr.Length > 0;

            this.newToolStripMenuItem.Enabled      = enabled;
            this.openToolStripMenuItem1.Enabled    = enabled;
            this.refreshToolStripMenuItem1.Enabled = enabled;
            searchToolStripMenuItem.Enabled        = enabled;
            browseToolStripMenuItem.Enabled        = enabled;
        }
Beispiel #2
0
        private void openToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmConnection frm = new frmConnection();
            frm.Owner = this;
            frm.Icon = this.Icon;
            if (connstr.Length > 0)
            {
                frm.ConnectionString = connstr;
            }            

            if (frm.ShowDialog() == DialogResult.OK)
            {
                connstr = frm.ConnectionString;               

                //Get Data Source names.
                datasource = "";
                string[] parts = connstr.Trim().Trim(';').Split(';');
                foreach (string part in parts)
                {
                    int del = part.IndexOf('=');
                    string name = "";
                    string val = "";
                    if (del > -1)
                    {
                        name = part.Substring(0, del).Trim();
                        val = part.Substring(del + 1).Trim();
                    }
                    if (name.ToLower() == "data source")
                    {
                        datasource = val;
                    }
                }
                LoadTreeView();

                //Close all open query analyzers since they are still pointing to the old connection string.
                foreach (Form child in MdiChildren)
                {
                    child.Close();
                }

                //Open a blank query analyzer.
               ShowNewQaForm("");
            }

            bool enabled = connstr.Length > 0;
            this.newToolStripMenuItem.Enabled = enabled;
            this.openToolStripMenuItem1.Enabled = enabled;
            this.refreshToolStripMenuItem1.Enabled = enabled;
            searchToolStripMenuItem.Enabled = enabled;
            browseToolStripMenuItem.Enabled = enabled;
        }