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.

PrefixNamespace IRI
n31http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp13.
n9http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp9.
n34http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp4.
n18http://rdfs.org/sioc/services#
n26http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp13_1.
dchttp://purl.org/dc/elements/1.1/
n28http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp14.
n25http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp16.
n8http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp8.
n10http://vos.openlinksw.com/dataspace/owiki#
n4http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dctermshttp://purl.org/dc/terms/
n17http://vos.openlinksw.com/dataspace/services/wiki/
n24http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp15.
rdfshttp://www.w3.org/2000/01/rdf-schema#
n22http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp17.
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
atomhttp://atomowl.org/ontologies/atomrdf#
n12http://vos.openlinksw.com/dataspace/dav#
xsdhhttp://www.w3.org/2001/XMLSchema#
n37http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp3.
n23http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp18.
siochttp://rdfs.org/sioc/ns#
n13http://vos.openlinksw.com/dataspace/person/owiki#
n33http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp7.
n38http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp19.
n36http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp2.
oplhttp://www.openlinksw.com/schema/attribution#
n5http://vos.openlinksw.com/dataspace/person/dav#
n32http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp6.
n21http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp1.
n20http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp11.
foafhttp://xmlns.com/foaf/0.1/
n35http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp5.
n19http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp10.
n30http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp12.
siocthttp://rdfs.org/sioc/types#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/
n16http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtAdoNetDataGridApp/sioc.
n39http://vos.openlinksw.com/wiki/main/VOS/VirtAdoNetDataGridApp/VirtAdoNetDataGridApp1_1.
Subject Item
n5:this
foaf:made
n4:VirtAdoNetDataGridApp
Subject Item
n12:this
sioc:creator_of
n4:VirtAdoNetDataGridApp
Subject Item
n17:item
n18:services_of
n4:VirtAdoNetDataGridApp
Subject Item
n10: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
n13:this n5:this
dc:title
VirtAdoNetDataGridApp
opl:isDescribedUsing
n16:rdf
sioc:has_creator
n10:this n12:this
sioc:attachment
n8:png n9:png n19:png n20:png n21:png n22:png n23:png n24:png n25:png n26:png n28:png n30:png n31:png n32:png n33:png n34:png n35:png n36:png n37:png n38:png n39: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
n18:has_services
n17: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