Set DataGrid1.DataSource = rs1 不灵呢 应该怎么写?在线等 解决就马上结具体代码下面
Dim rs As ADODB.Recordset
Dim rs1 As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim cnn As ADODB.ConnectionPrivate Sub CommandSCE1_Click()
Set rs1 = New ADODB.Recordset
Set DataGrid1.DataSource = rs1
rs1.Open "select * from rkd", cnn, adOpenKeyset, adLockOptimisticPrint rs1.Fields!品名
End SubPrivate Sub Form_Load()Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=nkc.mdb"End Sub
Dim rs As ADODB.Recordset
Dim rs1 As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim cnn As ADODB.ConnectionPrivate Sub CommandSCE1_Click()
Set rs1 = New ADODB.Recordset
Set DataGrid1.DataSource = rs1
rs1.Open "select * from rkd", cnn, adOpenKeyset, adLockOptimisticPrint rs1.Fields!品名
End SubPrivate Sub Form_Load()Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=nkc.mdb"End Sub
解决方案 »
- 谁知道 OLE_XSIZE_HIMETRIC 和 OLE_YSIZE_HIMETRIC 这两个类型么?MSDN中没有,网上也没找到,知道得朋友帮个忙,谢谢啦!!!!
- 请问怎么用VB实现对某个文件夹设置访问密码??
- 关于data report 问题。
- 怎么显示有修改的内容,没有变的内容不显示.
- 如何去掉所有的注释?
- 错在哪????请大侠帮我看看这段代码!在线等待!
- ADO:多表连接查询(JOIN)时,用UpdateBatch更新数据,Unique Table如何设置?
- 急!!!宏代码的问题。
- 一个小小查询问题,非常简单
- vb6如何操作已经打开的excel,而并不重新打开再操作
- 请教计时器问题?
- TreeView有checkbox 当父节点选择框选中 子节点将全部选中 代码怎么写的?
Set rs1 = New ADODB.Recordset
rs1.CursorLocation = adUseClient
rs1.Open "select * from rkd", cnn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rs1
Print rs1.Fields!品名
End Sub
请问这句话什么意思|
Set DataGrid1.DataSource = rs1调换一下顺序,先打开记录集,再绑定。
dim rs as new adodb.recordset
cn.open "连接字符串"
rs.open "select * from tablename",cn,1,1