开发者

what is the dao equivalent to inserting and editing records in c# .net?

开发者 https://www.devze.com 2023-04-04 08:13 出处:网络
I was wondering if there is an equivalent to the DAO style insert and update record code in C#. For instance, in access VBA, I could do an insert with something like this:

I was wondering if there is an equivalent to the DAO style insert and update record code in C#. For instance, in access VBA, I could do an insert with something like this:

dim db As DAO.Database
dim rs As DAO.Recordset

Set db = CurrentDatabase
Set rs = db.OpenRecordset("tableName")

With rs
     .add
     .Fields("column1") = Textbox.Value
     .update
End With

Is there something similar in C# .ne开发者_如何学Pythont?? i know how to do it with parameterized queries, but for what I'm doing, it seems like the old DAO way would be quicker.


Since VB.Net and C# .Net share the same framework... .Net it's pretty easy. It's going to look something like:

DAO.Database db = CurrentDatabase(); 
DAO.Recordset rs = db.OpenRecordset("tableName");

rs.add();
rs.Fields["column1"] = Textbox.Value ;
rs.update();
0

精彩评论

暂无评论...
验证码 换一张
取 消