目的是想在界面的文本框Me.result1,Me.result2,Me.result3里显示saveTEMP.xls中某些字段的值
-------------------------------------------------------------------------------
Private Sub Command1_Click(Index As Integer)
Dim adoConn As New ADODB.Connection
Dim adoRS As New ADODB.RecordsetDim strA As String
Dim strB As String
Dim strC As StringadooConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\saveTEMP.xls;" & _
"Extended Properties=""Excel 8.0;"""
adoRS.Open "Select * from [Sheet1$]", adoConn, adOpenStatic
adoRS.MoveFirst
adoRS.RecordCount = 1
adoRS("B") = Me.result1
adoRS("D") = Me.result2
adoRS("F") = Me.result3
Set adoRS = Nothing
End Sub
--------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Private Sub Command1_Click(Index As Integer)
Dim adoConn As New ADODB.Connection
Dim adoRS As New ADODB.RecordsetDim strA As String
Dim strB As String
Dim strC As StringadooConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\saveTEMP.xls;" & _
"Extended Properties=""Excel 8.0;"""
adoRS.Open "Select * from [Sheet1$]", adoConn, adOpenStatic
adoRS.MoveFirst
adoRS.RecordCount = 1
adoRS("B") = Me.result1
adoRS("D") = Me.result2
adoRS("F") = Me.result3
Set adoRS = Nothing
End Sub
--------------------------------------------------------------------------------
解决方案 »
- DHTMLEdit控件表格内字体的颜色
- 求一个access库sql语句
- 用VB如何实现画一幅图,其中有曲线、园、椭圆、黑色方块,该图还能在autocad中打开和编辑线。
- 我用vb6+sql server 2000(MSDE)编程,为什么非要用“信任 SQL Server 连接”呢?若在企业管理器中改成“使用 SQL Server 身份验证”,数据库又附加不上。
- access问题,打印报表和数据库操作的数据环境怎么设置,(需要设置两个数据环境么),另
- 《400击》很好看
- 如何将anscii互相转化unicode
- Bitblt()的参数的是什么意思
- 求助,VB串行通讯时,timer控件的代码。
- vb6中使用水晶報表10
- 求助:如何把内容加在文本的后面
- 如何替换EXCEL中指定某列的内容?
adoRS.MoveFirst
adoRS.move 10
adoRS("B") = Me.result1
adoRS("D") = Me.result2
adoRS("F") = Me.result3既然是把数据显示到窗体的控件上,应该这样赋值:Me.result1=adoRS("B") & ""
Me.result2=adoRS("D") & ""
Me.result3=adoRS("F") & ""
Dim adoConn As New ADODB.Connection
Dim adoRS As New ADODB.RecordsetDim i As Integer
Dim strA As String
Dim strB As String
Dim strC As StringadoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\saveTEMP.xls;" & _
"Extended Properties=""Excel 8.0;"""
adoRS.Open "Select * from [Sheet1$]", oConn, adOpenStatic
adoRS.MoveFirstFor i = 1 To adoRS.RecordCount
adoRS("B") = Me.result1
adoRS("D") = Me.result2
adoRS("F") = Me.result3
adoRS.Update
adoRS.MoveNext
Next i
Set adoRS = Nothing
End Sub
-----------------------------
compile error:
User-defined type not defined
-----------------------------
在adoRs指向最后一条记录后再adoRS.MoveNext
那样不就是错了,