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>
|
No comments:
Post a Comment