Explain the difference between an ADO.NET Dataset and an ADO Recordset.
The two main basic differences between recordset and dataset are as shown below :-
1) With the dataset you can retrieve data from two databases such as oracle and sql server and combine them in one dataset , with the recordset this is not possible
2) All the representation of Dataset is by using XML while the recordset uses COM.
3) The Recordset cannot be transmitted on the HTTP while Dataset can be.