VB对数据库进行操作。想把要访问的数据库的路径写到记事本中,这样VB每次访问数据库时先读记事本中数据库中的路径,然后去访问这个路径下的数据库。这样可以随时改变数据库的路径。请问怎么做啊?最好能有个简单的实例。在这里先谢过了。
解决方案 »
- 初學,VB怎么調用TLB文件中的屬性方法
- VB做出的记事本,为什么发到其它机子就打不开?
- 如何用VB实现双缓冲处理图片的闪烁问题?
- 关于VB中调EXCEL
- treeview中,当鼠标指向某个节点时,如果节点文本较长时,会有提示文本,但是很奇怪会刷新的速度特别快。看上去像是一闪一闪的,请问如何
- 用datagrid控件修改数据库,如果某项定义为数字,输入为字符,就弹出:多步操作产生错误。请检查每一步状态,我如何捉到这个错误,让它显
- 这玩意有人见过吗?好像是查询网络中sql server数据库的,散分!
- 文本的字体变化?
- 如何准备中级程序员考试(送分)
- 怎么样能得到datagrid中的某一条纪录(通过鼠标双击这条纪录)
- vb中 lsitview 统计总共有多少行记录
- 关于inet控件提交问题,请指导
Open "d:\记事本" For Output As #1
Print #1, Text1
Close 链接数据库....
appPath = "d:\trans\"
'读取ini文件,获取参数
Dim FileTxt As String, StrArray() As String, iNum As Integer, i As Integer
FileTxt = String(FileLen(appPath & "trans.ini"), " ")
iNum = FreeFile()
Open appPath & "trans.ini" For Binary As iNum
FileTxt = Input(LOF(iNum), iNum)
Close iNum
FileTxt = Replace(FileTxt, vbCrLf, "")
TxtArray = Split(FileTxt, ";")
iNum = UBound(TxtArray)
If iNum > 1 Then
'读取目标数据库参数
StrArray = Split(TxtArray(0), ",")
local_ip = Split(StrArray(0), "=")(1)
local_user = Split(StrArray(1), "=")(1)
local_pwd = Split(StrArray(2), "=")(1)
local_db = Split(StrArray(3), "=")(1)
'读取远程数据库参数
For i = 1 To iNum - 1
StrArray = Split(TxtArray(i), ",")
List1.AddItem Split(StrArray(0), "=")(1)
List1.ItemData(List1.NewIndex) = Val(Split(StrArray(1), "=")(1))
Next
End If
Print #1, Text1
Close
FileLineToArr "d:\10.txt", MyArr() '文件行到数组
Public Function FileLineToArr(FileName As String, MyArr() As String) As Boolean
Dim MyArrIndex As Long, FNumber As Integer
ReDim MyArr(0 To 120000) As String
FNumber = FreeFile()
Open FileName For Input As #FNumber
While Not EOF(1)
Line Input #FNumber, MyArr(MyArrIndex)
MyArrIndex = MyArrIndex + 1
Wend
Close #FNumber
If MyArrIndex > 0 Then
ReDim Preserve MyArr(0 To MyArrIndex - 1) As String
FileLineToArr = True
Else
ReDim MyArr(0 To 0) As String
End If
End Function
【TXT_PATH:你要写入的记事本的合法路径;DB_PATH :字符串变量,即你的数据库路径】myfile=FreeFile
Open TXT_PATH For Output As #myfile
Print #myfile, DB_PATH
Close #myfile