Common codes for ASP programming
1. Connect ASP to Access database:
The code copy is as follows:
<%
dimconn,mdbfile
mdbfile=server.mappath("database name.mdb")
setconn=server.createobject("adodb.connection")
conn.open"driver={microsoftaccessdriver(*.mdb)};uid=admin;pwd=database password;dbq="&mdbfile
%>
The most commonly used string function to connect asp and access
The code copy is as follows:
CallOpenConn
SubOpenConn()
OnErrorResumeNext
IfDataBaseType=1Then
ConnStr="Provider=Sqloledb;UserID="&datauser&";Password="&databasepsw&";InitialCatalog="&databasename&";DataSource="&dataserver&";"
Else
ConnStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&Server.MapPath(DBPath)
EndIf
Setconn=Server.CreateObject("ADODB.Connection")
conn.openConnStr
IfErrThenErr.Clear:Setconn=Nothing:Response.Write"The database connection error is occurring, please check the database parameter settings in the Conn.asp file.":Response.End
CollcetConnStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&Server.MapPath(CollectDBPath)
EndSub
2. Connect ASP to SQL database:
<%
dimconn
setconn=server.createobject("ADODB.connection")
con.open"PROVIDER=SQLOLEDB;DATASOURCE=SQL server name or IP address;UID=sa;PWD=database password;DATABASE=database name
%>
Create a record set object:
setrs=server.createobject("adodb.recordset")
rs.openSQL statement,conn,3,2
3. Common SQL command usage methods:
(1) Data record filtering:
sql="select*from data table where field name = field value orderby field name"
sql="select*from data table where field name like '% field value %'orderby field name"
sql="selecttop10*from data table where field name orderby field name"
sql="select*from data table where field name in('value 1','value 2','value 3')"
sql="select*from data table where field name between value 1 and value 2"