在VB中动态创建数据库
[ 来源: | 作者: | 更新日期:2007-7-25 19:51:52 |
评论 0 条 |
我要投稿 ]
在VB中动态创建数据库
新建工程.添加控件 对应写上代码
|
以下为引用的内容: Private Sub Command2_Click() Dim myDB As DAO.Database 'Set myDB = DAO.OpenDatabase("d:\mydb3.mdb") Set myDB = DAO.OpenDatabase(App.Path + "/mydb.mdb") Dim d As String d = "delete * from NewTable1" myDB.Execute d MsgBox "成功删除全部记录" 字串7
End Sub
Private Sub Command3_Click() Dim myDB As DAO.Database 'Set myDB = DAO.OpenDatabase("d:\mydb3.mdb") Set myDB = DAO.OpenDatabase(App.Path + "/mydb.mdb") Dim e As String e = "drop TABLE NewTable1" myDB.Execute e End Sub
Private Sub Form_Load() Dim myDB As DAO.Database 'Set myDB = DAO.Workspaces(0).CreateDatabase("d:\mydb3.mdb", dbLangGeneral) Set myDB = DAO.Workspaces(0).CreateDatabase(App.Path + "/mydb.mdb", dbLangGeneral) Dim str_SQL As String 字串6
str_SQL = "Create Table NewTable1(Field1 Text(10),Field2 Short)" myDB.Execute str_SQL Dim a As String a = "Insert INTO NewTable1 VALUES ('litao','21')" myDB.Execute a str_SQL = "Create Table NewTable2(Field1 Text(10),Field2 Short)" myDB.Execute str_SQL myDB.Close MsgBox "成功创建mydb3.mdb数据库外加一条记录litao 21" End Sub
Private Sub Command1_Click() Dim myDB As DAO.Database 'Set myDB = DAO.OpenDatabase("d:\mydb3.mdb") 字串6 Set myDB = DAO.OpenDatabase(App.Path + "/mydb.mdb") Dim c As String c = "Insert INTO NewTable1 VALUES ('liqiao','20')" myDB.Execute c MsgBox "成功插入一条记录liqiao 20" End Sub |
Tags:数据库 创建 动态 SetmyDB DAO.OpenDatabase mydb3.mdb