連接Oracle數據庫

之前我也有談論過.net中對不同數據庫的連接操作，這次單談談Oracle，其實你要連接到Oracle數據庫是要要求有個Oracle.DataAccess.dll。可以到Oracle網站下載。如果你安裝了Oracle了，也會有這個dll了。引入就OK

因為是測試，學習。所以代碼也簡單。

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using Oracle.DataAccess.Client; using System.Windows.Forms; namespace OraWinApp { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.14)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=lab)));" + "User Id=adte;Password=adte123;"; OracleConnection conn = new OracleConnection(oradb); try { conn.Open(); string sql = "select * from TB_ZCTYPE"; OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; OracleDataAdapter oda = new OracleDataAdapter(); oda.SelectCommand = cmd; DataSet ds = new DataSet(); oda.Fill(ds); dataGridView1.DataSource = ds.Tables[0].DefaultView; } catch (Exception ex) // catches any error { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } } } }

 

 

其實很多都是跟sql是一樣的模式。我也是學習一下先！