通过Oracle.DataAccess访问Oracle.docxVIP

通过Oracle.DataAccess访问Oracle第三方驱动虽带来一些方便，可能也会带来一些问题，鉴于此，提供另一种连接Oracle的方式，供研究学习安装官方Oracle11g客户端，可选的相关性中选择Oracle Data Provider for .Net11.2.0.3.0C#代码中usingOracle.DataAccess.Client;namespace WindowsFormsApplication1{ public partial class Form1 : Form {public Form1() {InitializeComponent(); }private void button1_Click(object sender, EventArgs e) { dataGridView1.DataSource = Oracle_ExecuteQueryToDataTable(SELECT * FROM SFCB.B_PRODUCT); }privateOracleConnectionGetOracleConnection() { stringconnstring = Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.1)(PORT=1521)) + (CONNECT_DATA=(SID=sfcdb)));User Id=xxxxxx;Password=xxxxxx;;//这个也可以放到Web.Config中。OracleConnection conn = new OracleConnection(connstring);return conn; }private void Oracle_ExecuteNonQuery(string sSql) {OracleConnection conn = null;try {conn = GetOracleConnection();conn.Open();OracleCommandcmd = new OracleCommand(sSql, conn);cmd.ExecuteNonQuery(); }catch (Exception e) { //MessageBox.Show(e.Message);throw e; }finally {try {conn.Close(); }catch { } } }privateDataTableOracle_ExecuteQueryToDataTable(string sSql) {OracleConnection conn = null;DataTabledt = null;try {conn = GetOracleConnection();conn.Open();OracleCommandcmd = new OracleCommand(sSql, conn);OracleDataAdapter adapter = new OracleDataAdapter(cmd);dt = new DataTable();adapter.Fill(dt);returndt; }catch (Exception e) {MessageBox.Show(e.Message);throw e; }finally {try {conn.Close(); }catch { } } }private void Form1_Load(object sender, EventArgs e) { } }}测试下，datagridview中就会显示结果