xu ly xoa sv
<!--#include file="connect.asp"--><head>
<meta http-equiv="Content-Language" content="en-us" charset="utf-8">
</head>
<%
m=request.form("ma")
t=request.form("ten")
l=request.form("lop")
tieuchi=request.form("xoa")
moketnoi
if tieuchi=1 then
cn.execute "delete from sinhvien where cstr(masv)='"&m&"'"
end if
if tieuchi=2 then
cn.execute "delete from sinhvien where cstr(malop)='"&l&"'"
end if
if tieuchi=3 then
cn.execute "delete from sinhvien where hoten='"&t&"'"
end if
response.write("Da xoa xong!")
set bang=server.createobject("ADODB.recordset")
bang.open "select * from hienthi",cn
%>
<table border="1" width="64%" id="table1">
<tr>
<td>Ma sv</td>
<td>Lop</td>
<td width="164">Ho ten</td>
<td width="99">ngay sinh</td>
<td>gioitinh</td>
</tr>
<% do while not bang.eof %>
<tr>
<td><%=bang("masv")%></td>
<td><%=bang("tenlop")%></td>
<td width="164"><%=bang("hoten")%></td>
<td width="99"><%=bang("ngaysinh")%></td>
<td><%=bang("gioitinh")%></td>
</tr>
<% bang.movenext
loop
%>
</table>
Bạn đang đọc truyện trên: Truyen247.Pro