在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 Stringd = "delete * from NewTable1"myDB.Execute dMsgBox "成功删除全部记录"End SubPrivate 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 Stringe = "drop TABLE NewTable1"myDB.Execute eEnd SubPrivate 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 Stringstr_SQL = "Create Table NewTable1(Field1 Text(10),Field2 Short)"myDB.Execute str_SQLDim a As Stringa = "Insert INTO NewTable1 VALUES ('litao','21')"myDB.Execute astr_SQL = "Create Table NewTable2(Field1 Text(10),Field2 Short)"myDB.Execute str_SQLmyDB.CloseMsgBox "成功创建mydb3.mdb数据库外加一条记录litao 21"End SubPrivate Sub Command1_Click()Dim myDB As DAO.Database'Set myDB = DAO.OpenDatabase("d:mydb3.mdb")Set myDB = DAO.OpenDatabase(App.Path "/mydb.mdb")Dim c As Stringc = "Insert INTO NewTable1 VALUES ('liqiao','20')"myDB.Execute cMsgBox "成功插入一条记录liqiao 20"End Sub |
