%META:TOPICPARENT{name="VirtIngresEntityFrameworkUsage"}%

===Visual Studio Windows <nop>DataGrid Form Application===

This article details the steps required to create a simple Visual Studio 2008 Windows Form application, with associated <nop>DataGridView control for displaying data in selected tables from the target database.

1. Launch the Visual Studio 2008 SP1 IDE.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp01.png" style="wikiautogen"/>%BR%%BR%
   
2. Create a <b>Web Application</b> project by going to the <b>File</b> menu in Visual Studio and choosing <b>New Project</b>. %BR%%BR%
   
3. When the New Project window appears, choose either <b>Visual Basic</b> or <b>Visual C#</b> as your programming language.%BR%%BR% 
   
4. Within the language category click on <b>Windows</b> and select <b>Windows Form Application</b> from the right-hand panel. %BR%%BR%
   
5. Choose a name for the project, for example <b><nop>VirtWindowsFormApplication</b>, and click <b>OK</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp02.png" style="wikiautogen"/>%BR%%BR%
   
6. In the <b>Toolbox</b>, expand <b>Data</b> Controls and drag the <b><nop>DataGridView</b> control onto the form.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp03.png" style="wikiautogen"/>%BR%%BR%
   
7. Click on the little <b>arrow</b> on the top right of the <b><nop>DataGridView</b> control to load the <b><nop>DataGridView Task</b> menu.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp04.png" style="wikiautogen"/>%BR%%BR%
   
8. Click on the <b>Choose Data Source</b> list box.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp05.png" style="wikiautogen"/>%BR%%BR%
   
9. Click on the <b>Add Project Data Source</b> link to connect to a data source.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp06.png" style="wikiautogen"/>%BR%%BR%
   
10. In the <b>Data Source Configuration Wizard</b> dialog <b>Choose Data Source Type</b> page, select the <b>Database</b> data source type and click <b>Next</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp07.png" style="wikiautogen"/>%BR%%BR%
   
11. In the <b>Data Source Configuration Wizard</b> dialog <b>Choose your Data Connection</b> page, select the <b>New Connection</b> button.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp08.png" style="wikiautogen"/>%BR%%BR%
   
12. In the <b>Choose Data Source</b> dialog, select the <b><nop>OpenLink Virtuoso Data Source</b> from the list and click <b>Continue</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp10.png" style="wikiautogen"/>%BR%%BR%
   
13. In the <b>Connection Properties</b> dialog specify the <b>hostname</b>, <b>portno</b>, <b>username</b>, and password for the target Virtuoso Server and click the <b>Advanced</b> button.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp09.png" style="wikiautogen"/>%BR%%BR%
   
14. In the <b>Advanced Properties</b> dialog, set the <b>Database</b> parameter to <b>TUT</b> and click **OK**.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp12.png" style="wikiautogen"/>%BR%%BR%
   
15. Press the <b>Test Connection</b> dialog to verify the database is accessible.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp11.png" style="wikiautogen"/>%BR%%BR%
   
16. Leave the name of the connect string to the default of <b><nop>TUTConnectionString</b> and click <b>Next</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp13.png" style="wikiautogen"/>%BR%%BR%
   
17. From the list of available tables returned for the TUT database, select the <b>cust_orders</b> table to be associated with the <b><nop>DataGridView</b> control.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp14.png" style="wikiautogen"/>%BR%%BR%
   
18. The column names of the select table will be displayed in the the <nop>DataGridView.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp15.png" style="wikiautogen"/>%BR%%BR%
   
19. Resize the Form and <nop>DataGridView to allow all columns to be visible if possible.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp17.png" style="wikiautogen"/>%BR%%BR%
   
20. To test the application, simply hit <b>Ctrl+F5</b> within Visual Studio or select  <b>Start Debugging</b> from the <b>Debug</b> menu.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp16.png" style="wikiautogen"/>%BR%%BR%
   
21. The data from the <b>cust_orders</b> table will be displayed in the <b><nop>DataGrid</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtIngDataGridApp18.png" style="wikiautogen"/>%BR%%BR%

The task is now complete.