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 FunctionPrivate Sub Command5_Click()
On Error GoTo error1:
Set rs = New Recordset
sql = "update em_m_tree set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
On Error GoTo error1:
Set rs = New Recordset
sql = "update em_e_suite_common set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
Exit Sub
error1:
MsgBox "注意逗号摆放位置" & vbCrLf & "逗号要小写=。=!"
End SubPrivate Sub Form_Load()
data_connection
End Sub主要是Command5控件那一块,SQL语句我得分开写,也不清楚这样写有没有问题,但是执行成功,但如果语句多的话这样就会很麻烦,望高手能给出简单方法。
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 FunctionPrivate Sub Command5_Click()
On Error GoTo error1:
Set rs = New Recordset
sql = "update em_m_tree set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
On Error GoTo error1:
Set rs = New Recordset
sql = "update em_e_suite_common set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
rs.Open sql, CNADO, adOpenStatic
Set DataGrid1.DataSource = rs
Exit Sub
error1:
MsgBox "注意逗号摆放位置" & vbCrLf & "逗号要小写=。=!"
End SubPrivate Sub Form_Load()
data_connection
End Sub主要是Command5控件那一块,SQL语句我得分开写,也不清楚这样写有没有问题,但是执行成功,但如果语句多的话这样就会很麻烦,望高手能给出简单方法。
解决方案 »
- 对MSHFlexGrid 熟悉的进来帮我下
- VB 数组中的所有数据中,我怎样取出相同的记录
- 用winsock进行网络传输,怎样让两台机上的幻灯片播放同步?
- 从一个窗口用数据库做一个用户密码验证保存该用的信息,并在另一个窗口调出来?
- 求vsnetmenu 3.5版本以上的控件及其注册码的下载地址
- 200分求教高手帮助修改邮件发送程序,谢谢!!!
- VB中sql语句的用法?
- 请教各位大侠,如何用程序实现设置IE的安全级别。
- 刚编写的一个拼图的小游戏,大家看看好玩么?(http://eari.51.net/software/pintu.exe 下载)
- 如何将两个datagird中的数据整合到一个datagird中输出(vb6.0中)
- 关于运算符= 的问题
- 我想找个画线控件,咋弄呀,太复杂了,谢谢了求求大家了
如果只是为了执行SQL更新操作的话,可以直接使用 DB.EXECUTE(SQL 语句)
Private Sub Command5_Click()
On Error GoTo error1:
sql = "update em_m_tree set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
CNADO.execute sql
sql = "update em_e_suite_common set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
CNADO.execute sql
Exit Sub
error1:
MsgBox "注意逗号摆放位置" & vbCrLf & "逗号要小写=。=!"
End Sub
On Error GoTo error1:sql = "update em_m_tree set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
cando.execute sql'执行第一个更新查询' Set DataGrid1.DataSource = rs------更新查询是不会返回记录集的,赋值给DataGrid1没有意义
sql = "update em_e_suite_common set isdeleted = 0 where g3e_fid in (" + Text1.Text + ")"
cando.execute sql '执行第二个更新查询 Exit Sub
error1:
MsgBox "注意逗号摆放位置" & vbCrLf & "逗号要小写=。=!"
End Sub