using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OracleClient;


namespace WindowsFormsApplication2

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}


OracleConnection conn;//声明一个OracleConnection变量

OracleDataAdapter adapter;

DataSet ds;

OracleDataAdapter sda;

private void Form1_Load(object sender, EventArgs e)

{


}


private void button1_Click(object sender, EventArgs e)

{

//实例化OracleConnection变量conn，连接数据库

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

//创建一个OracleDataAdapter对象sda

sda = new OracleDataAdapter("select * from T_table2", conn);

//创建一个DataSet对象

ds = new DataSet();

//使用OracleDataAdapter对象的Fill方法填充DataSet

sda.Fill(ds, "T_table2");

//设置dataGridView1控件数据源

dataGridView1.DataSource = ds.Tables[0];


//button1.Enabled = false;//可以使该按钮操作后不可用，适用于一次行为

//dataGridView1.Columns[0].ReadOnly =false;

}


private DataTable dbconn(string strSql)

{


conn.Open();

this.adapter = new OracleDataAdapter(strSql, conn);

DataTable dtSelect = new DataTable();

int rnt = this.adapter.Fill(dtSelect);

conn.Close();

return dtSelect;



}




private void button_modify_Click(object sender, EventArgs e)

{

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

conn.Open();


//update table2 set field1=value1 where 范围

string sql = "update T_table2 set " + textBox_modifyType.Text + "='" + textBox_nameAfter.Text + "'where " + textBox_modifyType.Text + "= '" + textBox_nameBefore.Text + "'";

//string sql = "update T_table2 set name='" + textBox_nameAfter.Text + "'where name= '" + textBox_nameBefore.Text + "'";

OracleCommand cmd = new OracleCommand(sql, conn);

int result = cmd.ExecuteNonQuery();

if (result !=0)

{

MessageBox.Show("修改成功！");

}

else

{

MessageBox.Show("修改失败！");

}

dataGridView1.DataSource = Display();

}


private void button_delete_Click(object sender, EventArgs e)

{

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

conn.Open();

int i = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);

string sql = "delete from T_table2 where ID='" + i + "'";

//this.textBox_id.Text = this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString();

//string sql = "delete from T_table2 where ID='" + textBox_id.Text + "'";


OracleCommand cmd = new OracleCommand(sql, conn);

int result = cmd.ExecuteNonQuery();

if (result == 1)

{

MessageBox.Show("删除成功！");

}

else

{

MessageBox.Show("删除失败！");

}

dataGridView1.DataSource = Display();

}




private void button_add_Click(object sender, EventArgs e)

{

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

conn.Open();

string sql = "insert into T_table2(ID,NAME,AGE,SEX,SCHOOL) values('" + textBox_id.Text + "','" + textBox_name.Text + "','" + textBox_age.Text+ "','"+ textBox_sex.Text + "','" + textBox_school.Text + "')";

OracleCommand cmd = new OracleCommand(sql, conn);

int result = cmd.ExecuteNonQuery();

if (result == 1)

{

MessageBox.Show("添加成功！");

}

else

{

MessageBox.Show("添加失败！");

}

dataGridView1.DataSource = Display();

}


private DataTable Display()

{

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

conn.Open();

string sql = "select * from T_table2";

OracleCommand cmd = new OracleCommand(sql, conn);

OracleDataAdapter oda = new OracleDataAdapter(cmd);

DataTable dt = new DataTable();

oda.Fill(dt);

conn.Close();

cmd.Dispose();

return dt;

}


private void button_select_Click(object sender, EventArgs e)

{

conn = new OracleConnection("Data Source=网络服务名;Persist Security Info=True;User ID=***;Password=***;Unicode=True");

sda = new OracleDataAdapter("select * from T_table2 where name='" + this.textBox_name.Text + "' or sex ='" + textBox_sex.Text + "'", conn);

ds = new DataSet();

sda.Fill(ds, "T_table2");

//设置dataGridView1控件数据源

dataGridView1.DataSource = ds.Tables[0];

}


private void textBox_modifyType_TextChanged(object sender, EventArgs e)

{


}

}

}

运行效果：

212326563.jpg

Oracle数据库管理系统


212801104.jpg

设置选择数据库记录方式dataGridViews—SelectionMode