Website Stats to Date
Widgets Viewed: 2,442,690
Active Users 10
We Accept PayPal®
Storing a DataSet in a Session Variable (ASP.NET)
Dim DB As New
Dim DA As System.Data.OleDb.OleDbDataAdapter
Dim DS As New
''WHEN THE PAGE IS LOADED CHECK FOR A VALUE IN THE SESSION VARIABLE
''IF NOT FOUND LOAD THE DATA FROM THE DATABASE AND STORE IT IN A SESSION VARIABLE FOR LATER
DB = Session("DBCon")
Dim SQL As String =
"Select * From ProductCategories Order By Category"
DA = New System.Data.OleDb.OleDbDataAdapter(SQL,
Session("Categories") = DS
Session("DBCon") = DB
DB = Nothing
''IF THE SESSION VARIABLE CONTAINS A DATASET THEN DON'T LOAD FROM THE DATABASE
''USING THE DATASET FROM THE SESSION VARIABLE REDUCES DATABASE ACCESS
DS = Session("Categories")
DGrid.DataSource = DS
Last Updated: 4/27/2018
This source code is provided to you "as is" without warranty
Copyright 2000-2006 Comrie Software Solutions
(0) Items $0.00
Microsoft® Access (Monthly View)
.. this is one site that believes in Customer Service. I had questions, I had answers quickly. No "wait for days", No "buy this and
find out". Just courteous and HELPFUL answers.
It is refreshing to find a site that really cares about their products and
stands behind them!
And their products perform as they promote them.John L.
When I received my ASP.NET E-Commerce application it was for the purpose of marketing my software inventory via the internet. It took a minimal amount of time to launch it and offers host of traffic tracking options for further market study and analysis. Overall an excellent product.
No Credit Card or Financial information is stored by CodeWidgets.com.