In the previous releases of Visual Studio, it was hard to create a data centric application. Now it is easy in Visual Studio 2008.
Database Server
- Create a Database connection though the Database server item.
Data Source
- Select Menu->Data->Add a Data Source.
- This option will help to connect to the database created above.
- The tables will have datagrid view and detail view.
Windows Form
- Create a Windows Form.
- Drag and drop the Data Grid from the Data Source to the form. This will create a navigational view.
- Drag and drop the Detail View from the Data Source to the forum. This will create a detail view for the record which is navigating.
- You can individually drag and drop fields on the windows form to display only the necessary fields.
The Grid View works with a Dataset, Data Adapter and a Data Connection to manage the data base operations. The Binding Source and Navigator provides the navigation through the dataset.