Connect to Oracle Database (i)

oracle| Data | database 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 OLE DB 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);
}


}
}