Search code examples
c#databasevisual-studiodatasetbindingsource

C# (Visual studio): Correlation between database, dataset, binding source

I am just learning C# through Visual Studio 2008?

I was wondering what exactly is the correlation between dabases, datasets and binding sources?

As well, what is the function of the table adapter?

Solution

  • At a super high level:

    • Database -- stores raw data

    • DataSet -- a .NET object that can be used to read, insert, update and delete data in a database

    • BindingSource -- a .NET object that can be used for Data Binding for a control. The BindingSource could point to a DataSet, in which case the control would display and edit that data

    • TableAdapter -- Maps data from a database table into a DataSet

    There is a lot more to all of these, and understanding the way ADO.NET is architected can take a bit of time. Good luck!