VOS.VirtMySQLVisualStudioDataGridFormsApp

Visual Studio Windows DataGrid Form Application

This article 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 the target database.

1. Launch the Visual Studio 2008 SP1 IDE.
   
   
   
   
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 your 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 VirtWindowsFormApplication, and click OK.
   
   
   
   
6. In the Toolbox, expand Data Controls and drag the DataGridView control onto the form.
   
   
   
   
7. Click on the little arrow in the top right of the DataGridView control to load the DataGridView Task menu.
   
   
   
   
8. Click on the Choose Data Source list box.
   
   
   
   
9. Click on the Add Project Data Source link to connect to a data source.
   
   
   
   
10. In the Data Source Configuration Wizard dialog Choose Data Source Type page, select the Database data source type and click Next.
    
    
    
    
11. In the Data Source Configuration Wizard dialog Choose your Data Connection page, select the New Connection button.
    
    
    
    
12. In the Choose Data Source dialog, select the OpenLink Virtuoso Data Source from the list and click Continue.
    
    
    
    
13. In the Add Connection dialog, specify the hostname, portno, username, and password for the target Virtuoso Server and and check the Save Password check box.
    
    
    
    
14. Select the Select Database From List radio button and choose the mysql database from the drop down list.
    
    
    
    
15. Press the Test Connection dialog to verify the database is accessible.
    
    
    
    
16. Click OK to add the connection.
    
    
    
    
    
17. Leave the default connect string name--mysqlConnectionString--and click Next.
    
    
    
    
18. From the list of available tables returned for the mysql database, select the Shippers table to be associated with the DataGridView control.
    
    
    
    
19. The column names of the select table will be displayed in the the DataGridView.
    
    
    
    
20. Resize the form and DataGridView to allow all columns to be visible if possible.
    
    
    
    
21. To test the application, simply hit Ctrl+F5 within Visual Studio or select Start Debugging from the Debug menu.
    
    
    
    
22. The data from the Shippers table will be displayed in the DataGrid.
    
    
    
    

The task is now complete.