Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.
Dim strSQL1 As String = "SELECT P.Title, P.Artist, P.Price, SUM(P.Price) AS SubTotal FROM Products P, Cart C WHERE C.SessionID='" & _ Session.SessionID & "' AND P.ProductID=C.ProductFK1 GROUP BY P.Title, P.Artist, P.Price" Dim subtotal, tax, total As Double Dim objCommand1 As New System.Data.OleDb.OleDbCommand(strSQL1, objConnection) Try objConnection.Open() Dim rdr As System.Data.OleDb.OleDbDataReader = objCommand1.ExecuteReader Dim dt As System.Data.DataTable = New System.Data.DataTable dt.Load(rdr) objConnection.Close() GridView1.DataSource = dt GridView1.DataBind() dt.Dispose() Catch ex As Exception MsgBox("Connection failed to open. Error: " & ex.ToString()) End Try
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.