private void Select_(string sql) { DataTable datatable = new DataTable(); ent.Num1 = 0; try { ss.Open(); var dataReader = ss.Oracle(sql); ///动态添加表的数据列 for (int i = 0; i < dataReader.FieldCount; i++) { DataColumn myDataColumn = new DataColumn(); myDataColumn.DataType = dataReader.GetFieldType(i); myDataColumn.ColumnName = dataReader.GetName(i); datatable.Columns.Add(myDataColumn); } ///添加表的数据行 while (dataReader.Read()) { DataRow myDataRow = datatable.NewRow(); for (int i = 0; i < dataReader.FieldCount; i++) { myDataRow[i] = dataReader[i]; } datatable.Rows.Add(myDataRow); myDataRow = null; ent.Num1++; } label1.Text = "查询成功:" + ent.Num1 + "行"; ///关闭数据读取器 gridControl1.DataSource = datatable; this.gridView1.PopulateColumns(); gridView1.OptionsView.ColumnAutoWidth = false; //for (int i = 0; i < dataReader.FieldCount; i++) //{ // gridView1.Columns[dataReader.GetName(i).ToString()].BestFit(); //} for (int I = 0; I < gridView1.Columns.Count; I++) { this.gridView1.BestFitColumns(); this.gridView1.Columns[I].BestFit();//自动列宽 } } catch (Exception ee) { MessageBox.Show("" + ee); } finally { ss.Close(); } }
private void button1_Click(object sender, EventArgs e) { string sql = " select username from dba_users "; ss.Open(); var ord = ss.Oracle(sql); int a = 0; while (ord.Read()) { comboBox1.Items.Add(ord.GetString(0)); a++; } ss.Close(); }
private void button1_Click(object sender, EventArgs e) { int index = 0; string No = ""; string str = ""; string sql = textBox1.Text;//获取sql try { ss.Open(); var ord = ss.Oracle(sql); while (ord.Read()) { this.dataGridView1.Rows.Add(); No = ord.GetOracleString(0).ToString(); str += "'" + No + "',"; dataGridView1.Rows[index].Cells[0].Value = No; index++; } } catch (Exception) { throw; } finally { ss.Close(); } str = str.Substring(0, str.Length - 1); str = "IN(" + str + ")"; textBox2.Text = str; }
private void button3_Click(object sender, EventArgs e) { oracle_link ss = new oracle_link(); string sql = " select * from dual "; string ll = ""; try { ss.Open(); var ord = ss.Oracle(sql); if (ord.Read()) { ll = ord.GetOracleString(0).ToString(); } if (ll != "X") { MessageBox.Show("数据库信息保存失败"); } else { MessageBox.Show("测试成功"); // this.Close(); } } catch (Exception ee) { MessageBox.Show("" + ee); } finally { ss.Close(); } }
private void button1_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); string sql = @"select b.tablespace_name, to_char(b.bytes / 1024 / 1024 / 1024,'fm999990.9999') || 'G', to_char((b.bytes - sum(nvl(a.bytes, 0))) / 1024 / 1024 / 1024,'fm999990.9999') || 'G', to_char(substr((b.bytes - sum(nvl(a.bytes, 0))) / (b.bytes) * 100, 1, 5),'fm999990.9999') || '%' as 百分比, b.file_name, b.AUTOEXTENSIBLE, b.INCREMENT_BY / 128 from dba_free_space a, dba_data_files b where a.file_id = b.file_id group by b.tablespace_name, b.file_name, b.bytes, b.AUTOEXTENSIBLE, b.INCREMENT_BY order by 百分比 desc"; try { int index = 0; ss.Open(); var ord = ss.Oracle(sql); while (ord.Read()) { //comboBox1.Text = ord.GetString(0); this.dataGridView1.Rows.Add(); dataGridView1.Rows[index].Cells[0].Value = ord.GetOracleString(0).ToString(); dataGridView1.Rows[index].Cells[1].Value = ord.GetString(1).ToString(); dataGridView1.Rows[index].Cells[2].Value = ord.GetString(2).ToString(); dataGridView1.Rows[index].Cells[3].Value = ord.GetOracleString(3).ToString(); dataGridView1.Rows[index].Cells[4].Value = ord.GetString(4).ToString(); dataGridView1.Rows[index].Cells[5].Value = ord.GetString(5).ToString(); dataGridView1.Rows[index].Cells[6].Value = ord.GetFloat(6).ToString(); index++; } } catch (Exception) { throw; } finally { ss.Close(); } // conn.Dispose(); }
private void button1_Click(object sender, EventArgs e) { int i = dataGridView1.CurrentRow.Index; try { string s = dataGridView1.Rows[i].Cells[0].Value.ToString(); string s1 = dataGridView1.Rows[i].Cells[1].Value.ToString(); string sql = " alter system kill session '" + s + "," + s1 + "'"; ss.Open(); var ord = ss.Oracle(sql); ss.Close(); button3.PerformClick(); } catch (Exception ee) { } }
private void button1_Click(object sender, EventArgs e) //查询所有用户 { string sql = " select username from dba_users "; ss.Open(); var ord = ss.Oracle(sql); int a = 0; while (ord.Read()) { // if (a == 0) // { comboBox1.Text = ord.GetString(0); } // comboBox1.Text = "请选择用户";//给一个常用的 comboBox1.Items.Add(ord.GetString(0)); a++; } ss.Close(); MessageBox.Show("1"); }
private void button1_Click(object sender, EventArgs e) { try { string sql = "Create tablespace " + textBox1.Text + "Datafile '" + textBox2.Text + "' size " + textBox3.Text + "M " + " Autoextend on Next 5M Maxsize 50M "; if (MessageBox.Show("确定新建表空间" + textBox1.Text + "大小" + textBox3.Text + "M吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { ss.Open(); var ord = ss.Oracle(sql); MessageBox.Show("新建表空间成功"); } } catch (Exception) { MessageBox.Show("新建失败"); } finally { ss.Close(); } }
private void button2_Click(object sender, EventArgs e) { checkedListBox1.Items.Clear(); ent.Sql1 = " select t.COLUMN_NAME from SYS.ALL_TAB_COLS t where 1=1 "; if (User.Text != "") { ent.Sql1 += " and t.owner = '" + User.Text + "'"; } if (table_view.Text != "") { ent.Sql1 += " and t.TABLE_NAME ='" + table_view.Text + "'"; ent.Sql1 = ent.Sql1.ToUpper(); ora.Open(); ent.Result = ora.Oracle(ent.Sql1); while (ent.Result.Read()) { checkedListBox1.Items.Add(ent.Result.GetOracleString(0).ToString()); } ora.Close(); } }