各位大虾,本人在做与数据库绑定的程序时,
Data1.RecordSource = "Insert Into Login (Name,Password) Values('" & _
txtUserName.Text & "','" & txtPassword.Text & "' )"
Data1.Refresh运行程序时,Refresh总是报错,还有sql的Updata,Delete语句也同样报错
但select语句却可以执行,
不知这是VB的问题还是sql语句的问题?
Data1.RecordSource = "Insert Into Login (Name,Password) Values('" & _
txtUserName.Text & "','" & txtPassword.Text & "' )"
Data1.Refresh运行程序时,Refresh总是报错,还有sql的Updata,Delete语句也同样报错
但select语句却可以执行,
不知这是VB的问题还是sql语句的问题?
Private conn As ADODB.Connection
Private connstr As String
connstr="连接到数据库的连接字符串"
Set conn = New ADODB.Connection
conn.ConnectionString = connstr
conn.Open
cmd.ActiveConnection = conn
cmd.CommandText = "Insert Into Login (Name,Password) Values('" & _
txtUserName.Text & "','" & txtPassword.Text & "' )"
cmd.Execute
Data1.Refresh
而且使用Data控件,select语句就可以用Refresh