Oracle 10G的安装请见上一篇文章,现在是安装后测试一下连接的效果
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace Nhibernate1
{
public partial class FormOracle : Form
{
private System.Data.OracleClient.OracleConnection con;
private System.Data.OracleClient.OracleDataAdapter adapter;
private System.Data.OracleClient.OracleCommand cmd;
private System.Data.DataSet ds;
public FormOracle()
{
InitializeComponent();
}
private void FormOracle_Load(object sender, EventArgs e)
{
openCon();
DataSet ds = GetDataSet(" select empno,ename,job from scott.emp");
this.dataGridView1.DataSource = ds.Tables[0];
}
private void openCon()
{
try
{
if (this.con == null)
{
//使用using可以使该连接可以调用Dispose方法来释放资源
//using (this.con = new OracleConnection())
//{
this.con = new OracleConnection();
//设置数据库连接属性为web.config中的设置的值(默认)
//或者设置为构造函数中指定的connString的值
this.con.ConnectionString
= "Data Source=orcl;User ID=scott;Password=tiger;Unicode=True";
this.con.Open();
//}
System.Console.Write("数据库连接成功!"); //Test
}
else if (con.State == ConnectionState.Closed)
{
this.con.Open();
}
}
catch
{
System.Console.Write("数据库连接失败,请与管理员联系!");
}
}
public System.Data.DataSet GetDataSet(string sql)
{
this.adapter = new OracleDataAdapter();
this.ds = new DataSet();
this.CreateCmd(sql);
this.adapter.SelectCommand = this.cmd;
this.adapter.Fill(this.ds);
return this.ds;
}
private void CreateCmd(string sql)
{
//方法1
this.cmd = new OracleCommand();
this.cmd.Connection = this.con;
this.cmd.CommandText = sql;
}
private void button1_Click(object sender, EventArgs e)
{
}
}
}