33
Load table
from SQLServer: ASPX data sets
l<%@ Page language="VB"
debug="true"%>
l<%
lConst adOpenStatic = 3
DIM nStart AS Double
DIM oDS AS System.Data.DataSet
DIM oOleDB AS
System.Data.OleDb.OleDbConnection
DIM oSqlClient AS
System.Data.SqlClient.SqlConnection
lDIM oOleDA AS System.Data.OleDb.OleDbDataAdapter
lDIM oSqlDA AS System.Data.SqlClient.SqlDataAdapter
lDIM oRows AS System.Data.DataRowCollection
lDIM cFields AS String
cFields="_ID,Appointment_Notes
FROM Visit_"
cFields="* FROM
Visit_"
lnStart=TIMER
loDS=new System.Data.DataSet()
loDS.Clear
lResponse.Write("Created data set
"+CSTR(TIMER-nStart)+"<br>")
oOleDB=new
System.Data.OleDb.OleDbConnection("Provider=SQLOLEDB;"+ _
"SERVER=(local);DATABASE=test;UID=user;Password=pass;")
loSqlClient=new System.Data.SqlClient.SqlConnection(
_
"SERVER=(local);DATABASE=test;UID=user;Password=pass;")