2.6.Virtuoso ADO.Net Data Grid Form Application

This section details the steps required to create a simple Visual Studio 2008 Windows Form application with associated DataGridView control for displaying data in selected tables from a Virtuoso database.

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure2.75.Visual Studio

    Visual Studio

  2. Create a Web Application project by going to the File menu in Visual Studio and choosing New Project.

  3. When the New Project window appears, choose either Visual Basic or Visual C# as the programming language.

  4. Within the language category, click on Windows and select Windows Form Application from the right-hand panel.

  5. Choose a name for the project, for example VirtuosoDataGridApp, and click OK.

    Figure2.76.name for the project

    name for the project

  6. From the Data, menu select the Show Data Sources menu item to display a list of available Data sources.

    Figure2.77.Show Data Sources

    Show Data Sources

  7. Click on the Add New Data Source link to add a new data source.

    Figure2.78.Add New Data Source

    Add New Data Source

  8. In the Data Source Configuration Wizard dialog Choose Data Source Type page, select the Database data source type and click Next.

    Figure2.79.Data Source Configuration Wizard

    Data Source Configuration Wizard

  9. In the Data Source Configuration Wizard dialog Choose your Data Connection page, select the New Connection button.

    Figure2.80.Data Connection page

    Data Connection page

  10. In the Choose Data Source dialog, select OpenLink Virtuoso Data Source from the list and click Continue.

    Figure2.81.OpenLink Virtuoso Data Source

    OpenLink Virtuoso Data Source

  11. In the Add Connection dialog, specify the hostname, portno, username, and password for the target Virtuoso Server and check the Save Password check box.

    Figure2.82.Add Connection dialog

    Add Connection dialog

  12. Select the Select Database From List radio button and choose School from the drop down list of available databases.

    Figure2.83.Select Database From List

    Select Database From List

  13. Click the Test Connection button to verify the connection is successful and then click OK to add the connection.

    Figure2.84.Test Connection

    Test Connection

  14. Select the Yes, include sensitive data in the connect string radio button and click Next to continue.

    Figure2.85.connect string

    connect string

  15. In the Choose your Database Objects dialog select the table and columns to be queried, the shippers table is used in this example.

    Figure2.86.Choose your Database Objects

    Choose your Database Objects

  16. A DataSet for the shippers database object is created

    Figure2.87.shippers database

    shippers database

  17. From the drop down list box next to the Shippers table ensure the DataGridView item is selected

    Figure2.88.DataGridView

    DataGridView

  18. Drag the Shippers DataSet item onto the Form to create a scrollable and editable association of the Shippers table object with the Data Grid View automatically.

    Figure2.89.Drag

    Drag

  19. From the Debug Menu select the Start Debugging menu item to run the application.

    Figure2.90.Debug

    Debug

  20. The data in the Shippers table will be displayed in the DataGrid application created.

    Figure2.91.DataGrid

    DataGrid

  21. A new row can be inserted (updated or deleted) as indicated for the new DHL record inserted below and the save button clicked to save the change to the database.

    Figure2.92.new row

    new row

  22. The Virtuoso Interactive SQL tab of the Conductor can be used to run the query select * from Demo..Shippers.

    Figure2.93.Interactive SQL tab

    Interactive SQL tab

  23. To verify the change has been successfully made in the database.

    Figure2.94.verify

    verify

The task is now complete.