今日写了一个程序,我能连上mssql,能查询,但不能用rdors.addnew 添加数锯,请问那些地方我要改,vb中模块怎么样写,sql中怎么设置。谢谢各位高手,解决问题一定在加分!
环境是vb6.0 and mssql2000,不用odbc连接,直接连到mssql2000上
环境是vb6.0 and mssql2000,不用odbc连接,直接连到mssql2000上
调试欢乐多
rs.AddNew
'修改数据:conn.execute "update tablensemt set ... where ..."
'删除数据:conn.execute "delete from tablename where .."
'删除一个表的所有数据:conn.execute "truncate table tablename"
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.LockType = adLockOptimistic
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=xxx;" CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees where Age>20 ", CN, adOpenDynamic, adLockOptimistic
Rs.addnew
Rs.Fields("col1")="asfds";
Rs.Update
Dim CN As New ADODB.Connection '定义数据库的连接
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=xxx;" CN.Open
'插入数据:
CN.execute "insert into tablename(...) values(...)"'修改数据:
CN.execute "update tablensemt set ... where ..."'删除数据:
CN.execute "delete from tablename where .."CN.close
set CN = nothing