scoredel.asp

来自「学籍管理系统」· ASP 代码 · 共 18 行

<!--#include file="CheckLogin.asp"-->
<!--#include file="Connections/StudentConn.asp" -->
<%
dim strStudentNum
strSheetName=request("SheetName")
strStudentNum=request("StudentNum")
if strSheetName<>"" and strStudentNum<>"" then
	MM_editConnection = MM_StudentConn_STRING
	MM_editQuery = "delete from " & strSheetName & " where StudentNum = '" & strStudentNum & "'"
	Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

	response.redirect "ScoreQuery2.asp?" & Session("strQureyString")
end if
%>