如何计算购物车中物品的数量

问题描述：

我正在开发一个在线购物网站..因此，当用户将任何物品添加到购物车时，我将它存储在一张桌子中......现在我想要的是计算购物车中的物品以及每次用户添加新物品时都会更新购物车中的物品数量....如何计算购物车中物品的数量

请帮助我...我对asp.net非常陌生。

Public Function AddToCart(ByVal itemID As String, ByVal itemName As String, ByVal itemPrice As Integer, _ 
          ByVal offer As String, ByVal buyNo As String, ByVal userID As String) As String 

     Dim sqlStatement As String = "INSERT INTO shoppingCart" & _ 
      "(buyNo, userID, itemID, itemName, itemPrice, offer, itemQtty)" & _ 
      "VALUES('" & buyNo & "','" & userID & "','" & itemID & "','" & itemName & "'," & itemPrice & ",'" & offer & "'," & _ 
        "1)" 

     Dim connStr As String = ConfigurationManager.ConnectionStrings("databaseConnectionString").ConnectionString 

     Dim con As New SqlClient.SqlConnection(connStr) 
     'Dim con As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;" & _ 
     '          "AttachDbFilename=|DataDirectory|\database.mdf;" & _ 
     '          "Integrated Security=True;User Instance=True") 
     Dim sql As New SqlClient.SqlCommand(sqlStatement, con) 
     con.Open() 
     sql.ExecuteNonQuery() 
     con.Close() 
     con.Dispose() 
     MsgBox("Item with 'Item ID: " & itemID & "' & 'Item Name: " & itemName & _ 
       "' has been added to the cart!") 

     Dim sno As Integer = CType(Replace(buyNo, userID, ""), Integer) 
     sno = sno + 1 
     buyNo = userID & sno 

     Return buyNo 
    End Function

如果您是新手，最好使用完整文档附带的盒子。 – 2011-06-12 13:03:34

请显示您的代码。 – Predator 2011-06-12 13:04:31

你介意帮我吗??? – Monodeep 2011-06-12 13:04:46

答

我想你是非常新的编程，但每个人都在某个时刻开始。

IF你使用任何类型的DATABSE备份您在后端，你可以做这样的事情：

select sum(item_quantity) from user_shopping_cart

给你的项目数在用户的购物车。

如何计算购物车中物品的数量

相关推荐