Updating quantity in GridView

Hi guys,

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.

Thank you.

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
dt.Load(rdr)
GridView1.DataSource = dt
GridView1.DataBind()

Open in new window

LVL 7
Yury MerezhkovDevelopment Team LeadAsked:
Who is Participating?
 
Bob LearnedConnect With a Mentor Commented:
I would think that if you want edit controls (TextBox, DropDownList, ...), then it would be better to define the columns as TemplateFields, and then define the edit controls in the EditItemTemplate.
0
 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
That's what I did, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.