7,763
社区成员
发帖
与我相关
我的任务
分享
'数据连接模块
Public MyStrs As String
Public DB_AdoRs As New ADODB.Recordset '后添加一个记录集对象
Public DB_AdoRs1 As New ADODB.Recordset '后添加一个记录集对象
Public DB_AdoRs2 As New ADODB.Recordset '后添加一个记录集对象
Public Function cnn() As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open "Provider=sqloledb;Server=127.0.0.1;Database=DB_CSGL;Uid=sa;Pwd=sa;"
End Function
Public Sub Main()
MyStrs = "Provider=sqloledb;Server=127.0.0.1;Database=DB_CSGL;Uid=sa;Pwd=sa;"
'显示系统登录窗体
frm_xtdl.Show
End Sub
Private Sub Connect_Click()
On Error GoTo showerr
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Provider=sqloledb;Server=" + Text_DataAdr.Text + ";Database=NetExcelSys;Uid=" + Text_UserName.Text + ";Pwd=" + Text_UserPassWord.Text + ";"
conn.Open
MsgBox "连接成功", vbOKOnly + vbInformation, "测试连接"
Form_main.Show
Unload Me
Me.Hide
Exit Sub
showerr:
MsgBox "Error:" & Err.Number & vbCrLf & Err.Description, vbOKOnly, ""
End Sub