product.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class product : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 下载于www.51aspx.com
    }

    protected void addToCart(object sender, ImageClickEventArgs e)
    {
        AccessDataSource ads=new AccessDataSource();
        ads.DataFile="~/App_data/mystore.mdb";
        ads.SelectCommand = "SELECT * FROM [cart] WHERE [cartCustomer] ='" + Session["cartName"] + "' AND ProductID =" + FormView1.DataKey.Value;
        DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
        if(dv.Count == 0)
        {
            Label LB1=(Label)FormView1.FindControl("productnameLabel");
            Label LB2=(Label)FormView1.FindControl("productpriceLabel");
            ads.InsertCommand = "INSERT INTO [cart] ([cartCustomer], [ProductID], [ProductName], [UnitPrice], [Quantity]) VALUES (?, ?, ?, ?, 1)";
            ads.InsertParameters.Add("cartCustomer", Convert.ToString(Session["cartName"]));
            ads.InsertParameters.Add("ProductID", Convert.ToString(FormView1.DataKey.Value));
            ads.InsertParameters.Add("ProductName", LB1.Text);
            ads.InsertParameters.Add("UnitPrice", LB2.Text);
            ads.Insert();
        }
        else
        {
            ads.UpdateCommand = "UPDATE [cart] SET [Quantity] = [Quantity]+1 WHERE [cartCustomer] ='" + Session["cartName"] + "' AND ProductID =" + FormView1.DataKey.Value;
            ads.Update();
        }
        Response.Redirect("~/cartBasket.aspx");
    }
}