sqlstr = "driver={SQL SERVER};server=LYHSERVER;uid=sa;pwd=sa;connectiontimeout=0;database=yong2"
'打开表头
Adodc_header_general.ConnectionString = sqlstr
Adodc_header_general.CommandType = adCmdUnknown
Adodc_header_general.RecordSource = "select VB02.* from VB02 WITH (NOLOCK) order by vb0201,vb0202,vb0203"
Adodc_header_general.Refresh
'打开表身
Adodc_body_general.ConnectionString = sqlstr
Adodc_body_general.CommandType = adCmdUnknown
Adodc_body_general.RecordSource = "select top 1 VB03.* from VB03 with (nolock)"
Adodc_body_general.Refresh
when_the_header_repositionPrivate Sub when_the_header_reposition()
If Adodc_header_general.Recordset.eof = False Then
Adodc_body_general.ConnectionString = sqlstr
Adodc_body_general.CommandType = adCmdUnknown
'Adodc_body_general.RecordSource = "select VB03.* from VB03 with (nolock) where VB03.VB0301='" & Adodc_header_general.Recordset.Fields("VB0201").Value & "' and VB03.VB0302='" & Adodc_header_general.Recordset.Fields("VB0202").Value & "' and VB03.VB0303='" & Adodc_header_general.Recordset.Fields("VB0203").Value & "'"
Adodc_body_general.RecordSource = "select VB03.* from VB03 with (nolock) where VB03.VB0301='" & Adodc_header_general.Recordset.Fields("VB0201").Value & "' and VB03.VB0303='" & Adodc_header_general.Recordset.Fields("VB0203").Value & "'"
Adodc_body_general.Refresh
End If
End Sub
为什么到最后一个Adodc_body_general.Refresh时总是时通过时不通过呢?是不是VB6 BUG问题?
'打开表头
Adodc_header_general.ConnectionString = sqlstr
Adodc_header_general.CommandType = adCmdUnknown
Adodc_header_general.RecordSource = "select VB02.* from VB02 WITH (NOLOCK) order by vb0201,vb0202,vb0203"
Adodc_header_general.Refresh
'打开表身
Adodc_body_general.ConnectionString = sqlstr
Adodc_body_general.CommandType = adCmdUnknown
Adodc_body_general.RecordSource = "select top 1 VB03.* from VB03 with (nolock)"
Adodc_body_general.Refresh
when_the_header_repositionPrivate Sub when_the_header_reposition()
If Adodc_header_general.Recordset.eof = False Then
Adodc_body_general.ConnectionString = sqlstr
Adodc_body_general.CommandType = adCmdUnknown
'Adodc_body_general.RecordSource = "select VB03.* from VB03 with (nolock) where VB03.VB0301='" & Adodc_header_general.Recordset.Fields("VB0201").Value & "' and VB03.VB0302='" & Adodc_header_general.Recordset.Fields("VB0202").Value & "' and VB03.VB0303='" & Adodc_header_general.Recordset.Fields("VB0203").Value & "'"
Adodc_body_general.RecordSource = "select VB03.* from VB03 with (nolock) where VB03.VB0301='" & Adodc_header_general.Recordset.Fields("VB0201").Value & "' and VB03.VB0303='" & Adodc_header_general.Recordset.Fields("VB0203").Value & "'"
Adodc_body_general.Refresh
End If
End Sub
为什么到最后一个Adodc_body_general.Refresh时总是时通过时不通过呢?是不是VB6 BUG问题?
解决方案 »
- 大家帮帮忙,解释一下VB程序
- 关于VB界面构造的问题
- 多步OLEDB操作产生错误 --是什么原因造成的?怎样解决?急在线等
- Remote Desktop 管理不了我的远程服务器了!!急,急,急!
- davidlv (断刀客)大侠请接分:我要那个c/s系统的代码。
- 求助高人一个关于HOOK的问题.....................................
- DBGrid内单元格内显示的数据能够更新操作吗?
- 如何用winsock实现局域网中的广播地址发送文件
- 请问怎么样能把表格数据转换成VB代码的数据,进行公式运算?
- AdamBear(学习再学习) Amoon(阿木)來領分吧!idoloveyou(我18岁,成人了!) AdamBear(学习再学习) Amoon(阿木) Richard2001(Richard)已經
- 关于VB代码check in到Visual Source Safe的问题.
- controls集合
Set DataGrid1.DataSource = Nothing