There can be several approaches taken for validating data. For our example we are going to use Customers table of Northwind database. Open its smart tag and choose "Configure Data Source" option to start Configure Data Source wizard.
On the first step of the wizard click on "New Connection" button to open a dialog as shown in Figure 1.
A common design pattern in business applications is to separate the presentation layer, business logic layer and the data access layer.
The data access layer encapsulates the underlying SQL statements for data manipulation.
In my code I tend to write the databinding logic as part of the page logic which usually is just a couple of lines of code.
I don't know about you, but I cringe every time I need to create a Grid View based layout that needs to create a few custom link handlers off that grid.
The typical scenario might be a list where you can toggle certain options or where you can fire an operation that otherwise updates the data that's underlying the grid.
You can implement the components of this layer using strongly typed Data Set.
The business logic layer enables specifying business entities, business rules and workflow associated to the underlying logic of your business.