在程序中如何ACCESS库中是否有此表,如有则进行添加记录如没有则先建立表然后再添加记录?最好给一个实例?谢谢各位了!
解决方案 »
- 打印报表出错:页眉加上页脚对页面来说太大
- 求编程实现midi格式 to wav格式,有人知道吗?
- VB6的安装向导Setup1.exe
- 【关于WebBrowser1.Busy~~~~~~~~~~~】请问VB程序执行太快了,怎么办。
- 如何保存COMMON DIALOG的设置,以及如何知道点击了确定后保留,电击取消放弃,是if button=vbyes then .....end if
- 如何在文本框中禁止字符的输入,很老的问题,忘了以前别人如何解决的
- 迷茫的人在寻找答案:vb.net delphi和java2我应该学习哪个?
- [求助] 自定义控件的LOAD为什么没系统的LABEL快
- hxfyn = MsgBox(hxfyear & "年" & hxfmath & "月" & "的工资库已打开,是否关闭?", 36)
- 如何用程序实现将webbrower中浏览的网页保存成*.mht格式。
- 计算机三声长叫什么地方坏了
- 【CSDN】【请问如何在程序中删除当前ADO正在使用的SQL数据库】
... '创建表
end if
... '添加记录set rs1=nothing
'创建表
cn.execute "create table "& strtablename & "(a int,b int)"
end if
'添加记录
cn.execute "insert into " & strtablename & "(a,b) select 1,2"
rs.close
set rs=nothing
'用ado怎样实现
'工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)
'----------------------------------------------------------------------------
Private Sub Form_Load()
Dim adoCN As New ADODB.Connection '定义数据库的连接
Dim strCnn As New ADODB.Recordset
Dim rstSchema As New ADODB.Recordset
Dim I As Integer
str1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Northwind.MDB;Persist Security Info=False"
adoCN.Open str1
Set rstSchema = adoCN.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
If rstSchema!TABLE_TYPE = "TABLE" Then
out = out & "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
I = I + 1
End If
rstSchema.MoveNext
Loop
MsgBox I
rstSchema.Close
adoCN.Close
Debug.Print out
End Sub
'引用Microsoft ADO Ext 2.5 for DDL and Security
Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Dim con As ADODB.Connection On Error GoTo 0 ' Create the new database.
Set cat = New ADOX.Catalog
cat.Create _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DatabaseName & ";" ' Create a new table.
Set tbl = New ADOX.Table
tbl.Name = "TestTable"
tbl.Columns.Append "FirstName", adVarWChar, 40
tbl.Columns.Append "LastName", adVarWChar, 40
tbl.Columns.Append "Birthdate", adDate
tbl.Columns.Append "Weight", adInteger
cat.Tables.Append tbl
'设置列可以为NULL
tb1.columns("Weight").Attributes=AdColNullable
' Connect to the database.
Set con = cat.ActiveConnection ' Insert records.
con.Execute "INSERT INTO TestTable VALUES ('Andy', 'Able', '1 Jan 1980', '150')"
con.Execute "INSERT INTO TestTable VALUES ('Betty', 'Baker', #2/22/1990#, 70)" ' Close the database connection.
con.Close
Set con = Nothing
Set tbl = Nothing
Set cat = Nothing