Public Function sql(ByVal sqlstring As String) As ADODB.Recordset
Dim conn As New ADODB.Connection
Dim AuthConnectionString As String
Dim rs1 As New ADODB.Recordset
Set conn = CreateObject("ADODB.Connection")
AuthConnectionString = "Provider=Sqloledb; User ID=sa; Password=ll; Initial Catalog =house; Data Source=(local)"
conn.ConnectionString = AuthConnectionString
conn.Open
rs1.Open sqlstring, conn, adOpenStatic, adLockReadOnly, adCmdText
Set sql = rs1
End Function
Dim conn As New ADODB.Connection
Dim AuthConnectionString As String
Dim rs1 As New ADODB.Recordset
Set conn = CreateObject("ADODB.Connection")
AuthConnectionString = "Provider=Sqloledb; User ID=sa; Password=ll; Initial Catalog =house; Data Source=(local)"
conn.ConnectionString = AuthConnectionString
conn.Open
rs1.Open sqlstring, conn, adOpenStatic, adLockReadOnly, adCmdText
Set sql = rs1
End Function
Dim conn As New ADODB.Connection'类实例化
Dim AuthConnectionString As String'连接字符串
Dim rs1 As New ADODB.Recordset
Set conn = CreateObject("ADODB.Connection")'创建连接对象
AuthConnectionString = "Provider=Sqloledb; User ID=sa; Password=ll; Initial Catalog =house; Data Source=(local)"'设置连接字符串
conn.ConnectionString = AuthConnectionString
conn.Open
rs1.Open sqlstring, conn, adOpenStatic, adLockReadOnly, adCmdText'打开记录集
Set sql = rs1'赋值给SQL
End Function
Dim conn As New ADODB.Connection'类实例化
Dim AuthConnectionString As String'连接字符串Set conn = CreateObject("ADODB.Connection")'创建连接对象
AuthConnectionString = "Provider=Sqloledb; User ID=sa; Password=ll; Initial Catalog =house; Data Source=(local)"'设置连接字符串
conn.ConnectionString = AuthConnectionString上边这些应该是不放在这个函数中的。设计一个类 创建连接 执行SQL返回 关闭连接 这才是一个通用的,你上边的这么一段,每执行一个SQL 就 创建一次连接,麻烦....速度还慢...