標籤：html ashx timeout query asc xmlns 頁面 public summary
del.ashx 刪除頁面
<%@ WebHandler Language="C#" Class="del" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.IO;
public class del : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
int id;
if (int.TryParse(context.Request.QueryString["id"], out id))
{
using (SqlConnection conn = new SqlConnection(GetConnStr()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "DELETE FROM Employee Where [email protected]";
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Value = id;
conn.Open();
if (cmd.ExecuteNonQuery() > 0)
{
context.Response.Redirect("UserList.ashx");
}
else
{
context.Response.Redirect("error.html");
}
}
}
}
else
{
context.Response.Write("參數錯誤");
}
}
/// <summary>
/// 返回資料庫的連接字串
/// </summary>
/// <returns></returns>
public string GetConnStr()
{
string ConnStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
return ConnStr;
}
public bool IsReusable {
get {
return false;
}
}
}
error.htm指令碼分頁錯誤跳轉
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
程式錯誤：<span id="time">5</span>秒鐘跳到<a href="UserList.ashx" id="url">跳轉到首頁</a>
<script type="text/javascript">
setTimeout(changCount, 1000);
function changCount() {
var time = document.getElementById("time").innerHTML;
time = parseInt(time);
time--;
if (time < 1) {
var url = document.getElementById("url").href;
window.location.href = url;
} else {
document.getElementById("time").innerHTML = time;
setTimeout(changCount, 1000);
}
}
</script>
</body>
</html>
ASP.NET 一般處理常式刪除資料
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
