mabtahi
asked on
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
.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
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
You seem to have mixed up ADO with ADO.NET, can you clarify which one you are asking about?