小弟初学VB,做了个数据采集程序,现在已成功将数据采集回来并在MSFLEXGRID表格中显示,共有十个数据,在ROW=1 to 10,col=1 的一列中显示,现在我想把这些数据保存起来,下次打开时还能在MSFLEXGRID表格中显示,不知道应该怎么做呢?我用CommonDialog1.ShowOpen和CommonDialog1.save调出来WINDOWS风格的文件管理界面,但是不知道该怎么写代码,希望有人能帮我解答这个问题
调试欢乐多
www.bbs.cxrs.net
with hflexgrid
for i=1 to .rows-1
conn.execute "insert into tablename(aa) values('"& .textmatrix(i,0) &"')"
next i
end with
Dim i As Integer
For i = 0 To 13
wd(i) = Val(Trim(Text1(i).Text))
Next i
Dim strpath As String
strpath = App.Path() + "\设置.txt"
Open strpath For Random As #1 Len = Len(wd(0))
For i = 0 To 13
Put #1, , wd(i)
Next i
Close #1
TXT,5樓的就OK了
Private Sub Command2_Click()
Open "d:\aa.txt" For Output As #1
Dim i As Long, j As Long
Dim s As String
With MSFlexGrid1
For i = .Rows - 1 To 1 Step -1
s = ""
For j = 0 To .Cols - 1
s = s & .TextMatrix(i, j) & vbTab
Next
Print #1, s
Next
End With
Close 1
End Sub'从文件读取
Private Sub Form_Load()
Open "d:\aa.txt" For Input As #1
Dim i As Long, j As Long
Dim s As String
Do While Not EOF(1)
Line Input #1, s
MSFlexGrid1.AddItem s, 1
Loop
MSFlexGrid1.RemoveItem MSFlexGrid1.Rows - 1'这一句可有可无,根据实际情况决定
Close 1
End Sub读取后会在多出空行,根据实际情况removeitem即可