I have a GridView in my cart. Everything works perfectly. The columns are auto-generated with the following code. I want to have textboxes in quantity column instead of just text. I want users to be able to input new quantity value and click button Update Quantities in order to update quantities for the items quantities of which were changed. Or any other way that you can offer of doing that. Newegg.com cart does this beautifully.
Dim strSQL1 As String = "SELECT P.Title, P.Artist, P.Price, SUM(P.Price) AS SubTotal, Count(P.ProductID) AS Qty FROM Products P, Cart C WHERE C.SessionID='" & _
Session.SessionID & "' AND P.ProductID=C.ProductFK1 GROUP BY P.Title, P.Artist, P.Price"
Dim sqlCommand1 As New System.Data.SqlClient.SqlCommand(strSQL1, sqlConnection)
Dim rdr As System.Data.SqlClient.SqlDataReader = sqlCommand1.ExecuteReader
Dim dt As System.Data.DataTable = New System.Data.DataTable
GridView1.DataSource = dt