最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
ASP操作Access数据库的程序。(转)
时间:2022-06-30 10:23:55 编辑:袖梨 来源:一聚教程网
<%
'--- define DSN names in array
'--- enter one or more DSN name in the database_list array
database_list=Array("Test","test1")
'--- enable deleting table? -- Carefull!!
strEnableDeleteTable = False
'---- end declaration
'---- do not change code below this line ---------------------------------------------
field_value=Array("Integer","Double","char(255)","Memo","Date","Currency","YesNo")
field_display=Array("Integer","Number","Text","Memo","Date/Time","Currency","Yes/No")
dsn_name = Request("DatabaseName")
If Not dsn_name = "" Then
Set con = Server.CreateObject("ADODB.Connection")
Con.Provider = "sqloledb"
if dsn_name = "Test" then
ConStr = "Data Source =127.0.0.1;Initial Catalog=test;User ID=test;Password=1111"
else
ConStr = "Data Source =127.0.0.1;Initial Catalog=test1;User ID=test1;Password=1111"
end if
con.Open constr
End If
table_name = Request("TableName")
If Request("AddNewTable")<>"" Then
If Request("NewTableName") <> "" Then
SQL = "CREATE TABLE " & Request("NewTableName") & " (fldAuto Counter)"
con.Execute(SQL)
End If
End If
If Request("AddNewField")<>"" Then
'--- define DSN names in array
'--- enter one or more DSN name in the database_list array
database_list=Array("Test","test1")
'--- enable deleting table? -- Carefull!!
strEnableDeleteTable = False
'---- end declaration
'---- do not change code below this line ---------------------------------------------
field_value=Array("Integer","Double","char(255)","Memo","Date","Currency","YesNo")
field_display=Array("Integer","Number","Text","Memo","Date/Time","Currency","Yes/No")
dsn_name = Request("DatabaseName")
If Not dsn_name = "" Then
Set con = Server.CreateObject("ADODB.Connection")
Con.Provider = "sqloledb"
if dsn_name = "Test" then
ConStr = "Data Source =127.0.0.1;Initial Catalog=test;User ID=test;Password=1111"
else
ConStr = "Data Source =127.0.0.1;Initial Catalog=test1;User ID=test1;Password=1111"
end if
con.Open constr
End If
table_name = Request("TableName")
If Request("AddNewTable")<>"" Then
If Request("NewTableName") <> "" Then
SQL = "CREATE TABLE " & Request("NewTableName") & " (fldAuto Counter)"
con.Execute(SQL)
End If
End If
If Request("AddNewField")<>"" Then
相关文章
- 哔咔漫画app官网入口-哔咔漫画网页版官方直达 03-12
- 苹果18手机什么时候上市-预计价格多少-苹果18手机图片 03-12
- b站网页版登录入口-哔哩哔哩官网登录入口 03-12
- twitter官网网页版-twitter官方登录界面 03-12
- 谜漫画最新版下载安卓安装包-谜漫画安卓版官方下载地址入口 03-12
- manwa2漫蛙漫画官网-漫蛙manwa2漫画站 03-12