Google Search

Friday

Beginner C# code to display data in an Oracle Table

THE FOLLOWING C# CODE WAS TESTED OK.

IT USES TNSNAMES ENTRY.

Note: TNSName is CASE SENSITIVE

EVEN IF SQLPLUS IS WORKING OK FOR A TNSNAMES ENTRY, ASP.NET MAY NOT WORK SOMETIMES.It may generate an Error: COULD NOT RESOLVE CONNECT IDENTIFIER". This may be due to missing of proper file permission to reach the tnsnames.ora file by the Oracle Server.

 

<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ 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=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>

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
 
Google Search