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