怎样修改记录集里的内容?急急急,在线等前辈们帮忙!!!

[accpt25]

Set temp = New Connection
Set temppub = New Recordset
temp.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=xiaocao;Data Source=."
temp.Execute "select * from dp"
temppub.Open "dp", temp, adOpenDynamic, 3
下面该怎么写啊?
我晕了......

[accpt25]

晕死,自己解决了,呵呵!

[winehero]

Set temp = New Connection
Set temppub = New Recordset
temp.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=xiaocao;Data Source=."
temp.Execute "select * from dp"
temppub.Open "dp", temp, adOpenDynamic, 3
下面该怎么写啊?
我晕了......
___________________________________________________________________________

if temppub.eof or temppub.bof then exit sub
'修改第一条记录：
temppub.movefirst
temppub.fields(0)=... '修改第一个字段
temppub.fields(1)=... '修改第二个字段
。。。。。。

temppub.update '更新数据
temppub.close
temp.close