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...