This HTML5 document contains 51 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

PrefixIRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n16http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n4http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n11http://vos.openlinksw.com/dataspace/dav#
n8http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/
rdfshttp://www.w3.org/2000/01/rdf-schema#
n17http://rdfs.org/sioc/services#
n15http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtAdoNetDataGridApp/
siocthttp://rdfs.org/sioc/types#
n5http://vos.openlinksw.com/dataspace/person/dav#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n9http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n12http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#

Statements

Subject Item
n5:this
foaf:made
n4:VirtAdoNetDataGridApp
Subject Item
n11:this
sioc:creator_of
n4:VirtAdoNetDataGridApp
Subject Item
n16:item
n17:services_of
n4:VirtAdoNetDataGridApp
Subject Item
n9:this
sioc:creator_of
n4:VirtAdoNetDataGridApp
Subject Item
n2:VOS
sioc:container_of
n4:VirtAdoNetDataGridApp
atom:entry
n4:VirtAdoNetDataGridApp
atom:contains
n4:VirtAdoNetDataGridApp
Subject Item
n4:VirtSPASQLSilverLightApp
sioc:links_to
n4:VirtAdoNetDataGridApp
Subject Item
n4:VirtAdoNetDataGridApp
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:40:24.357843
dcterms:modified
2017-06-29T07:35:57.869452
rdfs:label
VirtAdoNetDataGridApp
foaf:maker
n12:this n5:this
dc:title
VirtAdoNetDataGridApp
opl:isDescribedUsing
n15:sioc.rdf
sioc:has_creator
n9:this n11:this
sioc:attachment
n8:VirtAdoNetDataGridApp8.png n8:VirtAdoNetDataGridApp9.png n8:VirtAdoNetDataGridApp10.png n8:VirtAdoNetDataGridApp11.png n8:VirtAdoNetDataGridApp1.png n8:VirtAdoNetDataGridApp17.png n8:VirtAdoNetDataGridApp18.png n8:VirtAdoNetDataGridApp15.png n8:VirtAdoNetDataGridApp16.png n8:VirtAdoNetDataGridApp13_1.png n8:VirtAdoNetDataGridApp14.png n8:VirtAdoNetDataGridApp12.png n8:VirtAdoNetDataGridApp13.png n8:VirtAdoNetDataGridApp6.png n8:VirtAdoNetDataGridApp7.png n8:VirtAdoNetDataGridApp4.png n8:VirtAdoNetDataGridApp5.png n8:VirtAdoNetDataGridApp2.png n8:VirtAdoNetDataGridApp3.png n8:VirtAdoNetDataGridApp19.png n8:VirtAdoNetDataGridApp1_1.png
sioc:content
%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.
sioc:id
58c44a170610171f4eace09927eda3ef
sioc:link
n4:VirtAdoNetDataGridApp
sioc:has_container
n2:VOS
n17:has_services
n16:item
atom:title
VirtAdoNetDataGridApp
atom:source
n2:VOS
atom:author
n5:this
atom:published
2017-06-13T05:40:24Z
atom:updated
2017-06-29T07:35:57Z
sioc:topic
n2:VOS