ASP — Database

ADO Connection

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=server;Initial Catalog=mydb;User Id=user;Password=pass;"
%>

Execute Query

<%
Set rs = conn.Execute("SELECT * FROM users")

Do While Not rs.EOF
    Response.Write(rs("name") & "<br>")
    rs.MoveNext
Loop

rs.Close
Set rs = Nothing
%>

Parameterized Query

<%
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "SELECT * FROM users WHERE id = ?"

Set param = cmd.CreateParameter("id", 3, 1, , Request.QueryString("id"))
cmd.Parameters.Append param

Set rs = cmd.Execute
%>

Insert Data

<%
sql = "INSERT INTO users (name, email) VALUES ('" & name & "', '" & email & "')"
conn.Execute sql
%>

Mini Practice

Connect to database
Execute SELECT query
Loop through results
Insert data

Up Next

Continue with ADO — ActiveX Data Objects.

Frequently Asked Questions about Database

What is Database in ASP?

Database is a fundamental concept in ASP. This lesson explains it step by step with clear examples, making it easy for beginners to understand.

How do I learn Database?

Start by reading the explanation above, then try the code examples. Practice by modifying the examples and experimenting with different values. Hands-on practice is the best way to learn Database.

Why is Database important in ASP?

Database is essential for ASP development. Understanding this concept will help you write better code and solve real-world problems more effectively.