STUDENTS DATA SEARCH Name     Course City     State Previous School     Previous College <% set rs=server.createobject("adodb.recordset") current=request("current1") if current="" then current=1 end if rs.CursorType =adopenstatic rs.PageSize=20 if request("s1")="1" then sql="select id,student_name from student_rec where student_name Like '"&request("name1")&"%' order by id" elseif request("s1")="2" then sql="select id,student_name from student_rec where student_coursename_last_school like '"&request("course1")&"%' order by id" elseif request("s1")="3" then sql="select id,student_name from student_rec where student_city like '"&request("city1")&"%' order by id" elseif request("s1")="4" then sql="select id,student_name from student_rec where student_state like '"&request("state1")&"%' order by id" elseif request("s1")="5" then sql="select id,student_name from student_rec where student_last_school like '"&request("school1")&"%' order by id" elseif request("s1")="6" then sql="select id,student_name from student_rec where student_last_college like '"&request("college1")&"%' order by id" else sql="select id,student_name from student_rec order by id" end if 'response.write sql rs.open sql,con,3,2 if rs.bof=false then rs.AbsolutePage =Cint (current) rowcount=0 page_count=rs.PageCount rowcount=0 while not rs.eof and rowcount <% i=i+1 rs.movenext wend rs.close end if %> Sr No Name Full Details <%=rowcount%> <%=rs(1)%> )>

Copyright © lsr-reach.org , All Rights Reserved.