<docbook><section><title>VirtSYBVisualStudioDataGridFormsApp</title><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Visual Studio Windows DataGrid Form Application</bridgehead>
<para>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.</para>
<orderedlist spacing="compact"><listitem>Launch the Visual Studio 2008 SP1 IDE.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp01.png" /></figure> </listitem>
<listitem>Create a <emphasis>Web Application</emphasis> project by going to the <emphasis>File</emphasis> menu in Visual Studio and choosing <emphasis>New Project</emphasis>.
  </listitem>
<listitem>When the New Project window appears, choose either <emphasis>Visual Basic</emphasis> or <emphasis>Visual C#</emphasis> as your programming language. </listitem>
<listitem>Within the language category, click on <emphasis>Windows</emphasis> and select <emphasis>Windows Form Application</emphasis> from the right-hand panel.
  </listitem>
<listitem>Choose a name for the project, for example <emphasis>VirtWindowsFormApplication</emphasis>, and click <emphasis>OK</emphasis>.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp02.png" /></figure> </listitem>
<listitem>In the <emphasis>Toolbox</emphasis>, expand <emphasis>Data</emphasis> Controls and drag the <emphasis>DataGridView</emphasis> control onto the form.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp03.png" /></figure> </listitem>
<listitem>Click on the little <emphasis>arrow</emphasis> in the top right of the <emphasis>DataGridView</emphasis> control to load the <emphasis>DataGridView Task</emphasis> menu.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp04.png" /></figure> </listitem>
<listitem>Click on the <emphasis>Choose Data Source</emphasis> list box.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp05.png" /></figure> </listitem>
<listitem>Click on the <emphasis>Add Project Data Source</emphasis> link to connect to a data source.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp06.png" /></figure> </listitem>
<listitem>In the <emphasis>Data Source Configuration Wizard</emphasis> dialog <emphasis>Choose Data Source Type</emphasis> page, select the <emphasis>Database</emphasis> data source type and click <emphasis>Next</emphasis>.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp07.png" /></figure> </listitem>
<listitem>In the <emphasis>Data Source Configuration Wizard</emphasis> dialog <emphasis>Choose your Data Connection</emphasis> page, select the <emphasis>New Connection</emphasis> button.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp08.png" /></figure> </listitem>
<listitem>In the <emphasis>Choose Data Source</emphasis> dialog, select the <emphasis>OpenLink Virtuoso Data Source</emphasis> from the list and click <emphasis>Continue</emphasis>.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp09.png" /></figure> </listitem>
<listitem>In the <emphasis>Add Connection</emphasis> dialog, specify the <emphasis>hostname</emphasis>, <emphasis>portno</emphasis>, <emphasis>username</emphasis>, and <emphasis>password</emphasis> for the target Virtuoso Server and and check the <emphasis>Save Password</emphasis> check box.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtDataGridApp10.png" /></figure> </listitem>
<listitem>Select the <emphasis>Select Database From List</emphasis> radio button and choose the <emphasis>P2</emphasis> database from the drop down list.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGrid1.png" /></figure> </listitem>
<listitem>Press the <emphasis>Test Connection</emphasis> dialog to verify that the database is accessible.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGrid2.png" /></figure> </listitem>
<listitem>Leave the default connect string name--<emphasis>P2ConnectionString</emphasis>--and click <emphasis>Next</emphasis>.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGrid3.png" /></figure> </listitem>
<listitem>From the list of available tables returned for the P2 database, select the <emphasis>authors</emphasis> table to be associated with the <emphasis>DataGridView</emphasis> control.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGridApp4.png" /></figure> </listitem>
<listitem>The column names of the select table will be displayed in the the DataGridView.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGridApp5.png" /></figure> </listitem>
<listitem>Resize the form and DataGridView to allow all columns to be visible if possible.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGridApp6.png" /></figure> </listitem>
<listitem>To test the application, simply hit <emphasis>Ctrl+F5</emphasis> within Visual Studio or select <emphasis>Start Debugging</emphasis> from the <emphasis>Debug</emphasis> menu.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGridApp7.png" /></figure> </listitem>
<listitem>The data from the <emphasis>authors</emphasis> table will be displayed in the <emphasis>DataGrid</emphasis>.
<figure><graphic fileref="VirtSYBVisualStudioDataGridFormsApp/VirtSYBDataGridApp8.png" /></figure></listitem>
</orderedlist><para>The task is now complete.
</para>
</section></docbook>