Private Sub cmdTouroku_Click()
Dim strSql As String 'insert into SYAIN values('10002','aaaaaa','男','2003/01/01','000- 000','aa','bb','cc','dd','ee','2003/01/01','2003/01/01','2003/01/01','2003/01/01')
strSql = "Update SYAIN set seimei='qqqqqq' where syainid='10001'"
Execute strSql
End Sub
Dim strSql As String 'insert into SYAIN values('10002','aaaaaa','男','2003/01/01','000- 000','aa','bb','cc','dd','ee','2003/01/01','2003/01/01','2003/01/01','2003/01/01')
strSql = "Update SYAIN set seimei='qqqqqq' where syainid='10001'"
Execute strSql
End Sub
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=sqloledb.1;user id=sa;password=密码;Initial Catalog=数据库;Data Source="
objrs.Open "select filename from xiazaijilu ", objcon, 3, 1
Set Datagrid1.RowSource = objrs'While Not objrs.EOF
'list1.additem objrs.fields(0)
'wend
adocnn.open connectstringDim strSql As String 'insert into SYAIN values('10002','aaaaaa','男','2003/01/01','000- 000','aa','bb','cc','dd','ee','2003/01/01','2003/01/01','2003/01/01','2003/01/01')
strSql = "Update SYAIN set seimei='qqqqqq' where syainid='10001'"
adoCnn.Execute strSqladoCnn.close
set adoCnn = nothing
或者使用adodb.connecton.Execute方法
Dim DBSession As Object
Dim DBDatabase As Object
Dim recSet As Object
Dim DBName As String
Dim DBUID As String
Dim DBPWD As String
Dim strSql As String
DBName = "gld"
DBUID = "gld01"
DBPWD = "gld01"
Set DBSession = CreateObject("OracleInProcServer.XOraSession")
Set DBDatabase = DBSession.OpenDatabase(DBName, DBUID & "/" & DBPWD, 0&)没用ado 的情况 怎样执行
dim sSql as string
sSql = "INSERT INTO ........"
db.execute sSql
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
strSql = "Update SYAIN set seimei='qqqqqq' where syainid='10001'"
CN.Execute strSql