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

---+ Virtuoso ADO.Net Data Grid Form Application

%TOC%

---++ Introduction

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

---++ Pre-requisites

   1 Microsoft Visual Studio 2008 SP1, which includes the ADO.NET Entity Framework runtime and associated tools
   1 A running Virtuoso Universal Server instance

---++ Steps

   1 Launch the Visual Studio 2008 SP1 IDE.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp1.png" style="wikiautogen"/>%BR%%BR%
   1 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%
   1 When the New Project window appears, choose either <b>Visual Basic</b> or <b>Visual 
C#</b> as the programming language.%BR%%BR% 
   1 Within the language category, click on <b>Windows</b> and select <b>Windows Form 
Application</b> from the right-hand panel. %BR%%BR%
   1 Choose a name for the project, for example <b><nop>VirtuosoDataGridApp</b>, and 
click <b>OK</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp1_1.png" style="wikiautogen"/>%BR%%BR%
   1 From the <b>Data</b>, menu select the <b>Show Data Sources</b> menu item to display 
a list of available Data sources.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp2.png" style="wikiautogen"/>%BR%%BR%
   1 Click on the <b>Add New Data Source</b> link to add a new data source.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp3.png" style="wikiautogen"/>%BR%%BR%
   1 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%/VirtAdoNetDataGridApp4.png" style="wikiautogen"/>%BR%%BR%
   1 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%/VirtAdoNetDataGridApp5.png" style="wikiautogen"/>%BR%%BR%
   1 In the <b>Choose Data Source</b> dialog, select <b><nop>OpenLink Virtuoso Data Source</b> 
from the list and click <b>Continue</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp6.png" style="wikiautogen"/>%BR%%BR%
   1 In the <b>Add Connection</b> dialog, specify the <b>hostname</b>, <b>portno</b>, 
<b>username</b>, and <b>password</b> for the target Virtuoso Server and and check the 
<b>Save Password</b> check box.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp7.png" style="wikiautogen"/>%BR%%BR%
   1 Select the <b>Select Database From List</b> radio button and choose <b>Demo</b> from 
the drop down list, assuming the Virtuoso Demo Database is installed.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp8.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <b>Test Connection</b> button to verify the connection is successful and 
then click <b>OK</b> to add the connection.%BR%
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp9.png" style="wikiautogen"/>%BR%%BR%
   1 Select the <b> Yes, include sensitive data in the connect string</b> radio button 
and click <b>Next</b> to continue.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp11.png" style="wikiautogen"/>%BR%%BR%
   1 In the <b>Choose your Database Objects</b> dialog select the table and columns to 
be queried, the shippers table is used in this example.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp12.png" style="wikiautogen"/>%BR%%BR%
   1 A <b><nop>DataSet</b> for the shippers database object is created
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp13.png" style="wikiautogen"/>%BR%%BR%
   1 From the drop down list box next to the <b>Shippers</b> table ensure the 
<b><nowiki>DataGridView</nowiki></b> item is selected
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp13_1.png" style="wikiautogen"/>%BR%%BR%
   1 Drag the <b>Shippers</b> <nop>DataSet item onto the <b>Form</b> to create a scrollable 
and editable association of the Shippers table object with the Data Grid View automatically.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp14.png" style="wikiautogen"/>%BR%%BR%
   1 From the <b>Debug</b> Menu select the <b>Start Debugging</b> menu item to run 
the application.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp15.png" style="wikiautogen"/>%BR%%BR%
   1 The data in the Shippers table will be displayed in the <nowiki>DataGrid</nowiki> 
application created.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp16.png" style="wikiautogen"/>%BR%%BR%
   1 A new row can be inserted (updated or deleted) as indicated  for the new DHL record 
inserted below and the <b> save</b> button clicked to save the change to the database.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp17.png" style="wikiautogen"/>%BR%%BR%
   1 The Virtuoso <b>Interactive SQL</b> tab of the Conductor can be used to run the query 
<b><code>select * from Demo..Shippers</code></b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp18.png" style="wikiautogen"/>%BR%%BR%
   1 To verify the change has been successfully made in the database.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataGridApp19.png" style="wikiautogen"/>%BR%%BR%

The task is now complete.