Connect To Oracle DataBase

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

Connect to Oracle DatabaseSubmitted ByUser LevelDate of SubmissionRavi ShankarBeginner05/03/2001

Description of the Article

A Simple program to show connecting to an oracle database.

Source Code:

/***********************************************************************/

//Program Name : ADO Connection to Oracle

//Description : A Sample program to connect to the oracle database

//Created On : 01 May 2001

//Created By : Ravi Shankar Venkatarajalu

/***********************************************************************/

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);

}

}

}

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航