Creating a Database CRUD application in .net

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

  1. Create a Database connection though the Database server item.

Data Source

  1. Select Menu->Data->Add a Data Source.
  2. This option will help to connect to the database created above.
  3. The tables will have datagrid view and detail view.

Windows Form

  1. Create a Windows Form.
  2. Drag and drop the Data Grid from the Data Source to the form. This will create a navigational view.
  3. 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.
  4. 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.

Leave a Reply

You must be logged in to post a comment.