|
|
<%
sinav=request.form("sinav")
if sinav="" then
sinav=request.QueryString("sinav")
end if
if islem="1" and sinav<>"" then
set opuan_bul1 = Server.CreateObject("ADODB.Recordset")
opuan_bul1.open "SELECT* FROM optik1 where sinavkodu="&sinav&"",erdc1,1,3
if not opuan_bul1.eof then
%>
<%end if
end if
if islem=2 then
sinav=request.Form("sinav")
sayi=request.Form("sayi")
for ik=1 to sayi
idform=request.form("idform"&ik&"")
adi=request.form("adi"&ik&"")
ogrno=request.form("ogrno"&ik&"")
sinif=request.form("sinif"&ik&"")
kimlikno=request.form("kimlikno"&ik&"")
okulturu=request.form("okulturu"&ik&"")
grup=request.form("grup"&ik&"")
testno=request.form("testno"&ik&"")
set gnc = Server.CreateObject("ADODB.Recordset")
gnc.open "SELECT* FROM optik1 where idform="&idform&"",erdc1,1,3
gnc("adi")=adi
gnc("ogrno")=ogrno
gnc("sinif")=sinif
gnc("kimlikno")=kimlikno
gnc("okulturu")=okulturu
gnc("grup")=grup
gnc("testno")=testno
gnc.update
gnc.close
set gnc= Nothing
next
response.Redirect("optik1.asp?islem=1&sinav="&sinav&"")
end if
if islem=3 then
sinav=request.querystring("sinav")
idform=request.querystring("kayit")
set sil = Server.CreateObject("ADODB.Recordset")
sil.open "SELECT* FROM optik1 where idform="&idform&"",erdc1,1,3
sil.delete
sil.update
sil.close
set sil= Nothing
response.Redirect("optik1.asp?islem=1&sinav="&sinav&"")
end if
%>
| |
|