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

Storing data in a SQLite database


It is quite difficult to imagine an application that uses a database but does not insert anything into it. Thus, it is crucial that you know how to store data in tables in the database. In this recipe, you will learn how to do it.

As an example, you will slightly modify the project from the previous recipe by adding the data of three categories while initializing the database.

Getting ready

To step through this recipe, you need the project from the previous recipe.

How to do it...

To modify the preceding example to add the data of three categories while initializing the database, modify the InitializeDatabase method in the MainViewModel class in the MainViewModel.cs file, as shown in the following code snippet:

        public void InitializeDatabase() 
        { 
            using (SQLiteConnection connection = GetConnection()) 
            { 
                if (connection.GetTableInfo("categories").Count == 0) 
                { 
                    connection...