<%@ Page Title="商品详情" Language="C#" MasterPageFile="~/Site
.Master" AutoEventWireup="true" CodeBehind="WebForm3
.aspx
.cs" Inherits="WebApplication1
.WebForm3" %>
<
asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<div class="product-container">
<
asp:Image ID="imgProduct" runat="server" CssClass="product-image" />
<div class="product-info">
<h1><
asp:Literal ID="ltProductName" runat="server" /></h1>
<div class="product-price">
<
asp:Literal ID="ltPrice" runat="server" />
</div>
<div class="product-description">
<h3>商品描述</h3>
<
asp:Literal ID="ltDescription" runat="server" />
</div>
<div class="product-stock">
<span>库存: </span>
<
asp:Literal ID="ltStock" runat="server" />
</div>
<
asp:Button ID="btnAddToCart" runat="server" Text="加入购物车"
CssClass="btn btn-primary" OnClick="btnAddToCart_Click" />
</div>
</div>
</
asp:Content>
前端代码
using System;
using System
.Data;
using System
.Data
.SqlClient;
using System
.Configuration;
namespace WebApplication1
{
public partial class WebForm3 : System
.Web
.UI
.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int productId;
if (int
.TryParse(Request
.QueryString["id"], out productId))
{
LoadProductDetails(productId);
}
else
{
Response
.Redirect("~/Default
.aspx");
}
}
}
private void LoadProductDetails(int productId)
{
string
connString = ConfigurationManager
.ConnectionStrings["DB-NetShops
ConnectionString"]
.ConnectionString;
using (Sql
Connection
conn = new Sql
Connection(
connString))
{
string query = @"SELECT p
.ProductID, p
.ProductName, p
.Description, p
.Price, p
.StockQuantity,
i
.ImagePath
FROM Products p
LEFT JOIN ProductImages i ON p
.ProductID = i
.ProductID
WHERE p
.ProductID = @ProductID";
SqlCommand cmd = new SqlCommand(query,
conn);
cmd
.Parameters
.AddWithValue("@ProductID", productId);
try
{
conn.Open();
SqlDataReader reader = cmd
.ExecuteReader();
if (reader
.Read())
{
ltProductName
.Text = reader["ProductName"]
.ToString();
ltDescription
.Text = reader["Description"]
.ToString();
ltPrice
.Text = $"{Convert
.ToDecimal(reader["Price"]):C}";
ltStock
.Text = reader["StockQuantity"]
.ToString();
if (!string
.IsNullOrEmpty(reader["ImagePath"]
.ToString()))
{
imgProduct
.ImageUrl = reader["ImagePath"]
.ToString();
}
}
reader
.Close();
}
catch (Exception ex)
{
// 记录
错误日志
System
.Diagnostics
.Debug
.WriteLine(ex
.Message);
}
}
}
protected void btnAddToCart_Click(object sender, EventArgs e)
{
int productId;
if (int
.TryParse(Request
.QueryString["id"], out productId))
{
// 添加到购物车的逻辑
// 可以使用Session或数据库存储购物车信息
}
}
}
}
后端代码
解决报错
本文分析了ASP网站中出现的“未指定的错误”，通常发生在使用ACCESS数据库时，详细介绍了错误原因及解决方法，包括如何压缩和修复数据库。
扫一扫
1440
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
