请各位高手帮我看一下,我以在SQL SERVER中建立了一个以系统日期为表名的表,现在想在VB界面下实现向表填加数据。可是实现不了,不知错在那了。
Option Explicit
Dim conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPrivate Sub Command1_Click()
rs.AddNew
rs.Fields("id").Value = Text1.Text
rs.Fields("num").Value = Text2.Text
rs.Update
End SubPrivate Sub Form_Load()
conn.ConnectionString = "Driver={sql server};server=hh-bfa849b285ca;uid=sa;pwd=;database=yhm"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "declare @dt varchar(10) select @dt=convert(varchar(10),getdate(),120) declare @s varchar(200) set @s='select * from ['+ @dt +']'", conn, adOpenDynamic, adLockOptimistic, adCmdTextText1.Text = ""
Text2.Text = ""End Sub
Option Explicit
Dim conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPrivate Sub Command1_Click()
rs.AddNew
rs.Fields("id").Value = Text1.Text
rs.Fields("num").Value = Text2.Text
rs.Update
End SubPrivate Sub Form_Load()
conn.ConnectionString = "Driver={sql server};server=hh-bfa849b285ca;uid=sa;pwd=;database=yhm"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "declare @dt varchar(10) select @dt=convert(varchar(10),getdate(),120) declare @s varchar(200) set @s='select * from ['+ @dt +']'", conn, adOpenDynamic, adLockOptimistic, adCmdTextText1.Text = ""
Text2.Text = ""End Sub
strsql = "'select * from ['+ @dt +']'"
adors.open strsql,conn, adOpenDynamic, adLockOptimistic
http://www.anylib.com