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)); }
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)); }