63: What are the different data adapter events used for responding to the changes made to the data source?
Answer:
The data adapter events used for responding to the events are as mentioned below:
a) RowUpdating: The event is raised before the row is updated from the DataSet and is processed at the source. The event is used for changing the behavior before the update functionality is performed and also provides additional event handling. User can cancel the modification and reschedule the data. The RowUpdatingEventArgs arguments passed to the event contain Row property, command property, and a Statement Type property.
b) RowUpdated: The event is raised after DML operations are performed on the row. It is used for handling the exceptions and errors that occur in an update. The ContinueUpdateOnError property is used for handling the error for the updated rows.
64: List the namespaces used for data access.
Answer:
Following are the namespaces used for data access:
a) System.Data
b) System.Data.Common
c) System.Data.Odbc
d) System.Data.Oledb
e) System.Data.ProviderBase
f) System.Data.Oracle
g) System.Data.Sql
h) System.Data.SqlClient
i) System.Data.Sqltypes
65: List out the classes available in System.Data namespace.
Answer:
The following are the shared classes available under the System.Data namespace:
a) DataSet
b) DataTable
c) DataRow
d) DataColumn
e) DataRelation
f) Constraint
66: List out the Data Specific classes available in C.
Answer:
a) SqlCommand, OracleCommand, OleDbCommand and ODBCCommand are used for executing Sql statements or Stored Procedures
b) SqlConnection, OracleConnection, OleDbConnection and ODBCConnection are used to connect to the database
c) SqlDataReader, OracleDataReader, OleDbDataReader and ODBCDataReader are used as forward only data reader
d) SqlCommanBuilder, OracleCommanBuilder, OleDbCommanBuilder, ODBCCommanBuilder are used to generate SQL statements
e) SqlParameter, OleDbParameter, OracleParameter, ODBCParameter are used to define parameter to stored procedures