代码如下
Private Sub cmdRefresh_Click()
Dim obj As Object, i%
With Instrument_Store.rsStockData
If .RecordCount > 0 Then
If .Status = adRecModified Then .CancelUpdate
.Requery '刷新记录集
For i = 0 To 12 '重新执行数据绑定
Set txtStock(i).DataSource = Instrument_Store
txtStock(i).DataMember = "StockData"
Next
txtStock(0).DataField = "编号"
txtStock(1).DataField = "类型"
txtStock(2).DataField = "地址"
txtStock(3).DataField = "数量"
txtStock(4).DataField = "单位"
txtStock(5).DataField = "供应商"
txtStock(6).DataField = "经办人"
txtStock(7).DataField = "备注"
txtStock(8).DataField = "最大量"
txtStock(9).DataField = "最小量"
txtStock(10).DataField = "入库时间"
txtStock(11).DataField = "出库时间"
txtStock(12).DataField = "有效期"
End If
End With
Instrument_Store.rsStockInfo.Requery
Set dgShowInInfo.DataSource = Instrument_Store
dgShowInInfo.DataMember = "InInfo"
Set dgShowOutInfo.DataSource = Instrument_Store
dgShowOutInfo.DataMember = "OutInfo"
cmdSave.Enabled = True
picNavigation.Enabled = True
cmdMove(0) = True
End Sub
提示If .RecordCount > 0 Then为出错字段
我在网上找了找相关资料还是没有解决,特来求解答,谢了VB对象
Private Sub cmdRefresh_Click()
Dim obj As Object, i%
With Instrument_Store.rsStockData
If .RecordCount > 0 Then
If .Status = adRecModified Then .CancelUpdate
.Requery '刷新记录集
For i = 0 To 12 '重新执行数据绑定
Set txtStock(i).DataSource = Instrument_Store
txtStock(i).DataMember = "StockData"
Next
txtStock(0).DataField = "编号"
txtStock(1).DataField = "类型"
txtStock(2).DataField = "地址"
txtStock(3).DataField = "数量"
txtStock(4).DataField = "单位"
txtStock(5).DataField = "供应商"
txtStock(6).DataField = "经办人"
txtStock(7).DataField = "备注"
txtStock(8).DataField = "最大量"
txtStock(9).DataField = "最小量"
txtStock(10).DataField = "入库时间"
txtStock(11).DataField = "出库时间"
txtStock(12).DataField = "有效期"
End If
End With
Instrument_Store.rsStockInfo.Requery
Set dgShowInInfo.DataSource = Instrument_Store
dgShowInInfo.DataMember = "InInfo"
Set dgShowOutInfo.DataSource = Instrument_Store
dgShowOutInfo.DataMember = "OutInfo"
cmdSave.Enabled = True
picNavigation.Enabled = True
cmdMove(0) = True
End Sub
提示If .RecordCount > 0 Then为出错字段
我在网上找了找相关资料还是没有解决,特来求解答,谢了VB对象
解决方案 »
- 显示为 .016 实际要显示为 0.016
- VB打开excel文件,出现只读,不知何故??
- 在客户端页面的DLL组件,如何获得所在页面的Document对象?
- MSChart组件生成的饼图,如何在适当的区域显示百分比的值? 在线等!!!
- 【调查帖】除了编程,你还有什么后手可以成为谋生手段?
- 公布水晶报表9的一段源码,大家帮忙看一下,急,急,急。。。。。。
- vb如何读取条码扫描器的数据啊 ?急急急急急急急
- VB是解释型语言,为什么不能跨平台??
- 服务器,客户端。《给满分》
- 请问在ADO中如何更新,也就是达到控件中Refresh方法的效果。
- 急需帮忙,怎么实现关键字搜索并统计
- 一个关于二进制 模2加的算法 想要求教,算法详细在内容里
Instrument_Store.rsStockData.open '?不知道你的Instrument_Store是什么对象,是否可以这样打开
Private Sub cmdRefresh_Click()
Dim i%
With Instrument_Store.rsInInfo
If .RecordCount > 0 Then
If isAdding Then .CancelUpdate '取消未保存的新添加记录
.Requery '刷新记录集
For i = 0 To 5 '重新执行数据绑定
Set txtInInfo(i).DataSource = Instrument_Store
txtInInfo(i).DataMember = "InInfo"
Next
txtInInfo(0).DataField = "编号"
txtInInfo(1).DataField = "名称"
txtInInfo(2).DataField = "地址"
txtInInfo(3).DataField = "供应商"
txtInInfo(4).DataField = "入库时间"
txtInInfo(5).DataField = "备注"
End If
End With
cmdAdd.Enabled = True
cmdDelete.Enabled = True
isAdding = False
picNavigation.Enabled = True
cmdMove(0).Value = True
End Sub
打开就可以了,你不是有运行顺利的代码了么。照葫芦画瓢就成了Instrument_Store.rsStockData连接成功了没有?