ashx操作数据库

public void ProcessRequest(HttpContext context)
{
    string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
    try
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            // 执行数据库操作
        }
    }
    catch (Exception ex)
    {
        // 记录错误信息
        context.Response.Write("数据库连接失败: " + ex.Message);
    }
}

public void ProcessRequest(HttpContext context)
{
    string userInput = context.Request.QueryString["id"];
    string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
    try
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            string query = "SELECT * FROM Users WHERE UserId = @UserId";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@UserId", userInput);
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    // 处理查询结果
                }
            }
        }
    }
    catch (Exception ex)
    {
        context.Response.Write("数据库操作失败: " + ex.Message);
    }
}