示例#1
0
        private void btnMakeScript_Click(object sender, EventArgs e)
        {
            OpenQueryParameters pars = new OpenQueryParameters();

            //m_conn.SetOnOpenDatabase(m_db.DatabaseName);
            pars.SqlText = GenerateSql();
            MainWindow.Instance.OpenContent(new QueryFrame(m_conn.Clone(), pars));
        }
示例#2
0
        private void OpenCurrentQuery()
        {
            string sid    = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value.ToString();
            string codeid = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[1].Value.ToString();
            string sql    = m_conn.ExecuteScalar("select QueryText from QueryText WHERE ID=@p1", codeid).ToString();
            string ctx    = m_conn.ExecuteScalar("select QueryContext from QueryExecute WHERE ID=@p1", sid).ToString();
            var    doc    = new XmlDocument();

            doc.LoadXml(ctx);
            var pars = new OpenQueryParameters();

            pars.SavedContext = doc;
            pars.SqlText      = sql;
            MainWindow.Instance.OpenContent(new QueryFrame(null, pars));
        }