我有个表myxc记录有很多内容,如何实现按Command2时就逐条显示在对应的TextBox上,如表中有个pic_dis字段,要显示在Text1.Text上,如下的代码中Set adoRs = adoConn.Execute( ,adCmdText)如何写?
Private Sub Command2_Click()
Dim adoRs As ADODB.Recordset
On Error Resume Next
Screen.MousePointer = vbHourglass
DoEvents
Set adoRs = adoConn.Execute(? ,adCmdText)
If adoRs.EOF Then Exit Sub
adoRs.MoveNext
Text1.Text = adoRs!pic_dis
End Sub
Private Sub Command2_Click()
Dim adoRs As ADODB.Recordset
On Error Resume Next
Screen.MousePointer = vbHourglass
DoEvents
Set adoRs = adoConn.Execute(? ,adCmdText)
If adoRs.EOF Then Exit Sub
adoRs.MoveNext
Text1.Text = adoRs!pic_dis
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货