</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">ComponentOne Studio - Cloud Business App Edition </div> <div id="PageTitle"><div id="PageTitleText">Connect to a SQLServer Database </div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="CloudBusinessAppEdition.html">Cloud Business App Edition </a> > <a href="GettingStartedwithCloud Business Applications.html">Getting Started</a> > <a href="ConnectingtoData.html">Connecting to Data</a> > Connect to a SQLServer Database </td></tr></table></div> <div id="BodyContent"> <p>This topic demonstrates how to connect a screen to a <strong>SQL Server Database</strong>.</p> <p>Complete the following steps:</p> <ol> <li>In Solution Explorer, right click <strong>Data Sources</strong> folder.</li> <li>Select <strong>Add Data Sources</strong>. The <strong>Attach Data Source Wizard</strong> appears.</li> <li>In the <strong>Choose a data Source Type</strong> page, click <strong>Database</strong>, and then click <strong>Next</strong>.</li> <li>The <strong>Choose Data Source</strong> dialog box appears, click <strong>Microsoft SQL Server</strong>, and then click <strong>Continue</strong>.<br> <br> <img border="0" alt="" src="images/ConnectingtoData1.png"></li> <li>In the Server name box of the <strong>Connection Properties</strong> dialog box, enter the name of the SQL Server instance that you want to connect to.</li> <li>If your database is set up to use Windows authentication, click <strong>Use Windows Authentication.</strong> Otherwise, click <strong>Use</strong> <strong>SQL Server Authentication</strong>, and then enter user name and password to access database.</li> <li>Click <strong>Select</strong> or enter a <strong>database name</strong>. Then, in the drop-down list, select or enter the name of the database that you want to connect to, and then click <strong>OK</strong>. The <strong>Choose Your Database Objects</strong> page appears.</li> <li>In the <strong>Choose Your Database Objects</strong> page, select the tables and views that you want to use in your project, and then click <strong>Finish</strong>.</li> <li>The <strong>database, tables, and views</strong> that you selected appear in Solution Explorer as sub nodes of the Data Sources node.</li> </ol> <a name="seealsobookmark"></a> <div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><div class="SeeAlsoLink"> <a href="ConnecttoanOData Service.html">Connect to an OData Service</a></div> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script>$(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } });</script></p> <a target="_blank" href="http://feedback.componentone.com/forums/255790-asp-netlightswitch-documentation" target="_blank">Documentation Feedback </a> | <a href="http://our.componentone.com/groups/" target="_blank"> Product Support Forum </a> </div> </body> </html>