KULDIP GANDHI

<!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>
<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);
var st = "";
document.getElementById("d1").innerHTML = "";
var id = 1;
while(! rs.EOF)
{
document.getElementById("d1").innerHTML += " " + id + " " + rs(1) + " " + rs(2) + " " + rs(3) +"<br/>";
document.f1.t1.value = rs(0)
document.f1.t2.value = rs(1)
document.f1.t3.value = rs(2)
document.f1.t4.value = rs(3)
rs.MoveNext;
id++;
}
}
function show_data()
{
document.f1.t1.value = rs(0);
document.f1.t2.value = rs(1);
document.f1.t3.value = rs(2);
document.f1.t4.value = rs(3);
}
function save_data()
{
rs(0)=document.f1.t1.value;
rs(1)=document.f1.t2.value;
rs(2)=document.f1.t3.value;
rs(3)=document.f1.t4.value;
rs.Update();
alert("Record Saved...");
}
function blank_data()
{
document.f1.t1.value="";
document.f1.t2.value="";
document.f1.t3.value="";
document.f1.t4.value="";
}

function rec_first()
{
rs.MoveFirst();
show_data();
}
function rec_last()
{
rs.MoveLast();
show_data();
}
function rec_prev()
{
rs.MovePrevious();
if(rs.BOF)
{
rs.MoveFirst();
alert("This is first Record")
}
show_data();

}
function rec_next()
{
rs.MoveNext();
if(rs.EOF)
{
rs.MoveLast();
alert("This is last Record");
}
show_data();

}
function rec_add()
{
rs.AddNew();
blank_data();
}
function rec_save()
{
var ptr;
ptr=confirm("Do u want to Save Record?");
if(ptr==true)
{
save_data();

}
Rs.MoveFirst();
Show_data();
}
function rec_Delete()
{
var ptr;
ptr=confirm("Do u want to Delete Record?");
if(ptr==true)
{
rs.Delete();
rs.Update();
}
rs.MoveFirst();
rs.ShowData();
}
function rec_Search()
{
var id=document.f1.t1.value;
rs.MoveFirst();
while(!rs.EOF)
{

if(id==rs(0))
{
show_data();
return;
}
rs.MoveNext();
}
alert("Record Not found...")
}

</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body onload="disp()">
<form name="f1">
<table width="612" border="1px">
<tr>
<td colspan="2"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="600" height="84">
<param name="movie" value="Yahoo.swf" />
<param name="quality" value="high" />
<embed src="Yahoo.swf"
quality="high"
type="application/x-shockwave-flash"
width="600"
height="84"
pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object></td>
</tr>
<tr>
<td align="center">Student No</td>
<td align="center"><input type="text"name="t1"/></td>
</tr>
<tr>
<td align="center">Student Name</td>
<td align="center"><input type="text"name="t2"/></td>
</tr>
<tr>
<td align="center">City</td>
<td align="center"><input type="text"name="t3"/></td>
</tr>
<tr>
<td align="center">Pincode</td>
<td align="center"><input type="text"name="t4"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="Button" value="First" onclick="rec_first()"/>    
<input type="Button" value="Prev" onclick="rec_prev()"/>    
<input type="Button" value="Next" onclick="rec_next()"/>    
<input type="Button" value="Last" onclick="rec_last()"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="Button" value="Add" onclick="rec_add()"/>    
<input type="Button" value="Edit"/>    
<input type="Button" value="Delete" onclick="rec_Delete()"/>    
<input type="reset" value="Reset">    
<input type="Button" value="Search" onclick="rec_Search()"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="Button" value="Sava" onclick="rec_save()"/>    
<input type="Button" value="Close"/></td>
</tr>
</table>
<div id="d1">Student Info</div>
</form>
</body>
</html>

Untitled Document <!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>
<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>

KULDIP GANDHI

Monday, 24 September 2012

Monday, 17 September 2012


Student No
Student Name
City
Pincode