tag:blogger.com,1999:blog-37244003086725794542024-02-08T04:54:31.530-08:00ASP.NET C# WORKING SAMPLE CODESSome practically tested example codes of ASP.NET csharp c#Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3724400308672579454.post-90570725571970411182009-06-12T05:25:00.001-07:002010-02-12T05:07:31.305-08:00DataReader and Afterwards<table width="500" border="2" cellspacing="2" cellpadding="2">
<tr>
<td><p>Which one is Faster DATABINDER? DataAdapter-CombinedWith-Dataset or
Data Reader?</p>
<p>DataReader is much faster than DataAdapter-Dataset. By the way, DataReader
is Readonly as well as forward only. </p>
<p>To further improve the performance, once the DataReader has read the
data, off load the data to .... and close the DataReader as well as DataConnection.</p>
<p>If you dont close the DatabaseConnection, then, Mr.DataReader will hold
that connection, which leads to scalability problems when the number of
users are more. For details about this scalabitity is available here.<a href="http://msdn.microsoft.com/en-us/library/ms978388.aspx">http://msdn.microsoft.com/en-us/library/ms978388.aspx</a></p>
<p>The Next Question is : Where this DataReader will offload its data?</p>
<p>There are two places. ARRAYLIST,DATATABLE-CUM-DATAVIEW</p>
<p>I am using the following code for ArrayList: Further details about this
code is available here:<a href="http://www.developerfusion.com/article/5292/datagridgridview-paging-and-sorting-using-a-datareader/3/">http://www.developerfusion.com/article/5292/datagridgridview-paging-and-sorting-using-a-datareader/3/</a></p>
<p><%@ Page Language="VB" Debug="False" Strict="True"
Explicit="True" Buffer="True" Trace="False"
%><br>
<%@ Import Namespace="System" %><%@ Import Namespace="System.Data"
%><%@ Import Namespace="System.Data.SqlClient" %><br>
<html><head></head><body bgcolor="#FFFFFF"
topmargin="0" marginheight="0"><script language="VB"
runat="server"><br>
'Set up the variables for our ArrayLists<br>
Dim dgCache, bkResults As ArrayList</p>
<p> Sub Page_Load (Source As Object, E As EventArgs)<br>
If Not Page.IsPostBack Then<br>
'Reset DataGrid Page to the top<br>
MyDataGrid.CurrentPageIndex = 0<br>
'Check if ViewSate is already populated<br>
If IsNothing(ViewState("SortOrder")) then<br>
'Assign default column sort order<br>
GetDataReader ("SupplierID asc")<br>
Else<br>
'Else retrieve sort order from ViewState<br>
GetDataReader (ViewState("SortOrder").ToString())<br>
End If<br>
End If<br>
End Sub</p>
<p><br>
Public Structure DBInfo 'Lightweight Class to hold our data results</p>
<p> Private _SupplierID As Object<br>
Private _CompanyName As String<br>
Private _ContactName As String<br>
Private _Country As String</p>
<p> 'Constructor<br>
Public Sub New (ByVal SupplierID As Object, ByVal CompanyName As String,
_<br>
ByVal ContactName As String, ByVal Country As String)</p>
<p> _SupplierID = SupplierID<br>
_CompanyName = CompanyName<br>
_ContactName = ContactName<br>
_Country = Country</p>
<p> End Sub</p>
<p><br>
'All relevant public properties based on database columns<br>
Public Property SupplierID() As Object<br>
Get<br>
Return _SupplierID<br>
End Get<br>
Set (ByVal Value As Object)<br>
_SupplierID = Value<br>
End Set<br>
End Property</p>
<p> Public Property CompanyName() As String<br>
Get<br>
Return _CompanyName<br>
End Get<br>
Set (ByVal Value As String)<br>
_CompanyName = Value<br>
End Set<br>
End Property</p>
<p> Public Property ContactName() As String<br>
Get<br>
Return _ContactName<br>
End Get<br>
Set (ByVal Value As String)<br>
_ContactName = Value<br>
End Set<br>
End Property</p>
<p> Public Property Country() As String<br>
Get<br>
Return _Country<br>
End Get<br>
Set (ByVal Value As String)<br>
_Country = Value<br>
End Set<br>
End Property</p>
<p> End Structure 'DBinfo Structure</p>
<p><br>
Function SortOrder (Field As String) As String</p>
<p> If Field = ViewState("SortOrder").ToString() Then<br>
SortOrder = Replace (Field,"asc","desc")<br>
Else<br>
SortOrder = Replace (Field,"desc","asc")<br>
End If</p>
<p> End Function</p>
<p><br>
Sub GetDataReader(ColumnOrder As String)</p>
<p> 'Assign ColumnOrder to ViewState<br>
ViewState("SortOrder") = ColumnOrder</p>
<p> 'Set up Cache Object and determine if it exists<br>
dgCache = CType(Cache.Get("dgCache" & ColumnOrder), ArrayList)</p>
<p> If (dgCache Is Nothing) Then</p>
<p> Dim sqlStr As String = "SELECT SupplierID, CompanyName, "_<br>
& "ContactName, Country FROM Suppliers Order by " &
ColumnOrder<br>
Dim strConn As String = "server=(local);uid=sa;pwd=;database=Northwind;"<br>
Dim MyConnection As New SQLConnection (strConn)</p>
<p> MyConnection.Open()</p>
<p> Dim MyCommand As New SQLCommand(sqlStr, MyConnection)<br>
Dim objDataReader As SQLDataReader = MyCommand.ExecuteReader (CommandBehavior.CloseConnection)<br>
'Create instances of the class,<br>
Dim bkResults as New ArrayList()</p>
<p> 'Loop through DataReader<br>
While objDataReader.Read()</p>
<p> With bkResults</p>
<p> 'and then add the instances to the ArrayList<br>
.Add (New DBInfo (objDataReader.GetInt32(0), _<br>
objDataReader.GetString(1), _<br>
objDataReader.GetString(2), _<br>
objDataReader.GetString(3)))<br>
End With<br>
End While</p>
<p> 'Insert ArrayList into Cache Object with unique identifier<br>
Cache.Insert ("dgCache" & ColumnOrder, bkResults)<br>
'Close DataReader Connection<br>
objDataReader.Close()<br>
'Bind DataGrid from ArrayList<br>
MyDataGrid.DataSource = bkResults<br>
Else<br>
'Bind DataGrid from Cached ArrayList<br>
MyDataGrid.DataSource = dgCache<br>
End If</p>
<p> MyDataGrid.DataBind()</p>
<p> 'Clear ArrayList<br>
bkResults = Nothing<br>
End Sub</p>
<p> Sub MyDataGrid_Page(sender As Object, e As DataGridPageChangedEventArgs)<br>
MyDataGrid.CurrentPageIndex = e.NewPageIndex<br>
GetDataReader (ViewState("SortOrder").ToString())<br>
End Sub</p>
<p> Sub MyDataGrid_Sort(sender As Object, e As DataGridSortCommandEventArgs)<br>
MyDataGrid.CurrentPageIndex = 0<br>
GetDataReader(SortOrder(e.SortExpression.ToString()))<br>
End Sub<br>
<br>
</script><br>
<br><br><br>
<b>Dynamic DataGrid Paging and Sorting Using A DataReader Bound
ArrayList</b><br>
<br><br>
<form runat="server"></p>
<p><%= "Page: " & MyDataGrid.CurrentPageIndex+1 & "
of " & (MyDataGrid.PageCount) %><br>
<br><br><br>
<br>
<ASP:DataGrid id="MyDataGrid" runat="server"</p>
<p> AutoGenerateColumns="False"<br>
AllowPaging="True"<br>
AllowCustomPaging="False"<br>
AllowSorting="True"<br>
PageSize="10"<br>
PagerStyle-Mode="NumericPages"<br>
PagerStyle-HorizontalAlign="Right"<br>
PagerStyle-NextPageText="Next"<br>
PagerStyle-PrevPageText="Prev"<br>
BorderColor="black"<br>
BorderWidth="1"<br>
GridLines="Both"<br>
CellPadding="3"<br>
CellSpacing="0"<br>
Font-Name="Verdana"<br>
Font-Size="8pt"<br>
HeaderStyle-BackColor="#aaaadd"<br>
AlternatingItemStyle-BackColor="#eeeeee"<br>
Width="700px"<br>
OnPageIndexChanged="MyDataGrid_Page"<br>
OnSortCommand="MyDataGrid_Sort" ><br>
<Columns><br>
<asp:BoundColumn DataField="SupplierID" SortExpression="SupplierID
asc" HeaderText="SupplierID"/><br>
<asp:BoundColumn DataField="CompanyName" SortExpression="CompanyName
asc"<br>
HeaderText="CompanyName"/><br>
<asp:BoundColumn DataField="ContactName" HeaderText="ContactName"<br>
SortExpression="ContactName asc"/><br>
<asp:BoundColumn DataField="Country" HeaderText="Country"<br>
SortExpression="Country asc"/><br>
</Columns><br>
</asp:DataGrid><br>
</form><br>
</body><br>
</html><br>
</p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-19428257492523824232009-06-12T04:43:00.000-07:002010-02-12T05:07:08.448-08:00C# Populate GridView With Sorting Facility<p> </p>
<p> </p>
<table width="500" border="2" cellspacing="2" cellpadding="2">
<tr>
<td><p><font color="#FF0000" size="7">This sample code is for populating a
GridView from an oracle table.</font></p>
<p><font color="#FF0000" size="7">It uses</font></p>
<p><font color="#FF0000" size="7">OracleConnection</font></p>
<p><font color="#FF0000" size="7">OracleCommand</font></p>
<p><font color="#FF0000" size="7">OracleDataAdapter</font></p>
<p><font color="#FF0000" size="7">DataSet</font></p>
<p><font color="#FF0000" size="7">GridView Control</font></p>
<p> </p>
<p> </p>
<p><font color="#0066CC" size="7" face="Arial, Helvetica, sans-serif">Code
for </font></p>
<p><font color="#0066FF" size="5" face="Arial, Helvetica, sans-serif">PopulateGridViewEx1.aspx</font></p>
<p> </p>
<p> </p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><%@ Page Language="C#" AutoEventWireup="true"
CodeFile="PopulateGridViewEx1.aspx.cs" Inherits="PopulateGridViewEx1"
%></font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"></font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><html xmlns="http://www.w3.org/1999/xhtml"><br>
<head runat="server"><br>
<title></title><br>
</head><br>
<body><br>
<form id="form1" runat="server"><br>
<div><br>
<asp:GridView ID="GridView1" runat="server"><br>
</asp:GridView><br>
<br>
</div><br>
</form><br>
</body><br>
</html></font></p>
<p><font color="#0099FF" size="7" face="Arial, Helvetica, sans-serif">C#
code for <font size="5">PopulateGridViewEx1.aspx.cs</font></font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">using System;<br>
using System.Collections.Generic;</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">using System.Web;<br>
using System.Web.UI;<br>
using System.Web.UI.WebControls;<br>
using System.Data.OracleClient;<br>
//the above line is must for oracleconnection,oraclecmd<br>
using System.Data;<br>
//for DataSet Objects, the above line is needed</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">public partial class PopulateGridViewEx1 : System.Web.UI.Page<br>
{<br>
protected void Page_Load(object sender, EventArgs e)<br>
{<br>
if (!Page.IsPostBack)<br>
{<br>
FillGridView1();<br>
}<br>
}<br>
private void FillGridView1()<br>
{<br>
GridView1.DataSource = GetDataSource();<br>
//GridView1.DataTextField = "emp_name";<br>
//GridView1.DataValueField = "emp_id";<br>
GridView1.DataBind();<br>
}<br>
private DataSet GetDataSource()<br>
{<br>
String oradb = System.Configuration.ConfigurationSettings.AppSettings["OpenLocalConn"];</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> OracleConnection conn = new OracleConnection(oradb);<br>
conn.Open();<br>
string sql = "select * from emp";<br>
OracleCommand cmd = new OracleCommand(sql, conn);</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> OracleDataAdapter adapter = new OracleDataAdapter(cmd);<br>
DataSet ds = new DataSet();<br>
adapter.Fill(ds);<br>
return ds;<br>
}<br>
}</font><br>
</p>
<p><font size="2" face="Arial, Helvetica, sans-serif">When you are running
the above code, you may get the following error:</font></p>
<p><font color="#FF0000">Compiler Error Message: CS0234: The type or namespace
name 'OracleClient' does not exist in the namespace 'System.Data'</font></p>
<p>For this error, you have to add reference to the oracle client by doing
the following clicks: Website menu>Add Reference..>.Net Tab ><br>
System.Data.OracleClient >OK</p>
<p>When the above thing is done, the following line is automatically included
in your web.config file. </p>
<p> <font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif"><add assembly="System.Data.OracleClient, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></font></p>
<p> </p>
<p><font color="#0066FF" size="4" face="Arial, Helvetica, sans-serif">Code of web.config</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><configuration><br>
<system.web><br>
<pages enableViewState="false" enableViewStateMac="false"
/><br>
<customErrors mode="Off"/><br>
<compilation debug="true"><br>
<assemblies><br>
<add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=B77A5C561934E089"/></assemblies></compilation><br>
</system.web><br>
<appSettings><br>
<add key="OpenLocalConn" value="Data Source=SALES;User
Id=sellme;Password=sellme123;"/><br>
</appSettings><br>
</configuration></font></p>
<p> </p>
<p><font size="2" face="Arial, Helvetica, sans-serif">Once the above code
was made working, you can format the following thigs:</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">1. The Header Values
of the grid are Just the Field Names of the Database Table. (eg. emp_id,emp_name).
Instead of Emp_Name I want to display NAME OF EMPLOYEE. How this can be
done.</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">2. Then,do you want
to allow SORTING FACILITY</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> In the propertites,
just make ALLOWSORTNIG=TRUE</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">Now the Datagrid source
code will look like this:</font></p>
<p><asp:GridView ID="GridView1" runat="server" AllowPaging="True"
<br>
AllowSorting="True" <font color="#FF0000"><strong>OnSorting="GridView1_Sorting"</strong></font>><br>
</asp:GridView></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">But, when you click
the sorting link,you may get the error:</font></p>
<p><font color="#FF0000">The GridView 'GridView1' fired event Sorting which
wasn't handled</font></p>
<p>If you are able to set the DataSourceID property of GridView, this problem
will not be there. But I am using oracleclient and using the codes such
as </p>
<p>GridView1.DataSource=ds;</p>
<p>GridView1.DataBind();<br>
So you got this error.</p>
<p> <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
<br>
AllowSorting="True" <font color="#FF0000"><strong>OnSorting="GridView1_Sorting"</strong></font>><br>
</asp:GridView></p>
<p>But this is not Enough<br>
</p>
<p> </p>
<p><font size="2" face="Arial, Helvetica, sans-serif">3. Then do you want
to display the report page by page when records are more.</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">In the properties,
just make ALLOWPAGING=TRUE</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><br>
<br>
</font></p>
<p> </p>
<p> </p></td>
</tr>
</table>
<p> </p>
<p> </p>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-71868171142739115752009-05-02T04:30:00.000-07:002010-02-12T05:08:07.718-08:00WORKING C# CODE FOR ORACLE CONNECTION<table width="1116" border="2" cellspacing="2" cellpadding="2">
<tr>
<td width="1102"><p><strong><font color="#0099FF" size="7">THE BELOW C# CODE
</font></strong></p>
<p><strong><font color="#0099FF" size="7">WAS TESTED OK </font></strong></p>
<p><strong><font color="#0099FF" size="7">WITH ORACLE DATABASE</font></strong></p>
<p> </p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><%@ Page Language="C#"
AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="login"
%><br>
<%@ Import NameSpace="System.Data.OracleClient" %><br>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><html xmlns="http://www.w3.org/1999/xhtml"><br>
<head runat="server"><br>
<title></title><br>
</head><br>
<body><br>
<form id="form1" runat="server"><br>
<div><br>
<%<br>
String oradb = "Data Source=(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> (HOST=MyComputerIPAddress)
(PORT=1521)) (CONNECT_DATA=(SERVER=DEDICATED)</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> (SERVICE_NAME=xe)));User
Id=scott;Password=tiger;";<br>
OracleConnection conn = new OracleConnection(oradb);<br>
conn.Open();<br>
string sql = "select * from emp";<br>
OracleCommand cmd = new OracleCommand(sql, conn);<br>
<br>
OracleDataReader dr = cmd.ExecuteReader(); <br>
dr.Read();</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> label1.Text = dr["emp_name"].ToString();
</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"><br>
%><br>
<br>
<br>
</div><br>
<asp:Label ID="label1" runat="server" Text="Label"></asp:Label><br>
</form><br>
</body><br>
</html><br>
</font><font size="2"> </font> </p></td>
</tr>
</table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-65121623672492234132009-05-01T05:34:00.000-07:002010-02-12T05:08:42.718-08:00Beginner C# code to display data in an Oracle Table<table width="716" border="2" cellspacing="2" cellpadding="2">
<tr>
<td width="702"><h1><strong><font color="#0099FF" size="7">THE FOLLOWING C# CODE WAS TESTED
OK.</font></strong></h1>
<h1><font color="#0099FF" size="7"><strong><font size="5">IT USES TNSNAMES
ENTRY.</font></strong></font></h1>
<p><strong></strong></p>
<p><font size="5"><strong><font color="#0099FF">Note: TNSName is CASE SENSITIVE</font></strong></font></p>
<p><strong><font color="#0099FF" size="5">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.</font></strong></p>
<p> </p>
<p><font size="3" face="Arial, Helvetica, sans-serif"><strong><%@ Page
Language="C#" AutoEventWireup="true" %><br>
<%@ Import NameSpace="System.Data.OracleClient" %><br>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
</strong></font></p>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"><html xmlns="http://www.w3.org/1999/xhtml"><br>
<head runat="server"><br>
<title></title><br>
</head><br>
<body><br>
<form id="form1" runat="server"><br>
<div><br>
<%<br>
String oradb = "Data Source=xe;User Id=scott;Password=tiger;";<br>
OracleConnection conn = new OracleConnection(oradb);<br>
conn.Open();<br>
string sql = "select * from emp";<br>
OracleCommand cmd = new OracleCommand(sql, conn);<br>
<br>
OracleDataReader dr = cmd.ExecuteReader(); <br>
dr.Read();</font></strong></p>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"> label1.Text
= dr["emp_name"].ToString(); </font></strong></p>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"><br>
%><br>
<br>
<br>
</div><br>
<asp:Label ID="label1" runat="server" Text="Label"></asp:Label><br>
</form><br>
</body><br>
</html><br>
</font></strong><font size="3" face="Arial, Helvetica, sans-serif"> </font>
</p></td>
</tr>
</table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-20990441048114748662009-05-01T04:21:00.000-07:002010-02-12T05:09:16.963-08:00Migrate Excel Data To Oracle : Classic ASP : Complete Code<table width="500" border="2" cellspacing="2" cellpadding="2">
<tr>
<td> <h1><font color="#0099FF" size="7" face="Arial, Helvetica, sans-serif">CLASSIC
ASP > A COMPLETE ASP CODE > FOR MIGRATING AN EXCEL WORKSHEET INTO
ORACLE TABLE</font></h1>
<p> </p>
<p><font color="#000066" size="2" face="Arial, Helvetica, sans-serif"><%<br />
Set MyConn =Server.CreateObject("ADODB.Connection")<br />
MyConn.open="provider=MSDAORA;data source=xe; user id=scott;password=tiger"<br />
'in the above line "xe" is the TNS Service name<br />
Set ConnExcel=Server.CreateObject("ADODB.Connection")<br />
ConnExcel.Provider="Microsoft.jet.oledb.4.0"<br />
ConnExcel.Properties("Extended Properties").value ="Excel
8.0"<br />
ConnExcel.open Server.Mappath("emp.xls")<br />
excel_table_name="[Sheet1$]"</font></p>
<p><font color="#000066" size="2" face="Arial, Helvetica, sans-serif">'Sheet1
is the worksheet name given at the bottom of excel file<br />
'in the above line, "empworksheet" is the worksheet name in
the excel file<br />
Set ObjRs=Server.CreateObject("adodb.recordset")<br />
sql="Select * from " & excel_table_name<br />
ObjRs.open sql,ConnExcel,adOpenStatic<br />
If ObjRs.eof Then<br />
Response.write ("no records present in excel file")<br />
Else<br />
sql="select * from emp"<br />
Set ObjRsOra=Server.CreateObject("adodb.recordset")<br />
ObjRsOra.cursorLocation=3<br />
ObjRsOra.open sql,myconn,1,3<br />
While not ObjRs.eof<br />
ObjRsOra.AddNew<br />
ObjRsOra("emp_id")=ObjRs("emp_id")<br />
ObjRsOra("emp_name")=ObjRs("emp_name")<br />
ObjRsOra.Update<br />
response.write(objRs("emp_id") & " entered successfully<br
/>")<br />
ObjRs.Movenext<br />
Wend<br />
End If<br />
%><br />
</font><font color="#000066" size="3" face="Arial, Helvetica, sans-serif">
</font></p>
</td>
</tr>
</table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-3654098467494184402009-05-01T02:50:00.000-07:002010-02-12T05:09:40.471-08:00C# code for fetching data from XML<table>
<tr>
<td width="548"> <h1><font color="#0099FF" size="7">Working ASP.NET code</font></h1>
<h1><font color="#0099FF" size="7"> for using XML file as a Database</font></h1>
<h1><font color="#FF0000">XML Code for </font><font color="#FF0000">emp.xml
file </font><br>
<font size="3" face="Arial, Helvetica, sans-serif"><strong><?xml version="1.0"
encoding="iso-8859-1"?><br>
<emp><br>
<record><br>
<name>Raja</name><br>
<age>25</age><br>
</record><br>
<record><br>
<name>Peter</name><br>
<age>23</age><br>
</record><br>
</emp></strong></font><br>
<br>
<br>
<font color="#FF0000" size="6" face="Arial, Helvetica, sans-serif">ASP.NET
Code for</font></h1>
<h1><font color="#FF0000" size="6" face="Arial, Helvetica, sans-serif">simpleRepeater.aspx
</font><br>
<font size="3" face="Arial, Helvetica, sans-serif"><strong><%@ Import
Namespace="System.Data" %><br>
<script runat="server"><br>
sub Page_Load<br>
if Not Page.IsPostBack then<br>
dim empDataSet=New DataSet<br>
empDataSet.ReadXml(MapPath("emp.xml"))<br>
empRepeater.DataSource=empDataSet<br>
empRepeater.DataBind()<br>
end if<br>
end sub<br>
</script> <br>
<html><br>
<body> </strong></font></h1>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"><form runat="server"><br>
<asp:Repeater id="empRepeater" runat="server"></font></strong></p>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"><HeaderTemplate><br>
<table border="1" ><br>
<tr><br>
<th align="left">Name</th><br>
<th align="left">Age</th><br>
</tr><br>
</HeaderTemplate></font></strong></p>
<p><strong><font size="3" face="Arial, Helvetica, sans-serif"><ItemTemplate><br>
<tr><br>
<td><%#Container.DataItem("name")%> </td><br>
<td><%#Container.DataItem("age")%> </td><br>
</tr><br>
</ItemTemplate><br>
</font></strong><font size="3" face="Arial, Helvetica, sans-serif"> </font>
</p></td>
</tr>
<tr>
<td><h1><font color="#0099FF" size="7">Just copy the above two files in proper
location and open the file simpleRepeater.aspx. You will get the result
like this : </font></h1>
<table>
<tr>
<td><font size="7"><strong>Name</strong></font></td>
<td><font size="7"><strong>Age</strong></font></td>
</tr>
<tr>
<td><font size="7"><strong>Raja</strong></font></td>
<td><font size="7"><strong>25</strong></font></td>
</tr>
<tr>
<td><font size="7"><strong>Peter</strong></font></td>
<td><font size="7"><strong>23</strong></font></td>
</tr>
</table>
<p><strong><font color="#0066FF" size="7">Here XML file acts just like a Database</font></strong></p></td>
</tr>
</table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0tag:blogger.com,1999:blog-3724400308672579454.post-72961169367316889902009-05-01T02:33:00.000-07:002010-02-12T05:10:44.154-08:00C# Code:How to Connect to Oracle without tnsnames.ora<table>
<tr>
<td> <p><font color="#0099FF" size="6"><strong><font face="Arial, Helvetica, sans-serif">TESTED
OK ASP.NET CODE FOR </font></strong></font></p>
<p><font face="Arial, Helvetica, sans-serif"><strong><font color="#0099FF" size="6">ORACLE
DATABASE CONNECTIVITY</font></strong></font></p>
<p><font color="#333333" size="2" face="Arial, Helvetica, sans-serif"><%@
Page Language="C#" AutoEventWireup="true" CodeFile="login.aspx.cs"
Inherits="login" %><br>
<%@ Import NameSpace="System.Data.OracleClient" %><br>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
</font></p>
<font color="#333333">
<p><font size="2" face="Arial, Helvetica, sans-serif"><html xmlns="http://www.w3.org/1999/xhtml"><br>
<head runat="server"><br>
<title></title><br>
</head><br>
<body><br>
<form id="form1" runat="server"><br>
<div><br>
<%<br>
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;";<br>
OracleConnection conn = new OracleConnection(oradb);<br>
conn.Open();<br>
string sql = "select * from EMP";<br>
OracleCommand cmd = new OracleCommand(sql, conn);<br>
OracleDataReader dr = cmd.ExecuteReader(); <br>
dr.Read();</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif">label1.Text = dr["EMP_NAME"].ToString();
</font></p>
<p><font size="2" face="Arial, Helvetica, sans-serif"> %><br>
<br>
</div><br>
<asp:Label ID="label1" runat="server" Text="Label"></asp:Label><br>
</form><br>
</body><br>
</html></font></p>
</font></td>
</tr></table>Mathihttp://www.blogger.com/profile/03979427407848755119noreply@blogger.com0