连接到oracle数据库（一）

发表日期：2008-2-9

　　using System;
using System.Data;
using System.Data.ADO;

class OracleTest
{
static void Main()
{

//UID - User Id
//PWD - PassWord
//Server - Your Service name
//Using Microsoft ODBC for Oracle DSN-Less
//const string strConn = "Provider=MSDASQL;DRIVER={Microsoft
ODBC for ORACLE};UID=scott;PWD=tiger;Server=fnqa";

//Using Microsoft OLEDB Provider for Oracle
const string strConn = "Provider=MSDAORA.1;Data
Source=oracle_db;User ID=scott;Password=tiger";

//Using DSN Connection
//const string strConn =
"DSN=oracle_dsn;UID=scott;PWD=tiger" ;
const string strSQL = "Select * From EMP";

try
{
DataSet ds = new DataSet("EmployeesSet");
ADODataSetCommand myCommand = new
ADODataSetCommand(strSQL,strConn);
myCommand.FillDataSet(ds,"Buyer");
Console.WriteLine(ds.XML);
}
catch(ADOException e)
{
Console.WriteLine("Exception Occured :
{0}",e.Errors[0].Message);
}

}
}

上一篇：[基础]9i新特性之一连接篇人气:505
下一篇：利用游标返回结果集的的例子（Oracle 存储过程）人气:1084

浏览全部Oracle教程的内容 Dreamweaver插件下载网页广告代码祝你圣诞节快乐 2009年新年快乐