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

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.