{"id":332,"date":"2019-08-12T13:24:33","date_gmt":"2019-08-12T12:24:33","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=332"},"modified":"2019-08-12T13:24:33","modified_gmt":"2019-08-12T12:24:33","slug":"connecting-to-mysql-in-visual-studio","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/programming\/asp-net\/connecting-to-mysql-in-visual-studio\/","title":{"rendered":"Connecting to MySQL in Visual Studio"},"content":{"rendered":"\n

Note the instructions below assume you already have a database setup on the MySQL server. Please see the MySQL support pages<\/a>\u00a0for details on how to get a MySQL database setup. <\/p>\n\n\n\n

To connect to your MySQL database bring up Server Explorer either by clicking on the tab next to the Toolbox or by going View > Server Explorer. Right click on ‘Data Connections’ then click ‘Add Connection…’<\/p>\n\n\n\n

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

On the next screen (titled ‘Choose Data Source’) change the data source by ensuring ‘MySQL Database’ is selected, then click the ‘Continue’ button.<\/p>\n\n\n\n

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

For the ‘Server name’ enter mysql.cms.gre.ac.uk<\/strong> then enter your username and MySQL password in the relevant fields. When you have entered these correctly you’ll be able to select your database (mdb_username).<\/p>\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’, and you can then setup an SQLDataSource using this connection.<\/p>\n\n\n\n

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

\n\nNote that you may need to build your queries manually by picking the ‘Specify a custom SQL statement or stored procedure’ option and then building your query manually as Visual Studio will attempt to add elements such as [<\/strong> (left square bracket) and ]<\/strong> (right square bracket) that will generate errors when processed in MySQL if you use the ‘Specify columns from a table or view’ option.<\/p>\n\n\n\n

Once you have built your queries you can use them to populate data controls such as a grid view etc.\n\n<\/p>\n\n\n\n


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

Note the instructions below assume you already have a database setup on the MySQL server. Please see the MySQL support pages\u00a0for details on how to get a MySQL database setup. To connect to your MySQL …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":49,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-332","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/332","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=332"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/332\/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=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}