<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script language="javascript">
var cn=new ActiveXObject("ADODB.Connection");
var str="provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\kuldip\\student.mdb";
var rs=new ActiveXObject("ADODB.Recordset");
rs.LockType=3;
function disp()
{
alert("hi");
var sql="select * from stud";
cn.open(str);
rs.open(sql,cn);
//alert (rs(1));
document.f1.t1.value = rs(0);
document.f1.t2.value = rs(1);
document.f1.t3.value = rs(2);
while(!rs.EOF)
{
document.getElementById("d1").innerHTML += rs(0) + " " + rs(1) + " " + rs(2) + "<br/>";
rs.MoveNext();
}
}
</script>
</head>
<body onload="disp()">
<form name="f1">
<table border="1px" align="center">
<tr>
<td>Registration Form</td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="t1"/></td>
</tr>
<tr>
<td>City</td>
<td><input type="text" name="t2" /></td>
</tr>
<tr>
<td>Pincode</td>
<td><input type="text" name="t3" /></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="button" value="First" />
<input type="button" value="Next" />
<input type="button" value="Pre" />
<input type="button" value="Last" /></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="button" value="Insert" />
<input type="button" value="Edit" />
<input type="button" value="Delete" />
<input type="button" value="Clear" /></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="button" value="Save" />
<input type="button" value="Search" />
</td>
</tr>
</table>
<div id="d1"></div>
</form>
</body>
</html>
No comments:
Post a Comment