Hey! thanks for reply but i m just a beginner and i have not learn anything about .asp yet. For this i have a database table .mdb and an html page "studentinfo" and an edit page which is also in html. What ever i edit on my 'edit page' should reflect on the database table it should edit in database automatically. I already have a studentinfo table which uses sql syntex of "insert" and just want to know the correct way for the update syntax of sql. please reply soon....Thanks.
<title>Edit_Page</title></head><body><form id="frm2" name="frm2" method="post" action=" "><fieldset><legend align="center">Edit Student Info</legend><table align="center" border="0"><tr> <td>ID:</td> <td><input type="text" id="txtId" name="txtId" /></td></tr><tr> <td>First Name:</td> <td><input type="text" id="txtFname" name="txtFname" /></td></tr><tr> <td>Last Name:</td> <td><input type="text" id="txtLname" name=