[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2560
  • Last Modified:

When you want to insert, update, or delete a record from a database, which ADO object would you use to accomplish this?

When you want to insert, update, or delete a record from a database, which ADO object would you use to accomplish this? (ADOCommand, ADORecordSet, ADODataReader or ADOUpdater)
      
0
mabtahi
Asked:
mabtahi
1 Solution
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I would use the ADOCommand.  You really do not expect a result so this would allow you to just execute a command.
0
 
Anthony PerkinsCommented:
>>ADOCommand, ADORecordSet, ADODataReader or ADOUpdater<<
You seem to have mixed up ADO with ADO.NET, can you clarify which one you are asking about?
0
 
cmwhiteCommented:
.NET:
 For Select statements (Obviously a return expected) you would use OleDbDataReader, SqlDataReader
 For Update, Insert, Delete statements you would use OleDbCommand, SqlCommand

ADO:
For Select Statements you would use the database connection's execute method and use ADODB.recordset object to hold the returned data.
For update, insert, delete statements you would just use the db connection's execute method.

Hope this helps,

Chris
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now