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.

Subject Item

n24:this

foaf:made

n2:VirtFirebirdVisualStudioDataGridFormsApp

Subject Item

n23:this

sioc:creator_of

n2:VirtFirebirdVisualStudioDataGridFormsApp

Subject Item

n26:item

n25:services_of

n2:VirtFirebirdVisualStudioDataGridFormsApp

Subject Item

n11:this

sioc:creator_of

n2:VirtFirebirdVisualStudioDataGridFormsApp

Subject Item

n6:VOS

sioc:container_of

n2:VirtFirebirdVisualStudioDataGridFormsApp

atom:entry

n2:VirtFirebirdVisualStudioDataGridFormsApp

atom:contains

n2:VirtFirebirdVisualStudioDataGridFormsApp

Subject Item

n2:VirtFirebirdVisualStudioDataGridFormsApp

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:37:51.674048

dcterms:modified

2017-06-29T07:37:24.387342

rdfs:label

VirtFirebirdVisualStudioDataGridFormsApp

foaf:maker

n24:this n28:this

dc:title

VirtFirebirdVisualStudioDataGridFormsApp

opl:isDescribedUsing

n16:rdf

sioc:has_creator

n11:this n23:this

sioc:attachment

n4:png n9:png n10:png n13:png n14:png n17:png n18:png n19:png n20:png n21:png n22:png n31:png n32:png n33:png n34:png n35:png n36:png n37:png n38:png n39:png

sioc:content

%META:TOPICPARENT{name="VirtFirebirdEntityFrameworkUsage"}% ---++ Virtuoso ADO.Net Data Grid Form Application 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. 1 Launch the Visual Studio 2008 SP1 IDE. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_01.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>. 1 When the New Project window appears, choose either <b>Visual Basic</b> or <b>Visual C#</b> as the programming language. 1 Within the language category, click on <b>Windows</b> and select <b>Windows Form Application</b> from the right-hand panel. 1 Choose a name for the project, for example <b><nop>VirtuosoDataGridApp</b>, and click <b>OK</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_02.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%/VirtFirebirdDataGrid_03.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%/VirtFirebirdDataGrid_04.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%/VirtFirebirdDataGrid_05.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Data Source Configuration Wizard</b> dialog <b>Choose your Data Connection page</b>, select the <b>New Connection button</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_06.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%/VirtFirebirdDataGrid_07.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%/VirtFirebirdDataGrid_08.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Select Database From List</b> radio button and choose <b>employee</b> from the drop down list, assuming the Virtuoso Demo Database is installed. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_09.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%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_10.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%/VirtFirebirdDataGrid_11.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Choose your Database Objects</b> dialog select the table and columns to be queried, the <b>COUNTRY</b> table is used in this example. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_12.png" style="wikiautogen"/>%BR%%BR% 1 A DataSet for the <b>employee</b> database object is created %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_13.png" style="wikiautogen"/>%BR%%BR% 1 From the drop down list box next to the <b>COUNTRY</b> table ensure the <b><nop>DataGridView</b> item is selected %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_14.png" style="wikiautogen"/>%BR%%BR% 1 Drag the <b>COUNTRY</b> DataSet item onto the <b>Form</b> to create a scrollable and editable association of the <b>COUNTRY</b> table object with the Data Grid View automatically. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_15.png" style="wikiautogen"/>%BR%%BR% 1 From the <b>Debug Menu</b> select the <b>Start Debugging</b> menu item to run the application. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_16.png" style="wikiautogen"/>%BR%%BR% 1 The data in the <b>COUNTRY</b> table will be displayed in the <nop>DataGrid application created. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_17.png" style="wikiautogen"/>%BR%%BR% 1 A new row can be inserted (updated or deleted) as indicated for the new "1111" record inserted below and the <b>Save</b> button clicked to save the change to the database. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_18.png" style="wikiautogen"/>%BR%%BR% 1 The Virtuoso <b>Interactive SQL</b> tab of the Conductor can be used to run the query <b>select * from "employee"."fire"."COUNTRY"</b> %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_19.png" style="wikiautogen"/>%BR%%BR% 1 To verify the change has been successfully made in the database. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdDataGrid_20.png" style="wikiautogen"/>%BR%%BR% The task is now complete.

sioc:id

ca2e6582c1d4408a09b18601bb0dcab0

sioc:link

n2:VirtFirebirdVisualStudioDataGridFormsApp

sioc:has_container

n6:VOS

n25:has_services

n26:item

atom:title

VirtFirebirdVisualStudioDataGridFormsApp

sioc:links_to

n7:DataSet n7:DataGridView

atom:source

n6:VOS

atom:author

n24:this

atom:published

2017-06-13T05:37:51Z

atom:updated

2017-06-29T07:37:24Z

sioc:topic

n6:VOS