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

c# database visual-studio dataset bindingsource
Northener picture Northener · Feb 28, 2009 · Viewed 9.8k times · 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?

Answer

Guy Starbuck picture Guy Starbuck · Feb 28, 2009

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!

Related questions

How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?

Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the DB and adds a published date. I want to keep the exact time but still be …

Read More
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
Unable to cast object of type 'System.DBNull' to type 'System.String`

I got the above error in my app. Here is the original code public string GetCustomerNumber(Guid id) { string accountNumber = (string)DBSqlHelperFactory.ExecuteScalar(connectionStringSplendidmyApp, CommandType.StoredProcedure, "GetCustomerNumber", new SqlParameter("@id", id)); return accountNumber.ToString(); } I replaced with public string GetCustomerNumber(…

Read More