Query an SQL database with .NET SQL Data Provider in ASP.NET

<%@ 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>
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL server- network related or instance-specific error happened while connection establishing

  Instance-specific or network related error happening while connecting to SQL server   Please...

OleDB connection string examples

OleDB connection string examples MS Access (Jet) "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

Do you allow custom COM components?

Do you allow custom COM components? We are not offering to install the custom COM components...

Error when accessing a WCF services

Error when accessing a WCF services Error when accessing a WCF service: "IIS specified...

How to cache static contents to client with UseMaxAge?

You can consider to caches static contents to the client with UseMaxAge if your website has too...