redirectcs.aspx

来自「商务网站全部程序.很有借鉴意义」· ASPX 代码 · 共 62 行

ASPX
62
字号
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.oledb" %>
<script runat="server">
dim conn as new oledbconnection("provider=microsoft.jet.oledb.4.0; data source="+server.MapPath("data/sites.mdb"))
sub page_load(obj as object,e as eventargs)

    update_count()
	response.Redirect(redirectcs)

end sub
sub update_count()
	  dim objcmd as new oledbcommand("update_cs_count",conn)
      objcmd.commandtype=commandtype.StoredProcedure

	  dim objParam as oledbParameter
	  
	  objParam=objcmd.Parameters.add("@cs_id",oledbtype.integer)
	  objParam.direction=parameterdirection.input
	  objParam.value=request("cs_id")
	  
	try
	   conn.open()
       objcmd.executenonquery
	   conn.close()
	catch ex as exception
	  response.write(ex.message)
	  response.End()
	end try   
end sub

function redirectcs() as string
	  dim objcmd as new oledbcommand("redirect",conn)
      objcmd.commandtype=commandtype.StoredProcedure

	  dim objParam as oledbParameter
	  
	  objParam=objcmd.Parameters.add("@cs_id",oledbtype.integer)
	  objParam.direction=parameterdirection.input
	  objParam.value=request("cs_id")
	  
	try
	   conn.open()
       return objcmd.executeScalar
	   conn.close()
	catch ex as exception
	   return ex.message
	end try  
end function

</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head>
<body>

</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?