<%@ import namespace="system.data.sqlclient" %> <Script runat="server"> Sub page_load Dim dbconn as sqlconnection Dim dbCMD as sqlCommand Dim dtr as sqldatareader dbConn = New SQLConnection ("Data Source=DBSERVERNAME;Initial Catalog=YOURDBNAME;User ID=YOURUSERID;Password=YOURPASSWORD") dbConn.open() dbCMD = new sqlcommand ("select * from tblTest",dbconn) dtr = dbCMD.executereader() While dtr.read() response.write ("<li>") response.write (dtr(0) & "---" & dtr(1)) End while dtr.close() dbConn.close() End Sub </Script>
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add support@discountasp.net to your trusted senders list in your email software.