1,216
社区成员
发帖
与我相关
我的任务
分享
Public CNADO As New ADODB.Connection
Public rs As New ADODB.Recordset
Public rs1 As New ADODB.Recordset
Dim sql As String
Dim connect As String
Function data_connection() As Boolean
On Error GoTo dataconnectionerr
Set CNADO = New ADODB.Connection
CNADO.Provider = "MSDAORA"
CNADO.ConnectionTimeout = 10
CNADO.CursorLocation = adUseClient
CNADO.Open "DATA SOURCE=diy;", "system", "1"
'CNADO.Open "DATA SOURCE=数据库;", "账号", "密码"
date_connection = True
Exit Function
dataconnectionerr:
MsgBox Err.Description
Data_Connect = False
End Function
Private Sub Command1_Click()
Call Command2_Click
End Sub
Private Sub Command2_Click()
On Error GoTo error1:
Set rs = New Recordset
sql = "" + Text1.Text + ""
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
Exit Sub
error1:
MsgBox "no table"
End Sub
Private Sub Form_Load()
data_connection
End Sub
Private Sub Form_Load()
data_connection
End Sub
Public CNADO As New ADODB.Connection
Public rs As New ADODB.Recordset
Public rs1 As New ADODB.Recordset
Dim sql As String
Dim connect As String
Function data_connection() As Boolean
On Error GoTo dataconnectionerr
Set CNADO = New ADODB.Connection
CNADO.Provider = "MSDAORA"
CNADO.ConnectionTimeout = 10
CNADO.CursorLocation = adUseClient
CNADO.Open "DATA SOURCE=diy;", "system", "1"
date_connection = True
Exit Function
dataconnectionerr:
MsgBox Err.Description
Data_Connect = False
End Function
Private Sub Command1_Click()
On Error GoTo error1:
Set rs = New Recordset
sql = "update yong_a set b=1 where a ="+test1.text+""
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
Exit Sub
error1:
MsgBox "no table"
End Sub