Dim con As New ADODB.Connection
Dim Ret As New ADODB.Recordset
con.ConnectionString = "provider=sqloledb;database=NewSalary;Driver={SQL SERVER};server=;uid=temp;pwd=ok?"
con.Open
在链接到一个sql server数据库后 我想使用sql语句查询纪录,应该怎么做?
谢谢各位大虾
Dim Ret As New ADODB.Recordset
con.ConnectionString = "provider=sqloledb;database=NewSalary;Driver={SQL SERVER};server=;uid=temp;pwd=ok?"
con.Open
在链接到一个sql server数据库后 我想使用sql语句查询纪录,应该怎么做?
谢谢各位大虾
Dim Ret As New ADODB.Recordset
con.ConnectionString = "provider=sqloledb;database=NewSalary;Driver={SQL SERVER};server=;uid=temp;pwd=ok?"
con.Open
sql="select * from ***"
ret.open sql,con,3,2
操作
ret.close
con.close
Dim StrSql As String
StrSql = "SELECT * FROM [TABLENAME]"
Rst.CursorLocation = adUseClient
Rst.Open StrSql, Con, adOpenKeyset, adLockBatchOptimistic
msgbox Ret.fields(0)
Dim con As New ADODB.Connection
Dim Ret As New ADODB.Recordset
con.ConnectionString = "provider=sqloledb;database=NewSalary;Driver={SQL SERVER};server=;uid=temp;pwd=ok?"
con.Open Ret.CursorLocation = adUseClient
Ret.Open "select * from employees", con, adOpenDynamic, adLockBatchOptimistic Set DataGrid1.DataSource = Ret
执行sql语句:con.execute "insert into table ......."
cmd.ActiveConnection = conn
cmd.CommandText = "select * from employee"
cmd.Execute
Dim Ret As New ADODB.Recordset
set Ret=""
con.ConnectionString = "provider=sqloledb;database=NewSalary;Driver={SQL SERVER};server=;uid=temp;pwd=ok?"
con.Open
sql="select * from ***"
set ret=con.execute(sql)
操作
con.close
set Ret=""