ADO.NET INTERVIEW QUESTION & ANSWERS
| 76. |
What is a DataTable? |
| |
A DataTable is a class in .NET Framework and in simple words a DataTable object represents a table from a database. |
| 77. |
How to generate XML from a dataset and vice versa? |
| |
We can use WriteXml () and ReadXml () methods of DataSet Object. |
| 78. |
What are the two main types of classes associated with errors that are thrown by ADO.NET classes? |
| |
Objects of type SqlError and OleDbError arc thrown by the ADO.NET classes. |
| 79. |
What method is used by the Command classes to execute SQL statements that return single values? |
| |
The Execute Scalar method executes SQL commands that return single values. |
| 80. |
What two classes are used to read data only? |
| |
Use the SqlDataReader and OldDbDataReader classes to read data in a forward direction only. |
