Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
|What "reference" libraries needed for Microsoft Access Professional Plus 2013||15||54|
|UK Date format in MS Access||4||22|
|How Do I Widen a Column in a SharePoint 2013 List||2||7|
|Why having to press tab key twice?||4||16|