注: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 } } } |