{"id":326,"date":"2019-08-12T10:23:33","date_gmt":"2019-08-12T09:23:33","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=326"},"modified":"2019-08-12T10:23:33","modified_gmt":"2019-08-12T09:23:33","slug":"connecting-to-sql-server-using-visual-studio","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/programming\/asp-net\/connecting-to-sql-server-using-visual-studio\/","title":{"rendered":"Connecting to SQL Server using Visual Studio"},"content":{"rendered":"\n

Please note the instructions below assume you already have a database setup on the SQL Server. Please see\u00a0the SQL Server support pages<\/a> for instructions on getting a SQL server database created for your use, and how to use SQL Server Management Studio to access it and create tables etc.<\/p>\n\n\n\n

To connect to your SQL Server database in Visual Studio start a new project and bring up Server Explorer either by clicking on the tab next to the Toolbox or by going to View > Server Explorer. Right click on ‘Data Connections’ then click ‘Add Connection’.
<\/p>\n\n\n\n

\"Screenshot:<\/figure><\/div>\n\n\n\n

On the next screen (Choose Data Source) change the data source ensure ‘Microsoft SQL Server’ is selected then click the ‘Continue’ button. <\/p>\n\n\n\n

\"Screenshot:<\/figure><\/div>\n\n\n\n
  • In the ‘Server name’ field enter ‘SQL-SERVER’.<\/li>
  • Change the ‘Authentication’ method to ‘SQL Server Authentication’.<\/li>
  • Enter your username and SQL Server password in the relevant fields.<\/li>
  • Enter your username in the ‘Select or enter a database name’ field.<\/li>
  • Tick the ‘Save my password’ box.<\/li><\/ul>\n\n\n\n
    \"Screenshot:<\/figure><\/div>\n\n\n\n

    Click the ‘OK’ button to exit the ‘Add Connection’ wizard and you will have added a connection to the database that will appear under ‘Data Connections’ in ‘Server Explorer’. <\/p>\n\n\n\n

    \"Screenshot:<\/figure><\/div>\n\n\n\n

    You can then setup an SQL Data Source using this connection, and use it to populate data controls such as a grid view, etc. as shown below:<\/p>\n\n\n\n

    \"Screenshot:<\/figure><\/div>\n\n\n\n


    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Please note the instructions below assume you already have a database setup on the SQL Server. Please see\u00a0the SQL Server support pages for instructions on getting a SQL server database created for your use, and …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":49,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-326","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=326"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/326\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/49"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}