Migrate from classic to asp.net





For Migrating from Classic ASP to ASP.NET, the following code will
be very much useful:


 


<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="jto2007.aspx.cs" Inherits="_Default" %>

<%@ Import Namespace="System.Data" %>

<%@ 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>JTO 2007</title>



</head>

<body>

<%

//Set myconn=Server.CreateObject THIS IS FOR CLASSIC ASP

String sConn="Data Source=xe;User Id=scott;Password=tiger";

OracleConnection myConn = new OracleConnection(sConn);

OracleCommand sql = new OracleCommand("select * from emp",myConn);

OracleDataAdapter da = new OracleDataAdapter(sql);

DataSet ds = new DataSet();

da.Fill(ds,"table1");

%>

<table>

<%foreach (DataRow dr in ds.Tables["table1"].Rows){%>

<tr><td>

<%Response.Write(dr["emp_id"].ToString()); %>

</td>

</tr>

<% }%>

</table>

</body>

</html>


=============================


To delete a record.


int i =0;


foreach (DataRow dr in ds.Tables["table1"].Rows){


i++;


if (dr["id"] = = 23 )


break;


}


table1.Rows[i].Delete;


Edit a record:


foreach (DataRow dr in ds.Tables["table1"].Rows)


if (dr["id"] = = 23 )


dr["name"] = "new name";




Insertion a record


DataRow dr = EmployeeData.NewRow();


dr["id"] = "23";


dr["name"] = "raja";


table1.Rows.Add(dr);


All the above delete,edit and insert done in DataTable which is


nothing but the Memory. We have to write back into the Hard disk database.



OracleCommandBuilder cb = new OracleCommandBuilder (da);


DataSet newds = ds.GetChanges (DataRowState.Modified);


da.Update(newds, "table1");