<%
id_no=request.form("id_no")
program=request.form("program")
SET conn=server.createobject("ADODB.connection")
conn.open "reg"
set rs=server.createobject("ADODB.recordset")
sql="SELECT * FROM stu_record WHERE roll_no='"&id_no&"'AND program='"&program&"' "
rs.open sql,conn
If not rs.eof then
rollno=rs("roll_no")
program1=rs("program")%>