SQLite Insert Operation in Xamarin iOS

Introduction

Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows phone, Android and iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.

• Browse code here.
• SQLite Create Operation 

Prerequisites 

• Xamarin Studio
• Xcode

The steps given below are required to be followed in order to insert data into SQLite database in Xamarin iOS, using Xamarin Studio.

Step 1

Go to Xamarin Studio.

Click New Solution—> select iOS—>select App--> Choose single View App. Afterwards, click Next.

 

Step 2

In this step, configure your app. Give the app name (Ex:sample), Organization Identifier. Afterwards, click Next.

 

 

Step 3

In this step, give your project name (Ex: Sample) and solution name (Ex: Sample). Give the path of your project. Afterwards, click Create.

 

Step 4

Subsequently, go to the solution. In the solution, get all the files and sources in your project. Now, select Main.storyboard and double click to open Main.storyboard page.

 

 

Step 5

After opening the Main.storyboard, you can design the page, as per your desire.

 

 

Step 6

In this step, design your app, using storyboard and Toolbox.

• Button(btnCreateDB)
• Button(btnInsert)
• TextField(txtName)
• TextField(txtAge)
• Label(lblDbPath)
• Label(lblDisplay)

 

 

Step 7

In this step, add one package in your project.

• sqlite.net

Go to Solution Explorer—>Package—>Add Package.

Now, choose Mobile sqlite.net Crashes and select Version. Afterwards, click Add Package.

 

Step 8

In this step, add one class file name called (Student.cs).

This class is called Student table.

 

 

Step 9

In this step, go to Student.cs page. Write the code given below.

Student.cs

using System;
using SQLite;
namespace XamariniOSSQLite {
    public class Student {
        [PrimaryKey, AutoIncrement]
        public int id {
            get;
            set;
        }
        public string Name {
            get;
            set;
        }
        public string Age {
            get;
            set;
        }
    }
}

 

Step 10

In this step, go to the ViewController.cs page. Write the code given below.

ViewController.cs 

using System;
using UIKit;
using System.IO;
using SQLite;
namespace XamariniOSSQLite {
    public partial class ViewController: UIViewController {
        public static string DbName = "SQLitedb.db3";
        public static string DbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), DbName);
        protected ViewController(IntPtr handle): base(handle) {
            // Note: this .ctor should not contain any initialization logic.
        }
        public override void ViewDidLoad() {
            base.ViewDidLoad();
            // Perform any additional setup after loading the view, typically from a nib.
        }
        partial void BtnInsert_TouchUpInside(UIButton sender) {
            InsertData();
        }
        partial void BtnCreate_TouchUpInside(UIButton sender) {
            CreateDB();
        }
        public void CreateDB() {
            try {
                var db = new SQLiteConnection(DbPath);
                db.CreateTable < Student > ();
                lblDBName.Text = "DB Path:" + DbPath;
            } catch (Exception e) {
                Console.WriteLine(e);
            }
        }
        public void InsertData() {
            try {
                string name = txtName.Text;
                string age = txtAge.Text;
                var student = new Student {
                    Name = name, Age = age
                };
                var db = new SQLiteConnection(DbPath);
                db.Insert(student);
                lblDisplay.Text = name + ":" + age;
            } catch (Exception e) {
                Console.WriteLine(e);
            }
        }
        public override void DidReceiveMemoryWarning() {
            base.DidReceiveMemoryWarning();
            // Release any cached data, images, etc that aren't in use.
        }
    }
}

Step 11

Now, go to Run option, choose Debug, the list of iPhone and iPad Simulators, which are available. You can choose any one Simulator and run it.

 

 

Output

After few seconds, the app will start running on your iPhone Simulator. You will see your app working successfully.

You can click Create DB button .Now, SQLite database will be created successfully. Afterwards, give the input, click Insert Data and the data will be inserted successfully



Summary

This was the process of how to insert data into SQLite database in Xamarin iOS,  using Xamarin Studio.