ashx数据库增删改查

<%@ WebHandler Language="C#" Class="MyHandler" %>

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;

public class MyHandler : IHttpHandler {

    public void ProcessRequest(HttpContext context) {
        string connectionString = "your_connection_string_here";
        string query = "SELECT * FROM YourTable WHERE SomeColumn = @Value";

        using (SqlConnection connection = new SqlConnection(connectionString)) {
            SqlCommand command = new SqlCommand(query, connection);
            command.Parameters.AddWithValue("@Value", context.Request.QueryString["id"]);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read()) {
                // 处理查询结果
            }
        }
    }

    public bool IsReusable {
        get {
            return false;
        }
    }
}