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

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

Subject Item

n32:this

foaf:made

n2:VirtOJDBCVisualStudioDataGridFormsApp

Subject Item

n93:this

sioc:creator_of

n2:VirtOJDBCVisualStudioDataGridFormsApp

Subject Item

n64:item

n63:services_of

n2:VirtOJDBCVisualStudioDataGridFormsApp

Subject Item

n26:this

sioc:creator_of

n2:VirtOJDBCVisualStudioDataGridFormsApp

Subject Item

n16:VOS

sioc:container_of

n2:VirtOJDBCVisualStudioDataGridFormsApp

atom:entry

n2:VirtOJDBCVisualStudioDataGridFormsApp

atom:contains

n2:VirtOJDBCVisualStudioDataGridFormsApp

Subject Item

n2:VirtOJDBCVisualStudioDataGridFormsApp

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:46:27.668750

dcterms:modified

2017-06-29T07:39:01.411450

rdfs:label

VirtOJDBCVisualStudioDataGridFormsApp

foaf:maker

n23:this n32:this

dc:title

VirtOJDBCVisualStudioDataGridFormsApp

opl:isDescribedUsing

n13:rdf

sioc:has_creator

n26:this n93:this

sioc:attachment

n4:png n6:DS_Store n7:XN8SfJ n8:JY6gTw n10:3hZcBp n11:6VbxO1 n14:mJLgjp n15:XaqXFm n17:5v7jrv n18:A8uI7T n19:png n20:DS_Store n21:Qxrudc n24:png n25:png n27:png n28:png n29:png n30:png n31:png n33:png n34:png n35:png n36:DS_Store n37:png n38:DS_Store n39:png n40:png n41:png n42:png n43:png n44:png n45:png n46:png n47:png n48:png n50:png n51:png n52:7Eb7vH n53:LoI1SZ n54:png n55:png n56:ePlUCj n57:xO0E8S n58:png n59:png n60:png n61:h9Sn2M n62:png n65:png n66:png n67:png n69:png n70:png n71:png n72:png n73:png n74:png n75:png n76:png n77:feiWrR n78:png n79:png n80:png n81:png n82:cigNZI n83:png n84:dIsurT n85:png n86:ClZsqs n87:png n88:ORykU6 n89:png n90:png n91:uQtRdr n92:png n94:png n95:png n96:png n97:png n98:png n99:png n100:png n101:png n102:png n103:png n104:png n105:png n106:png n107:png n108:png n109:png n110:png n111:png n112:png n113:png n114:png n115:png n116:png n117:png n118:png n120:7gVqoG n121:png n122:tumNjQ n123:png n124:dvqjkB n125:png n126:g8fQvB n127:png n128:png n129:jKXGBL n130:png n131:png n132:png n133:t5Vc32 n134:png n135:5d3xRl n136:png n137:png n138:A4sPpP n139:png n140:qbVpH8 n141:png n142:png n143:8avFBr n144:png n145:xDiTfB n146:pzASwT n147:png n148:MWnr4H n149:png n150:png n151:lnWwXA n152:7Qeu4b n153:png

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VirtOJDBCEntityFrameworkUsage"}% ---+++Visual Studio Windows <nop>DataGrid Form Application This article details the steps required to create a simple Visual Studio 2008 Windows Form application, with associated <nop>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%/VirtDataGridApp01.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 your 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>VirtWindowsFormApplication</b>, and click <b>OK</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp02.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Toolbox</b>, expand <b>Data</b> Controls and drag the <b><nop>DataGridView</b> control onto the form. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp03.png" style="wikiautogen"/>%BR%%BR% 1 Click the little <b>arrow</b> in the top right of the <b><nop>DataGridView</b> control to load the <b><nop>DataGridView Task</b> menu. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp04.png" style="wikiautogen"/>%BR%%BR% 1 Click on the <b>Choose Data Source</b> list box. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp05.png" style="wikiautogen"/>%BR%%BR% 1 Click on the <b>Add Project Data Source</b> link to connect to a data source. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp06.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%/VirtDataGridApp07.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%/VirtDataGridApp08.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Choose Data Source</b> dialog, select the <b><nop>OpenLink Virtuoso Data Source</b> from the list and click <b>Continue</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp10.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%/VirtAdoNetAddConn.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Select Database From List</b> radio button and choose the <b>jdbc</b> database from the drop down list. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCEDM4.png" style="wikiautogen"/>%BR%%BR% 1 Press the <b>Test Connection</b> dialog to verify the database is accessible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEDM5.png" style="wikiautogen"/>%BR%%BR% 1 Click <b>OK</b> to add the connection.%BR% %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCEDM5_1.png" style="wikiautogen"/>%BR%%BR% 1 Leave the default connect string name--<b><nop>JDBCConnectionString</b>--and click <b>Next</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCDataGridApp13.png" style="wikiautogen"/>%BR%%BR% 1 From the list of available tables returned for the JDBC database, select the <b>Shippers</b> table to be associated with the <b><nop>DataGridView</b> control. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCDataGridApp14.png" style="wikiautogen"/>%BR%%BR% 1 The column names of the selected table will be displayed in the the <nop>DataGridView. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCDataGridApp15.png" style="wikiautogen"/>%BR%%BR% 1 Resize the form and <nop>DataGridView to allow all columns to be visible, if possible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCDataGridApp17.png" style="wikiautogen"/>%BR%%BR% 1 To test the application, simply hit <b>Ctrl+F5</b> within Visual Studio or select <b>Start Debugging</b> from the <b>Debug</b> menu. %BR%%BR%<img src="%ATTACHURLPATH%/VirtDataGridApp16.png" style="wikiautogen"/>%BR%%BR% 1 The data from the <b>Shippers</b> table will be displayed in the <b><nop>DataGrid</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCDataGridApp18.png" style="wikiautogen"/>%BR%%BR% The task is now complete.

sioc:id

b7d25116c29e75d27cc6fb213aae3aa6

sioc:link

n2:VirtOJDBCVisualStudioDataGridFormsApp

sioc:has_container

n16:VOS

n63:has_services

n64:item

atom:title

VirtOJDBCVisualStudioDataGridFormsApp

atom:source

n16:VOS

atom:author

n32:this

atom:published

2017-06-13T05:46:27Z

atom:updated

2017-06-29T07:39:01Z

sioc:topic

n16:VOS