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

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

Subject Item

n25:this

foaf:made

n2:VirtInformixVisualStudioDataGridFormsApp

Subject Item

n26:this

sioc:creator_of

n2:VirtInformixVisualStudioDataGridFormsApp

Subject Item

n9:item

n8:services_of

n2:VirtInformixVisualStudioDataGridFormsApp

Subject Item

n30:this

sioc:creator_of

n2:VirtInformixVisualStudioDataGridFormsApp

Subject Item

n17:VOS

sioc:container_of

n2:VirtInformixVisualStudioDataGridFormsApp

atom:entry

n2:VirtInformixVisualStudioDataGridFormsApp

atom:contains

n2:VirtInformixVisualStudioDataGridFormsApp

Subject Item

n2:VirtInformixVisualStudioDataGridFormsApp

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:42:26.757397

dcterms:modified

2017-06-29T07:37:47.712771

rdfs:label

VirtInformixVisualStudioDataGridFormsApp

foaf:maker

n25:this n36:this

dc:title

VirtInformixVisualStudioDataGridFormsApp

opl:isDescribedUsing

n50:rdf

sioc:has_creator

n30:this n26:this

sioc:attachment

n4:png n5:png n7:png n10:png n11:png n12:png n13:png n14:png n15:png n16:png n18:png n19:png n20:png n21:png n22:DS_Store n23:DS_Store n28:DS_Store n32:qYDjQ0 n33:png n34:png n35:png n38:png n39:png n40:png n41:png n42:png n43:png n44:png n45:png n46:DS_Store n47:png n48:png

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VirtInformixEntityFrameworkUsage"}% ---+++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%/VirtInfDataGridApp01.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%/VirtInfDataGridApp02.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%/VirtInfDataGridApp03.png" style="wikiautogen"/>%BR%%BR% 1 Click on the little <b>arrow</b> in the top right of the <b><nop>DataGridView</b> control. This loads the <b><nop>DataGridView Task</b> menu. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp04.png" style="wikiautogen"/>%BR%%BR% 1 Click on the <b>Choose Data Source</b> list box. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp05.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%/VirtInfDataGridApp06.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%/VirtInfDataGridApp07.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%/VirtInfDataGridApp08.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%/VirtInfDataGridApp09.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Connection Properties</b> dialog, specify the <b>hostname</b>, <b>portno</b>, <b>username</b> and password for the target Virtuoso Server and check the <b>Save Password</b> check box. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp10.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Select Database From List</b> radio button and choose <b>stores_demo</b> from the drop down list. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp11.png" style="wikiautogen"/>%BR%%BR% 1 Press the <b>Test Connection</b> dialog to verify that the database is accessible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp12.png" style="wikiautogen"/>%BR%%BR% 1 Leave the default connect string name--<b>stores_demoConnectionString</b>--and click <b>Next</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp13.png" style="wikiautogen"/>%BR%%BR% 1 From the list of available tables returned for the stores_demo database, select the <b>msgs</b> table to be associated with the <b><nop>DataGridView</b> control. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp14.png" style="wikiautogen"/>%BR%%BR% 1 The columns names of the select table will be displayed in the the <nop>DataGridView. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp15.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%/VirtInfDataGridApp16.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%/VirtInfDataGridApp17.png" style="wikiautogen"/>%BR%%BR% 1 The data from the <b>msgs</b> table will be displayed in the <b><nop>DataGrid</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp18.png" style="wikiautogen"/>%BR%%BR% 1 To make the <b><nop>DataGridView</b> updateable, you will need to manually add some code to the project along with a suitable control to invoke the code.%BR%%BR% Drag a <b>Button</b> control onto the form. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp19.png" style="wikiautogen"/>%BR%%BR% 1 Right click on the Button and select <b>Properties</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp20.png" style="wikiautogen"/>%BR%%BR% 1 In the Properties view, edit the button's <b>Text</b> property to read <b>Save Changes</b> and its <b>(Name)</b> property to read <b>saveChanges</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp21.png" style="wikiautogen"/> <img src="%ATTACHURLPATH%/VirtInfDataGridApp22.png" style="wikiautogen"/>%BR%%BR% 1 The button will now update to reflect these changes.%BR%%BR% NOTE: You will need to resize the button to make the new text visible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp23.png" style="wikiautogen"/>%BR%%BR% 1 Double click the new button to generate the required event handler. It should take you directly to the area of code that will execute when the button is clicked. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp24.png" style="wikiautogen"/>%BR%%BR% 1 Edit the saveChanges_Click event handler code to include the following line.%BR%%BR% <verbatim> private void saveChanges_Click(object sender, EventArgs e) { this.msgsTableAdapter.Update(this.stores_demoDataSet.msgs); } </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp25.png" style="wikiautogen"/>%BR%%BR% 1 Now test the application again by hitting <b>Ctrl+F5</b>.%BR%%BR% Scroll to the empty row at the bottom and enter data for a new row. Then, select <b>Save Changes</b> which will write the new row back to the database.%BR%%BR% Updates and deletes can be performed similarly. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp26.png" style="wikiautogen"/>%BR%%BR% 1 You can use Interactive ISQL to test that the changes that have been written. Interactive ISQL Interface is detailed in the [[VirtINFLinkingObjects][Linking Informix tables into OpenLink Virtuoso]] section. %BR%%BR%<img src="%ATTACHURLPATH%/VirtInfDataGridApp27.png" style="wikiautogen"/>%BR%%BR% The task is now complete.

sioc:id

601dcbcc6750b037aab49d4eacaf0c5e

sioc:link

n2:VirtInformixVisualStudioDataGridFormsApp

sioc:has_container

n17:VOS

n8:has_services

n9:item

atom:title

VirtInformixVisualStudioDataGridFormsApp

sioc:links_to

n2:VirtINFLinkingObjects

atom:source

n17:VOS

atom:author

n25:this

atom:published

2017-06-13T05:42:26Z

atom:updated

2017-06-29T07:37:47Z

sioc:topic

n17:VOS