Hello, if you want to know the details about the Caching Records in Memory with ASP.NET, then you must need to make use of the code below:
Code:
<%
Function Disp()
Const Text = &H0001
Dim sqlq, connection , result
sqlq = "SELECT id, FName, lLName FROM Names"
Set connection = Server.CreateObject("ADODB.Connection")
connection .Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & _
Server.MapPath("CacheDemo.mdb")
Set result = Server.CreateObject("ADODB.Recordset")
result.Open sqlq, connection , 2, 4, Text
If Not result.EOF Then
Dim variable
variable = "<table width=""90%"" align=""center"""
variable = variable & " border=""1"" bordercolor=""silver"""
variable = variable & " cellspacing=""2"" cellpadding=""0"">"
variable = variable & "<tr bgcolor=""#CCDDEE""><td width=""5%"""
variable = variable & ">ID</td><td>Firesultt Name</td>"
variable = variable & "<td>Last Name</td></tr>"
While Not result.EOF
variable = variable & "<tr><td bgcolor=""#CCDDEE"">"
variable = variable & result("ID") & "</td><td>" & result("FName")
variable = variable & "</td><td>" & result("lLName")
variable = variable & "</td></tr>"
result.MoveNext
Wend
variable = variable & "</table>"
Disp = variable
Else
Disp = "Data Not Available."
End If
result.Close
connection .Close
Set result = Nothing
Set connection = Nothing
End Function
%>
Bookmarks