我想分成几段来读取。应该怎么解决。
我的代码,应该怎么修改。请大家帮忙。Public Function spare_model() As String '配件型号信息
Dim cn As New ADODB.Connection, Rs As New ADODB.Recordset
cn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;" & _
" Extended Properties='DSN=ascnew_2;SRVR=ascnew1214;DB=master;UID=dba;PWD=nokia&shangsi&asc'"
cn.Open
Rs.CursorLocation = adUseClient
Rs.Open "SELECT T_SPARE_MODEL.c_spare_code,C_spare_name_local,c_spare_name_en,T_SPARE_MODEL.c_phone_model," & _
"c_level_no,c_spare_model,c_warranty FROM T_SPARE_MODEL left join t_spare_part on " & _
"t_spare_model.c_spare_code=t_spare_part.c_spare_code", cn, 3, 1
Dim stra As String
While Not Rs.EOF
stra = stra + Rs.Fields("c_spare_code") + "|" + Rs.Fields("C_spare_name_local") + "|" + _
Rs.Fields("c_spare_name_en") + "|" + Rs.Fields("c_phone_model") + "|" + _
Rs.Fields("c_level_no") + "|" + Rs.Fields("c_spare_model") + "|" + _
Rs.Fields("c_warranty") + "|"
Rs.MoveNext
WendForm1.Label3.Caption = Rs.Fields("c_spare_code").Count
stra = stra & "spare_model" & "|" spare_model = stra
Set Rs = Nothing
Set cn = Nothing
End Function
我的代码,应该怎么修改。请大家帮忙。Public Function spare_model() As String '配件型号信息
Dim cn As New ADODB.Connection, Rs As New ADODB.Recordset
cn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;" & _
" Extended Properties='DSN=ascnew_2;SRVR=ascnew1214;DB=master;UID=dba;PWD=nokia&shangsi&asc'"
cn.Open
Rs.CursorLocation = adUseClient
Rs.Open "SELECT T_SPARE_MODEL.c_spare_code,C_spare_name_local,c_spare_name_en,T_SPARE_MODEL.c_phone_model," & _
"c_level_no,c_spare_model,c_warranty FROM T_SPARE_MODEL left join t_spare_part on " & _
"t_spare_model.c_spare_code=t_spare_part.c_spare_code", cn, 3, 1
Dim stra As String
While Not Rs.EOF
stra = stra + Rs.Fields("c_spare_code") + "|" + Rs.Fields("C_spare_name_local") + "|" + _
Rs.Fields("c_spare_name_en") + "|" + Rs.Fields("c_phone_model") + "|" + _
Rs.Fields("c_level_no") + "|" + Rs.Fields("c_spare_model") + "|" + _
Rs.Fields("c_warranty") + "|"
Rs.MoveNext
WendForm1.Label3.Caption = Rs.Fields("c_spare_code").Count
stra = stra & "spare_model" & "|" spare_model = stra
Set Rs = Nothing
Set cn = Nothing
End Function
strb+=stra
这样试试。
我想过,应该分段来读取。
我使用for循环
for i=0 to 100
stra = stra + Rs.Fields("c_spare_code") + "|" + Rs.Fields("C_spare_name_local") + "|" + _
Rs.Fields("c_spare_name_en") + "|" + Rs.Fields("c_phone_model") + "|" + _
Rs.Fields("c_level_no") + "|" + Rs.Fields("c_spare_model") + "|" + _
Rs.Fields("c_warranty") + "|"
next
这样只是读取第一条数据。
应该怎样修改。
DoEvents
for i=0 to 100
....
doevents
next
rs.fields.count 么。
还有一个问题,那就是我怎么知道是结束的
也就是现在情况下怎么知道数据信息总数。
While Not Rs.EOF
stra = stra + Rs.Fields("c_spare_code") + "|" + Rs.Fields("C_spare_name_local") + "|" + _
Rs.Fields("c_spare_name_en") + "|" + Rs.Fields("c_phone_model") + "|" + _
Rs.Fields("c_level_no") + "|" + Rs.Fields("c_spare_model") + "|" + _
Rs.Fields("c_warranty") + "|"
DoEvents
Rs.MoveNext
Wend
如果大家知道还有别的方法,请告诉我。
stra = stra + Rs.Fields("c_spare_code") + "|" + Rs.Fields("C_spare_name_local") + "|" + _
Rs.Fields("c_spare_name_en") + "|" + Rs.Fields("c_phone_model") + "|" + _
Rs.Fields("c_level_no") + "|" + Rs.Fields("c_spare_model") + "|" + _
Rs.Fields("c_warranty") + "|"
DoEvents
Rs.MoveNext
Wend像这个好像不行。请问你能给我一个可行的代码示例么。
等了好久多没有显示数据
StringBuilder Class for VB
http://www.vbaccelerator.com/home/VB/code/Techniques/StringBuilder/article.asp
你可以每次读1000条呀,10次就行了。
具体要在sql语句中控制。
这就是“分页”