Dim rs As ADODB.Recordset
Private Sub Command1_Click()Dim db As ADODB.Connection
Set db = New Connection
db.CursorLocation = adUseClientdb.Open "PROVIDER=MSDASQL;dsn=xxx;uid=sa;pwd=123456;database=master;"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Properties.Item("Unique Catalog").Value = "master"
rs.Properties.Item("Unique Schema").Value = "dbo"rs.Properties.Item("Unique Table").Value = "td1"
rs.Open "SELECT td1.age, td2.name FROM td1 inner JOIN td2 ON td1.id = td2.id", db, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rs
End SubPrivate Sub Command2_Click()
rs.Delete
End Sub帮我改改
Private Sub Command1_Click()Dim db As ADODB.Connection
Set db = New Connection
db.CursorLocation = adUseClientdb.Open "PROVIDER=MSDASQL;dsn=xxx;uid=sa;pwd=123456;database=master;"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Properties.Item("Unique Catalog").Value = "master"
rs.Properties.Item("Unique Schema").Value = "dbo"rs.Properties.Item("Unique Table").Value = "td1"
rs.Open "SELECT td1.age, td2.name FROM td1 inner JOIN td2 ON td1.id = td2.id", db, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rs
End SubPrivate Sub Command2_Click()
rs.Delete
End Sub帮我改改
解决方案 »
- vb 网络编程 遇到的 关于接收缓冲区问题
- 新手VB
- 如何将Picturebox中所有内容截图
- vb6.0 操作EXCEL格式问题 怎么把几列的数据格式保留百分位
- 新手求教:不同窗口间参数的调用问题
- 请教一SQL语句写法.急!
- //关于访问远程ACCESS数据库的问题,查询了以前的大量的帖子,可能是我水平太差,感到无从下手,请看我的需求。
- VB连接ORACLE时为什么不能使用GROUP BY?
- win7下编译vb6+ado2.7程序问题,请大家指教
- 请问 " Me.ListView.ColumnHeaders.Add , "Time", "时 间 段", 1500" 是什么意思
- 如何获得image控件中图片的路径问题
- 讨论vb中能否实现线成
http://community.csdn.net/Expert/topic/4759/4759933.xml?temp=.4990961