below software used to connect ORACLE DB:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Oracle.DataAccess.Client;
using System.Data;
namespace OracleConnectionSampleDotnetWebApp
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
//creating TNS entries
string oradb = "Data Source=(DESCRIPTION =" +
"(ADDRESS = (PROTOCOL = TCP)(HOST = 10.47.40.206)(PORT = 1521))" +
"(CONNECT_DATA =" +
"(SERVER = DEDICATED)" +
"(SERVICE_NAME = POKTESTDELTA)));" +
"User Id= oracle_server;Password=oracle;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
Response.Write("Connected to Oracle" + conn.ServerVersion+"<br/>");
if (conn.State.ToString().ToUpper() == "OPEN")
Response.Write("Connected to Oracle DB successfully..." + "<br/>");
else
{
Response.Write("not connected");
}
// Close and Dispose OracleConnection object
//conn.Close();
//conn.Dispose();
//Response.Write("Disconnected");
//OracleCommand sqlCommand = new OracleCommand("select * from INCOME.srv_types where APP_ID='3' AND SRV_TYPE='8'", conn);
//conn.Open();
//OracleCommand sqlCommand = new OracleCommand("select * from CUST", conn);
//OracleCommand sqlCommand = new OracleCommand("select CUST_ID ,NAME,ADDRESS1,REGION,ZIPCODE,TOWN,STATE COUNTRY, PHONE,EMAIL,NICKNAME,LOGIN,PASSWORD,AGE from cust Limit="+10, conn);
//OracleCommand sqlCommand = new OracleCommand("select TOP 10 CUST_ID ,NAME,ADDRESS1,REGION,ZIPCODE,TOWN,STATE COUNTRY,CUST_ID ,NAME,ADDRESS1,REGION,ZIPCODE,TOWN,STATE COUNTRY, PH PHONE,EMAIL,NICKNAME,LOGIN,PASSWORD,AGE FROM cust", conn);
//OracleCommand sqlCommand = new OracleCommand("select top 10 * from cust where order by cust_id desc;", conn);
OracleDataAdapter oda = new OracleDataAdapter("select top 10 * from CUST", conn);
DataSet ds = new DataSet();
oda.Fill(ds, "CUST");
//OracleDataReader reader = sqlCommand.ExecuteReader();
//GridView1.DataSource = reader;
GridView1.DataSource = ds;
GridView1.DataBind();
//GridView1.Show();
}
}
}
