ARTICLE

Connect to an Oracle Database

Posted by Ravi Shankar in Articles | ADO.NET in C# on May 03, 2001

Tags: ADO Connection to Oracle, ADO.NET, C#, Connect to OracleDatabase, Microsoft ODBC for ORACLE, Using DSN Connection in Oracle, Using Microsoft ODBC for Oracle DSN-Less, Using Microsoft OLEDB Provider for Oracle, using System.Data.ADO

This sample code shows you how to connect to an Oracle database using C#.

Tweet
78531
10

Reader Level: Beginner

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

Article Extensions

Contents added by loga nathan on Jun 01, 2012

lullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullai

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

post comment

Description of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article ExtensionsDescription of the ArticleA 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); } } }Add your contents and source code to this article Article Extensions

Posted by loga nathan on Jun 01, 2012

lullulullai

Posted by loga nathan on Jun 01, 2012

lullullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullailullulullai

Posted by loga nathan on Jun 01, 2012

View All Comments

COMMENT USING

PREMIUM SPONSORS

DynamicPDF Developer Components

DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and add new content to existing PDF documents from within your applications.

TRENDING UP

Create Outlook Add-in by MAPI Functionality by Using Visual Studio 2010 Outlook Project Debugging jQuery in ASP.NET How to Enable Sign in as Different User Option in SharePoint 2013 Top 10 HTML5 Interview Questions Find and Delete Duplicate Records From SQL Table Panel Default Button is Not Working For Rad Combobox Working With Database in HTML5 Custom Paging With GridView in ASP.NET 4.5 Extending WinJS ListView With Custom Item Events Encrypt and Decrypt in SQL Server: Part 2

View All

MOST LIKED ARTICLE

WCF Introduction and Contracts - Day 1 Create SSRS Report Using Report Wizard CREATE READ UPDATE and DELETE - CRUD Operation Using LINQ to SQL WCF - Data Contract - Day 4 Factory Design Pattern

Follow @twitterapi

Options	Votes	%
Lenovo	19	13.29
HP	6	4.20
Dell	16	11.19
Toshiba	54	37.76
Acer	43	30.07
Sony	5	3.50
Total	143	100%

In Focus

Connect to an Oracle Database

Related Articles


Favorite Computer Manufacturer

Who is your favorite Computer manufacturer?

Lenovo HP Dell Toshiba Acer Sony