以变量为表名创建数据表
zcg 2009-07-18 12:21:46 实现动态添加数据表,以下是我的代码
Dim ConnectionString As String = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = d:\db1.mdb"
Dim myConn As OleDbConnection = New OleDbConnection()
myConn.ConnectionString = ConnectionString
myConn.Open()
TextBox3.Text =DateString '时间函数 ’textbox3也可赋值为数字变量,也未成功
Dim cre As String = "Create Table left('+ text3.text +' ,7) (id int identity(1,1),name varchar(50),sex varchar(50))" '时间函数
Dim cre As String = "Create Table '+ text3.text +' (id int identity(1,1),name varchar(50),sex varchar(50))" ’textbox3赋值为数字变量
Dim crecommand As OleDbCommand = New OleDbCommand(cre, myConn)
crecommand.ExecuteNonQuery() '执行建立表命令
myConn.Close() '关闭连接
提示Create Table 语法错误
希望实现的是取出DateString函数值的前七位即2009-07为表名,创建2009-7数据表,应如何实现,谢谢