ASP sample code which shows how to connect to a da - Visual Basic , VB.NET

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

ASP sample code which shows how to connect to a da...
Author: Peter Riley
E-mail: Click to e-mail author
Submitted: 2/13/2001
Version: ASP
Compatibility: ASP
Category: ASP
Views: 19978
ASP sample code which shows how to connect to a database, create a recordset containing data from a table, and then display the results.
Declarations:
Dim Conn AS ADODB.Connection Dim rs AS ADODB.Recordset
Code:
<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "mydatabase" 'DSN SQL = "SELECT * FROM tblEmployee where Age < 50 order by Name" Set rs = Conn.Execute(SQL) %> 'Display results <% do while not rs.EOF %> <% =rs("Name") %>, <% =rs("Surname") %>, <% =rs("Age") %><br> <% rs.movenext loop %> <% rs.close set rs = nothing %>