<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="2. Installation Guide" />
<meta name="dc.subject" content="2. Installation Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="installation.html" title="Chapter Contents" />
<link rel="prev" href="installmacosx.html" title="Virtuoso for Mac OS X" />
<link rel="next" href="installvsent.html" title="Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>2. Installation Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="installvsgrid" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>2. Installation Guide</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="installation.html">Chapter Contents</a> | <a class="link" href="installmacosx.html" title="Virtuoso for Mac OS X">Prev</a> | <a class="link" href="installvsent.html" title="Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="installation.html">Installation Guide</a>
</div>
<br />
<div>
<a href="installwin32.html">Virtuoso for Windows</a>
</div>
<div>
<a href="linuxinstall.html">Virtuoso for Linux (Enterprise Edition)</a>
</div>
<div>
<a href="unxinstvirt.html">Virtuoso for Unix (Enterprise Edition)</a>
</div>
<div>
<a href="unixpersonainstall.html">Virtuoso for Unix (Personal Edition)</a>
</div>
<div>
<a href="installmacosx.html">Virtuoso for Mac OS X</a>
</div>
<div class="selected">
<a href="installvsgrid.html">Virtuoso ADO.Net Data Grid Form Application</a>
</div>
<div>
<a href="installvsent.html">Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application</a>
</div>
<div>
<a href="installusado.html">Using Visual Studio 2008 to Build an ADO.NET Data Services based Application</a>
</div>
<div>
<a href="installwfas.html">Windows Form Application for accessing Virtuoso RDF data via SPASQL using the Virtuoso ADO.Net Provider</a>
</div>
<div>
<a href="installcrweb.html">Creating a Web Browser Application to Access RDF Data Using The Virtuoso ADO.Net Provider</a>
</div>
<div>
<a href="installsilver.html">Creating a Silverlight Application to consume the service</a>
</div>
<div>
<a href="installnetriadd.html">Creating A Simple .NET RIA Services Application To Display Data
From Virtuoso</a>
</div>
<div>
<a href="installnetriavd.html">Creating a .Net RIA Services Application That Will Update Virtuoso Data</a>
</div>
<div>
<a href="clusterstcnf.html">Cluster Installation and Config</a>
</div>
<br />
</div>
<div id="text">
<a name="installvsgrid" />
<h2>2.6. Virtuoso ADO.Net Data Grid Form Application</h2>
<p>This section 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 a Virtuoso
database.</p>
<ol>
<li>Launch the Visual Studio 2008 SP1 IDE.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Visual Studio" src="../images/ui/insg1.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Visual Studio</td>
</tr>
</table>
</li>
<li>Create a Web Application project by going to the File menu in Visual Studio and choosing New Project.
</li>
<li>When the New Project window appears, choose either Visual Basic or Visual C# as the programming language.
</li>
<li>Within the language category, click on Windows and select Windows Form Application from the right-hand panel.
</li>
<li>Choose a name for the project, for example VirtuosoDataGridApp, and click OK.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="name for the project" src="../images/ui/insg5.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. name for the project</td>
</tr>
</table>
</li>
<li>From the Data, menu select the Show Data Sources menu item to display a list of available Data sources.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Show Data Sources" src="../images/ui/insg6.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Show Data Sources</td>
</tr>
</table>
</li>
<li>Click on the Add New Data Source link to add a new data source.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Add New Data Source" src="../images/ui/insg7.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Add New Data Source</td>
</tr>
</table>
</li>
<li>In the Data Source Configuration Wizard dialog Choose Data Source Type page, select the Database data source type and click Next.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Data Source Configuration Wizard" src="../images/ui/insg8.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Data Source Configuration Wizard</td>
</tr>
</table>
</li>
<li>In the Data Source Configuration Wizard dialog Choose your Data Connection page, select the New Connection button.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Data Connection page" src="../images/ui/insg9.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Data Connection page</td>
</tr>
</table>
</li>
<li>In the Choose Data Source dialog, select OpenLink Virtuoso Data Source from the list and click Continue.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="OpenLink Virtuoso Data Source" src="../images/ui/insg10.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. OpenLink Virtuoso Data Source</td>
</tr>
</table>
</li>
<li>In the Add Connection dialog, specify the hostname, portno, username, and password
for the target Virtuoso Server and check the Save Password check box.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Add Connection dialog" src="../images/ui/insg11.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Add Connection dialog</td>
</tr>
</table>
</li>
<li>Select the Select Database From List radio button and choose School from the drop down list
of available databases.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Select Database From List" src="../images/ui/insg12.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Select Database From List</td>
</tr>
</table>
</li>
<li>Click the Test Connection button to verify the connection is successful and then
click OK to add the connection.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Test Connection" src="../images/ui/insg13.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Test Connection</td>
</tr>
</table>
</li>
<li>Select the Yes, include sensitive data in the connect string radio button and click Next to continue.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="connect string" src="../images/ui/insg14.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. connect string</td>
</tr>
</table>
</li>
<li>In the Choose your Database Objects dialog select the table and columns to be queried, the shippers table is used in this example.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Choose your Database Objects" src="../images/ui/insg15.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Choose your Database Objects</td>
</tr>
</table>
</li>
<li>A DataSet for the shippers database object is created
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="shippers database" src="../images/ui/insg16.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. shippers database</td>
</tr>
</table>
</li>
<li>From the drop down list box next to the Shippers table ensure the DataGridView item is selected
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="DataGridView" src="../images/ui/insg17.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. DataGridView</td>
</tr>
</table>
</li>
<li>Drag the Shippers DataSet item onto the Form to create a scrollable and editable association of the Shippers table object with the Data Grid View automatically.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Drag" src="../images/ui/insg18.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Drag</td>
</tr>
</table>
</li>
<li>From the Debug Menu select the Start Debugging menu item to run the application.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Debug" src="../images/ui/insg19.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Debug</td>
</tr>
</table>
</li>
<li>The data in the Shippers table will be displayed in the DataGrid application created.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="DataGrid" src="../images/ui/insg20.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. DataGrid</td>
</tr>
</table>
</li>
<li>A new row can be inserted (updated or deleted) as indicated for the new DHL record inserted below and the save button clicked to save the change to the database.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="new row" src="../images/ui/insg21.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. new row</td>
</tr>
</table>
</li>
<li>The Virtuoso Interactive SQL tab of the Conductor can be used to run the query select * from Demo..Shippers.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Interactive SQL tab" src="../images/ui/insg22.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. Interactive SQL tab</td>
</tr>
</table>
</li>
<li>To verify the change has been successfully made in the database.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="verify" src="../images/ui/insg23.png" />
</td>
</tr>
<tr>
<td>Figure: 2.6.1. verify</td>
</tr>
</table>
</li>
</ol>
<p>The task is now complete.</p>
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="installmacosx.html" title="Virtuoso for Mac OS X">Previous</a>
<br />Virtuoso for Mac OS X</td>
<td align="center" width="34%">
<a href="installation.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="installvsent.html" title="Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application">Next</a>
<br />Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
785
