| TESTED
OK ASP.NET CODE FOR
ORACLE
DATABASE CONNECTIVITY
<%@
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=mycomputername-or-ipaddress)(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>
|
No comments:
Post a Comment