Common code for WEB programming and development

 
1. ASP and Access database connection:
Dim conn, mdbfile
Mdbfile = server. mappath ("database name. mdb ")
Set conn = server. createobject ("adodb. connection ")
'Conn. open "driver = {microsoft access driver (*. mdb)}; uid = admin; pwd = database password; dbq =" & mdbfile
Conn. open "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" & mdbfile
2. Connection between ASP and SQL database: dim conn
Set conn = server. createobject ("ADODB. connection ")
Con. open "PROVIDER = SQLOLEDB; data source = SQL server name or IP address; UID = sa; PWD = DATABASE password; DATABASE = DATABASE name ;"
 
Set rs = server. createobject ("adodb. recordset ")
Rs. open SQL statement, conn, 3, 2
Common SQL commands:
Data Record filtering: SQL = "select * from data table where field name = field value order by field name"
SQL = "select * from data table where field name like '% field value %' order by field name"
SQL = "select top 10 * from data table where field name order by 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" update data record: SQL = "update data table set field name = field value where condition expression"
SQL = "update data table set Field 1 = value 1, field 2 = value 2 ...... Field n = value n where condition expression"
Delete data records: SQL = "delete from data table where condition expression"
SQL = "delete from Data Table" (delete all data table Records)
Add data records: SQL = "insert into data table (Field 1, field 2, Field 3 ...) Valuess (value 1, value 2, value 3 ...) "
SQL = "insert into target data table select * from Source Data Table" (add records of source data table to target data table) data record statistical function: