Dim adoConn As New ADODB.Connection
Dim adoComm As New ADODB.Command
Dim adoRes As New ADODB.Recordset
Private Form_Load()
adoConn.Open "......." 'Insert Dsn
Set adoComm = adoConn
adoComm.CommandText = "Select * from ......."
adoRes.CursorLocation = adUseClient
adoRes.Open adoComm, , adOpenStatic, adLockBatchOptimistic
'To update New Records..
adoRes.Addnew
.
.
.
adores.UpdateBatch
End Sub好好看看书。
MSDN
Dim adoComm As New ADODB.Command
Dim adoRes As New ADODB.Recordset
Private Form_Load()
adoConn.Open "......." 'Insert Dsn
Set adoComm = adoConn
adoComm.CommandText = "Select * from ......."
adoRes.CursorLocation = adUseClient
adoRes.Open adoComm, , adOpenStatic, adLockBatchOptimistic
'To update New Records..
adoRes.Addnew
.
.
.
adores.UpdateBatch
End Sub好好看看书。
MSDN
解决方案 »
- FlexCell.Grid 不是一个已加载的控件类。
- 数据库更新时出现错误:有时正确有时出现错误。这是怎么回事?该如何解决呢?
- shape,line,image三个基本控件在哪个文件中定义
- 为什么Active控件不能创建。
- 请问各位大侠,在开发调用Word处理数据的时候,经常出现"部件忙"的错误?我该如何克服?
- 问一个VB简单问题 我用commondialog控件 打开文件时,怎样才能只显示没有后缀名的文件 谢谢
- 哪能搞到中文的vb帮助?
- 有关Vtxauto.tlb朗读功能??
- 比较复杂的字符读取,挑战你自己!
- 有一具问题,最近一直在做网络传送文件的这个软件。有一个大问题,关于如何获得局域网中的广播地址有没有什么函数可以实现呢
- 做共享软件的朋友:请问国内有哪些信用度较高的共享软件代理网站或代理商?在线等待...
- VB编程中ADO的Command对象的Execute方法的参数如何传递.
Dim adoComm As New ADODB.Command
Dim adoRes As New ADODB.Recordset
Private Form_Load()
adoConn.Open "......." 'Insert Dsn
Set adoComma.ActionConnection = adoConn
adoComm.CommandText = "Select * from ......."
adoRes=adoComm.Exceute
adores.UpdateBatch
End Sub
DSNLess Use ODBCPrivate Function ConnectSQLServer(ByVal ServerName As String, ByVal DataBase As String, ByVal UID As String, ByVal PWD As String, ByVal Timeout As Integer) As Boolean
Dim strConnect As String
On Error GoTo Error_ConnectServer
cn.CursorLocation = adUseClient
strConnect = "Driver={SQL Server};Server=" & ServerName & ";DataBase=" & DataBase & ";UID=" & UID & ";PWD=" & PWD & ";"
cn.ConnectionString = strConnect
cn.ConnectionTimeout = Timeout
cn.Open
ConnectSQLServer = True
Exit Function
Error_ConnectServer:
ConnectSQLServer = FalseEnd Function