Data Form Wizard

The Data Form Wizard is the easiest and fastest way to develop database applications without writing a single line of code. We will see the Data Form Wizard in action and work with a table from the sample Books database. Before you start, create a new database in Access and name it as Books. Create a table, Table1 in Books, add some fields to the table, enter some values in Table1 and close the Access database. To start working with the Data Form Wizard select Project->Add New Item->Data Form Wizard from the main menu. The dialogue box for that looks like the image below.
 

Select Data Form Wizard, type a name for it and click Open. Once you click open, a new dialog opens up which is the Data Form wizard and it looks like the image below.

Click Next on this dialog box. Clicking next takes you to a new dialog box which looks like the image below. Here you need to specify the name for your DataSet.

Select the radio button which display "create new dataset named", type a name for the DataSet, and click next. Clicking next opens a dialog box like the image below.

Here we need to establish a connection to the database. Click on the "New Connection" button which opens up the "Data Link Properties" dialog. Set a connection to the database in the Data Link properties dialog. Here, I am using an Access Books database, you can use any database you wish to work with. Once you finish with the Connection click next. Clicking next takes you to a new dialog box like the image below.

This dialog box displays all the tables available in your Books database. Select the table you want to work with and add it using the forward arrow button. I am selecting Table1 from my sample books database. Click next once you are finished. The next dialog box looks like the image below.

This dialog box allows us to display columns from more than one table by establishing a master-detail relationship and providing a name for that relation. A master-detail relationship can only be established if you have a common column in both the tables. Since we are working with one table, click next on this dialog box. Clicking next takes to a dialog like the image below.

This dialog allows you to select the columns you want to display. Select the columns you wish to display and click finish. That finishes configuring the Data Form Wizard. You will notice a Load button and the columns you selected being added to the Web Forms designer. Run the DataWebForm and click the load button. The data will be dsiplayed on the Web page.