Difference Between DataSource and DataSet

Question

I am currently working on a project whose main task is to read the data stored in the SQL database and display it in a user-friendly form. The programming language used is C ++. I work in the environment of Borland C ++ Builder 6. But I think that the question asked in the title does not depend on the programming language or libraries. When reading data from db, I quite often come across these terms in class names, not knowing exactly what they represent. I understand that they behave like an interface to data stored in db. But why do you need to use two interface classes instead of one?

Answer 1

DataSource= How do you connect to your database DataSet= Structure of your database in memory

More information (from Exam 70-516: TS: Data Access Using Microsoft.NET Framework 4):

DataSource This is the main property to which you assign your data. You can assign everything that implements the IList, IListSource, IBindingList or IBindingListView interface. Some examples of elements that can be assigned to the DataSource property are arrays (IList), lists (IList), data tables (IListSource), and datasets (IListSource).

DataSet , . , DataSet , (, , ), . DataSet DataTable DataRelation

Answer 2

, .NET, .

A DataSet - , ( ) - , (, ).

DataSource - - DataSource ( , DataSet) .