那你就应在BeforeConnectOuterDataSource 写代码,而且你的[系统连接]必须是模式窗口
Dim server As String
Dim mima As String
server = GetConfigValue("fwq", nothing)
mima = GetConfigValue("mm", nothing)
Dim s As String ="Provider=SQLOLEDB.1;Password=" & mima &";Persist Security Info=True;User ID=sa;Initial Catalog=mf;Data Source=" & server
If Connections.TryConnect(s) = False Then
MessageBox.Show("数据源无法连通!","提示")
Forms("系统连接").show '这个窗口,必须是 模式窗口
'重新得到能成功的值,设置连接
server = GetConfigValue("fwq", nothing)
mima = GetConfigValue("mm", nothing)
s = Provider=SQLOLEDB.1;Password=" & mima &";Persist Security Info=True;User ID=sa;Initial Catalog=mf;Data Source=" & server
e.ConnectionString = s
Else
e.ConnectionString = s
MessageBox.Show("数据源连通!","提示")
End If
你应该写在窗口里的代码,大致这样
Dim server As String = ""
Dim mima As String = ""
server=Forms("系统连接").Controls("TextBox1").text
mima=Forms("系统连接").Controls("TextBox2").text
SaveConfigValue("fwq",server)
SaveConfigValue("mm", mima)