ASP call database problem helps

I'll give you a backend page.

city="city")'This is based on the name attribute of your form.

set conn="")

The name of the database")&"'Please refer to the name of your classmate's road sign.

set rs="")

sql="select * from table name where city='"&city&"'"

sql,conn,1,1

if and then

There are no classmates in the city")

Name. Gender.

Birthday. City.

while not

tr><%=rs("Name. ")%>

rs("Gender. ")%>

rs("Birthday. ")%>

rs("city")%>

end if

set rs=nothing

set conn=nothing

Add a condition when querying.

select * from where city name='variable (the name of the city you enter).'

Let's say you've already brought in the conn file.

set rs = "")

select * from [table name] where City='" & cityname & "'",conn,1,1

do while not

rs("Name. ") &"

set rs = nothing

It depends on what data you're calling!

ASP is just 4 main SQL statements, query the data and you can get the data!!

Instance: <%

set rs="")

sql="select * form data table"

conn,1,1 'Here conn is the variable name %> that connects to the database

=rs("Here is the database field name"%> here you can display the first value of this field in the database. There are many other display methods, and if necessary, it is recommended that you learn ASP yourself!!

Then you can make an access database, which doesn't need a server. Access is just a file that can be accompanied by the program.

The principle of ASP access to the database.

ASP is a server-side script execution environment that can be used to generate and execute dynamic, high-performance web server programs.

When the user uses the browser to request the ASP home page, the web server responds, calls the ASP engine to execute the ASP file, interprets the script language (jscript or vbscript) in it, connects to the database through ODBC, and the database access component ADO (ActiveX Data Objects) completes the database operation, and finally the ASP generates an HTML home page containing the data query results and returns it to the user for display.

Since ASP runs on the server side, the running result is returned to the user's browser in the form of HTML homepage, so the ASP source program will not be leaked, which increases the security and confidentiality of the system. In addition, ASP is an object-oriented scripting environment, and users can add their own ActiveX components to extend its functionality and expand the scope of applications.