C#连接Oracle 字符串
注:using System.Data.OracleClient; 需要在项目右键点击,选择 '添加引用' ,在 .NET 中选择该项.. 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 Appneu { public partial class FrmCnfTable : Form { public FrmCnfTable() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { #region 从region到endregion是手工写的。别的都是系统自动生成的 string constring = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.120) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));Persist Security Info=True;User Id=wangjj; Password=wangjj"; OracleConnection conn = new OracleConnection(constring);//进行连接 try { conn.Open();//打开指定的连接 OracleCommand com = conn.CreateCommand(); com.CommandText = "Select Sysdate From dual ";//写好想执行的Sql语句 OracleDataReader odr = com.ExecuteReader(); while (odr.Read())//读取数据,如果返回为false的话,就说明到记录集的尾部了 { label1.Text = "远程数据库时间:"+odr.GetOracleDateTime(0).ToString();//获得远程数据库时间 } odr.Close();//关闭reader.这是一定要写的 } catch { MessageBox.Show("erro");//如果发生异常,则提示出错 } finally { conn.Close();//关闭打开的连接 } #endregion } } } |