Complete, Responsive Mobile App Design Using Visual Studio: Integrating MySQL Database into Your Web Page

by Stephen Link

Overview

After finishing these pages you will have a complete database app designed using the visual development tool integrated into Visual Studio. The version utilized for designing this app was Visual Studio 2010 Professional. You may choose to use an Express version of Visual Studio which is available for free download from Microsoft. The target browser could be any current version of Internet Explorer, Firefox, Chrome, and even Safari. We will skip over the general process of creating a project in Visual Studio because that process should be considered generic across versions. The language used is C#. Using the Javascript/CSS approach detailed in this EBook, you can create as many layout variations (mobile, tablet, desktop) as your imagination can provide. This would include resizing of screen elements, fonts, buttons, and any other modifications which can provide a more user-friendly experience in your app. The resulting app will have the purpose of tracking mileage along the Appalachian Trail starting in GA and ending in ME. The app will include registration and login screens so that the users can manage their own profiles. The database "side of the house" consists of three main tables - users, individual mileage tracking and locations along the AT. Many of these locations include an accompanying picture. The mileage, pictures and longitude/latitude/altitude were downloaded from the web and combined into a single sheet. In order to enable web access to the database you will need a web host which provides MySQL databases. Detailed coverage of MySQL, MSSQL, and the general SQL command structure is beyond the scope of this EBook. In addition to the "play by play" in the code explanations, we will have a brief coverage of the MySQL statements utilized in this app in addition to the equivalent language that would be used for a Microsoft SQL server in a later chapter.

Product Details

ISBN-13:	9781508986225
Publisher:	CreateSpace Publishing
Publication date:	03/24/2015
Pages:	40
Product dimensions:	7.99(w) x 10.00(h) x 0.08(d)

About the Author

Stephen J. Link is a "computer guy" by profession, an author by hobby, and a Layman in the study of God's Word. He has a computer support book entitled "Link Em Up On Outlook" that was published in 2004 as a paperback (renamed to "Power Outlook" in reprint). He also has over 125 articles covering various topics published on independent sites. Various Books have been published covering a number of topics. As a programmer, he has a unique approach to help you master the ability to create the code to automate processes and add efficiency to your client's or employer's processes.