Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
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()
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.