/// <summary> /// 执行sql语句 /// </summary> private void toolStripButton_run_Click(object sender, EventArgs e) { string sql = tbx_sql.Text; if (string.IsNullOrWhiteSpace(sql)) { MessageBox.Show("查询语句不能为空"); } else if (toolStripComboBox_dbs.SelectedIndex == -1) { MessageBox.Show("请选择数据库"); } else { //执行前先清空之前结果 dataGridView_result.DataSource = null; string dbName = (string)toolStripComboBox_dbs.Text; //dbManagerService.ExecuteReader(_shellData.ShellExtraSetting, dbName, sql); if (sql.ToLower().StartsWith("select")) { dbManagerService.ExecuteReader(GetConnStr(), dbName, sql); } else { dbManagerService.ExecuteNonQuery(GetConnStr(), dbName, sql); } } }
/// <summary> /// 执行sql语句 /// </summary> private void toolStripButton_run_Click(object sender, EventArgs e) { string sql = tbx_sql.Text; if (string.IsNullOrWhiteSpace(sql)) { MessageBox.Show("the query sql cannot be empty"); } else if (toolStripComboBox_dbs.SelectedIndex == -1) { MessageBox.Show("please select one database"); } else { //执行前先清空之前结果 dataGridView_result.DataSource = null; string dbName = (string)toolStripComboBox_dbs.Text; if (sql.ToLower().StartsWith("select")) { dbManagerService.ExecuteReader(GetConnStr(), dbName, sql); } else { dbManagerService.ExecuteNonQuery(GetConnStr(), dbName, sql); } } }