KAR KAR DOOMA: Oracle Database Connection

THE BELOW C# CODE

WAS TESTED OK

WITH ORACLE DATABASE

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="login" %>
<%@ Import NameSpace="System.Data.OracleClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<%
String oradb = "Data Source=(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)

(HOST=MyComputerIPAddress) (PORT=1521)) (CONNECT_DATA=(SERVER=DEDICATED)

(SERVICE_NAME=xe)));User Id=scott;Password=tiger;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
string sql = "select * from emp";
OracleCommand cmd = new OracleCommand(sql, conn);

OracleDataReader dr = cmd.ExecuteReader();
dr.Read();

label1.Text = dr["emp_name"].ToString();

%>

</div>
<asp:Label ID="label1" runat="server" Text="Label"></asp:Label>
</form>
</body>
</html>

KAR KAR DOOMA

Oracle Database Connection

Contents In this Site