There two main basic differences between record set and dataset: -
• With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with record set this is not possible.
• All representation of Dataset is using XML while record set uses COM.
• Record set cannot be transmitted on HTTP while Dataset can be.
Asked In: Many Interviews |