Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

QuestPond’s Interview Questions & Answers on dataset in ADO.NET

What is difference between Dataset.Clone and Dataset.Copy?

Clone: - It only copies structure, does not copy data.

Copy: - Copies both structure and data.

Can you explain the difference between an ADO.NET Dataset and an ADO Record set?

There two main basic differences between record set and dataset:-
  • With dataset you can 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.

See following video on Dataset is a disconnect while datareader is connected: -

Click and see here for more training on ADO.NET.

Helpful Website Url
Share this article   |    Print    |    Article read by 2378 times
Shivprasad koirala Koirala
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small E-learning company in India. We are very much active in making training videos , writing books and corporate trainings. Do visit my site for .NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Related Articles:
Related Interview Questions: