Book Image

Windows Application Development Cookbook

By : Marcin Jamro
Book Image

Windows Application Development Cookbook

By: Marcin Jamro

Overview of this book

Need to ensure you can always create the best Windows apps regardless of platform? What you need are solutions to the biggest issues you can face, so you can always ensure you’re making the right choices and creating the best apps you can. The book starts with recipes that will help you set up the integrated development environment before you go ahead and design the user interface. You will learn how to use the MVVM design pattern together with data binding, as well as how to work with data in different file formats. Moving on, you will explore techniques to add animations and graphics to your application, and enable your solution to work with multimedia content. You will also see how to use sensors, such as an accelerometer and a compass, as well as obtain the current GPS location. You will make your application ready to work with Internet-based scenarios, such as composing e-mails or downloading files, before finally testing the project and submitting it to the Windows Store. By the end of the book, you will have a market-ready application compatible across different Windows devices, including smartphones, tablets, and desktops.
Table of Contents (17 chapters)
Windows Application Development Cookbook
Credits
About the Author
Acknowledgements
About the Reviewer
www.PacktPub.com
Preface

Creating a SQLite database and tables


While storing data in textual and binary files is a convenient solution, using a database gives you significantly more possibilities. Fortunately, it is really easy to use the SQLite database in UWP applications running on various platforms, such as smartphones and desktops. In the current recipe, you will learn how to create a local SQLite database as well as how to create tables when the application is launched for the first time.

The subject of designing databases as well as using queries to select, insert, update, and delete data from particular tables is of course too big and can't be described in detail in this chapter. For this reason, this book will focus on presenting some practical aspects of using databases, so basic knowledge about databases, tables, and queries is necessary.

As an example prepared in this and the following recipes, you will develop a simple application for creating an offline blog, where you can present, add, edit, and delete...