给你几个参考代码吧 写文本: Private Sub Command1_Click() CommonDialog1.Filter = "*.txt 文件|*.txt" CommonDialog1.ShowSave Open CommonDialog1.FileName For Output As #1 Print #1, Text1.Text Close #1 End Sub读文本: Private Sub Command2_Click() Text1.Text = "" CommonDialog1.Filter = "*.txt 文件|*.txt" CommonDialog1.ShowOpen Open CommonDialog1.FileName For Input As #1 Do While Not EOF(1) ' 循环至文件尾。 Line Input #1, TextLine ' 读入一行数据并将其赋予某变量。 Text1.Text = Text1.Text & TextLine & vbCrLf Loop Close #1 End Sub
2楼在抛砖引玉: 将连接字串放在.txt文件中,然后读取 可根据需求修改一下: EX: c:\strconn.txt 内容连接ACCESS字串为:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist SecuritInfo=Falseload code: Open "c:\strconn.txt" For Input As #1 Do While Not EOF(1) Line Input #1, strconn strconn = strconn & strconn Loop Close #1 Conn.ConnectionString = strconn conn.open ----未测试
Set con = New Connection con.CursorLocation = adUseClient Open App.Path & "\config.ini" For Input As #1 Do While Not EOF(1) Line Input #1, strconn strconns = strconns & strconn Loop Close #1 Conn.ConnectionString = strconns Conn.Open读取出来的字符串是对的怎么提示错误 要求对象实例?
都很简单
搜索“INI文件的读写”或“文本文件的读写”代码一车一地
写文本:
Private Sub Command1_Click()
CommonDialog1.Filter = "*.txt 文件|*.txt"
CommonDialog1.ShowSave
Open CommonDialog1.FileName For Output As #1
Print #1, Text1.Text
Close #1
End Sub读文本:
Private Sub Command2_Click()
Text1.Text = ""
CommonDialog1.Filter = "*.txt 文件|*.txt"
CommonDialog1.ShowOpen
Open CommonDialog1.FileName For Input As #1
Do While Not EOF(1) ' 循环至文件尾。
Line Input #1, TextLine ' 读入一行数据并将其赋予某变量。
Text1.Text = Text1.Text & TextLine & vbCrLf
Loop
Close #1
End Sub
一般可以放到INI文件也可以放到XML文件里,当然还可放到你希望的其他文件中。
将连接字串放在.txt文件中,然后读取
可根据需求修改一下:
EX:
c:\strconn.txt 内容连接ACCESS字串为:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist SecuritInfo=Falseload code:
Open "c:\strconn.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, strconn
strconn = strconn & strconn
Loop
Close #1
Conn.ConnectionString = strconn
conn.open
----未测试
免费的资源,自己下来看看吧
con.CursorLocation = adUseClient
Open App.Path & "\config.ini" For Input As #1
Do While Not EOF(1)
Line Input #1, strconn
strconns = strconns & strconn
Loop
Close #1
Conn.ConnectionString = strconns
Conn.Open读取出来的字符串是对的怎么提示错误
要求对象实例?
[DataSourceSet]
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\db1.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123456"这样写怎么不对