mod1.bas

来自「是一款专业的销售管理软件」· BAS 代码 · 共 21 行

Attribute VB_Name = "Mod1"
Public adoCon As New ADODB.Connection      '定义一个数据连接
Public adoRs As New ADODB.Recordset        '定义一个数据集对象
Public adoRs1 As New ADODB.Recordset       '定义一个数据集对象

Public bQx(1 To 24) As Boolean             '权限


Public Name1 As String
Public StrNums As Integer
Public Temps    '定义一个变体类型的公共变量
'声明一个API函数，用于实现使窗体置前还是取消窗体置前的功能
Public Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal X As Long, ByVal Y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
Public rtn
Public CnnStr As String

Public Sub Main()            '定义一个公共主函数，用于连接数据库
    CnnStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db_SPJXC;Data Source=."
    adoCon.Open (CnnStr)
End Sub