菜菜问题

Question

rs.Open "select * from arcemployee", de1.conn1, adOpenDynamic, adLockOptimistic
rs.AddNew
rs.Fields("name1") = Text1.Text我怎样才能将数据添加入数据库啊？？？？本人刚开始学习，所以有诸多问题不懂。。忘各位高手们海涵！！！！

Answer 1

rs.Open "select * from arcemployee", de1.conn1, adOpenDynamic, adLockBatchOptimistic
rs.AddNew
rs.Fields("name1") = Text1.Text
rscompany.UpdateBatch

Answer 2

rs.Open "select * from arcemployee", de1.conn1, adOpenDynamic, adLockOptimistic
rs.AddNew
rs.Fields("name1") = Text1.Text
rs.Update'向数据库提交更新