×
iFour Logo

Xamarin Android: Create Login Using SQLite Database

iFour Team - January 30, 2021

Listening is fun too.

Straighten your back and cherish with coffee - PLAY !

Xamarin Android: Create Login Using SQLite Database

Xamarin is an open-source platform for creating modern and performance applications with .NET for iOS, Android, and Windows. This pattern allows developers to write all of their business logic in one language (or reuse existing application code) but achieve original performance, look and feel on each platform.

 

Table of Content

What is SQLite?

Android SQLite is the most preferred way to store data for Android applications. For many applications, SQLite is the backbone of applications whether used directly or by a third-party wrapper. We will create it today using the Android SQLite database.

It is embedded in Android By default. Therefore, no database setup or administrative work is required.

Now let's go step by step how to create a login form in Xamarin Android

We will create this project in Visual Studio 2019, so you too should try to use the latest versions.

Step 1: Select a new project

Open Visual Studio -> Create New Project ->Android App (Xamarin)

Then click on the Next button. Note the highlight point of the image as shown in the image.We build for mobiles so mobiles need to be selected.

Select new project
Image: Select new project

Step 2 : Give the project name

You can give your project the name you want. Enter the name of your project and click on the Create buttonwe have named our project SQLite which you can see in Image.

Give project name<
Image: Give project name

Step 3: Select template

From this, you can select whatever you want. All are templates. We only need a single page so we will select a single view app.If you need navigation you can also select the second option navigation drawer which will provide you navigation.

If you need a tab menu, you can also select the third option Tabbed App which will provide you a tab menu.

   

If you need a blank page then select the last option which will be a blank page.Select a low level whenever possible in the minimum Android version as doing so will help you run in Low device.

Then click on OK

Select template
Image: Select template
 
 

Now our project is ready as a normal template. Now we will add layout, NuGet package, required class, and interface.

Step 4:Add Layout

Next, go to Solution Explorer-> Project Name (SQLite) ->Resources Folder ->layout Folder. Right-click on Add -> Add item. A new dialog box will open. Select Android the layout, give a name for NewUser.xml and click Add buttonas shown in the image.

Now new Layout Page ready for Design.We will write our design code in this file.

Add Layout
Image: Add Layout

Step 5: Add Activity Class

Now we will add an Activity class to our project in which we will write the Register Related Business Logic code.

Go to Solution Explorer-> Project Name (SQLite).Right-click on Add -> Add item. Open new a dialog boxas shown in the image. Select Activity and give name for RegisterActivity.cs. Now, add the New Activity Class.

Add Activity Class
Image: Add Activity Class

Step 6: Add Table

Next, we need to create a database table, so we create a data layer class in the file, we will write the code to do the table, such as id, name, password, etc.

Go to Solution Explorer-> Project Name (SQLite).Right-click to Add -> Add item. Open a new dialog boxas shown in the image. Select Class, give a name for LoginTable.cs

 Add Table
Image: Add Table

Step 7 : NuGet package

Now we will install the NuGet package.

Go to Solution Explorer (Right -side)-> Project Name (SQLite) Right click -> Select Manage NuGet Packages.

NuGet package
Image: NuGet package

Step 8:Install NuGet package

Once the NuGet window opens, click on Browser from the above tab and search for SQLite package and install packages.

 

Planning to Hire Xamarin App Development Company?

Your Search ends here.

 

This package will help us to connect with the database as well as provide the required methodology.

Install NuGet package
Image: Install NuGet package

Step 9 : LoginTable.cs File

Next, Go to Solution Explorer open the LoginTable.cs file, and put the below code.

namespace SQLite
{
classLoginTab
{
[PrimaryKey, AutoIncrement]
publicint id { get; set; } 
[MaxLength(50)] // Maxlength set in UserName column
publicstringuserName{ get; set; }
[MaxLength(20)] // Maxlength set in passWord column
publicstringpassWord{ get; set; }
}
}
			 

Step 10:MainActivity.cs File

Next, Go to Solution Explorer open the MainActivity.cs file, and put the below code.

namespace SQLite
{
publicclassMainActivity :AppCompatActivity
{
EditTextuserName;
EditText Password;
Button ncreate;
Button nsign;
protectedoverridevoidOnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
Xamarin.Essentials.Platform.Init(this, savedInstanceState);
SetContentView(Resource.Layout.activity_main);
Android.Support.V7.Widget.Toolbar toolbar = FindViewById(Resource.Id.toolbar);
SetSupportActionBar(toolbar);
FloatingActionButton fab = FindViewById(Resource.Id.fab);
fab.Click += FabOnClick;
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.Main);
btnsign = FindViewById
 

Step 11:RegisterActivity.cs File

Next, Go to Solution Explorer open the RegisterActivity.cs file, and put the below code.

namespace SQLite
{
EditTextusername;
EditTexttxtPassword;
Button ncreate;
[Activity(Label = "RegisterActivity")]
publicclassRegisterActivity : Activity
{
protectedoverridevoidOnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.Newuser);
      
btncreate = FindViewById
			 

Step 12: Output

Finally let’s see the Output

 Output
Image: Output
 

By this way, we successfully created a login form using the SQLite database.

Conclusion

In this blog, we have created a login form for an Android OS using SQLite database.We tried to explain you the step by step method where we can create a normal login form using class, method, interface, database, and package.

Xamarin Android: Create Login Using SQLite Database Xamarin is an open-source platform for creating modern and performance applications with .NET for iOS, Android, and Windows. This pattern allows developers to write all of their business logic in one language (or reuse existing application code) but achieve original performance, look and feel on each platform.   Table of Content 1. What is SQLite? 1.1. Step 1: Select a new project 1.2. Step 2: Give the project name 1.3. Step 3: Select template 1.4. Step 4: Add Layout 1.5. Step 5: Add Activity Class 1.6. Step 6: Add Table 1.7. Step 7: NuGet package 1.8. Step 8: Install NuGet packages 1.9. Step 9: LoginTable.cs File 1.10. Step 10: MainActivity.cs File 1.11. Step 11: RegisterActivity.cs File 1.12. Step 12: Output 2. Conclusion What is SQLite? Android SQLite is the most preferred way to store data for Android applications. For many applications, SQLite is the backbone of applications whether used directly or by a third-party wrapper. We will create it today using the Android SQLite database. It is embedded in Android By default. Therefore, no database setup or administrative work is required. Now let's go step by step how to create a login form in Xamarin Android We will create this project in Visual Studio 2019, so you too should try to use the latest versions. Step 1: Select a new project Open Visual Studio -> Create New Project ->Android App (Xamarin) Then click on the Next button. Note the highlight point of the image as shown in the image.We build for mobiles so mobiles need to be selected. Image: Select new project Step 2 : Give the project name You can give your project the name you want. Enter the name of your project and click on the Create buttonwe have named our project SQLite which you can see in Image. Image: Give project name Step 3: Select template From this, you can select whatever you want. All are templates. We only need a single page so we will select a single view app.If you need navigation you can also select the second option navigation drawer which will provide you navigation. If you need a tab menu, you can also select the third option Tabbed App which will provide you a tab menu.   Read More: Roadmap To Xamarin Forms 5.0   If you need a blank page then select the last option which will be a blank page.Select a low level whenever possible in the minimum Android version as doing so will help you run in Low device. Then click on OK Image: Select template     Now our project is ready as a normal template. Now we will add layout, NuGet package, required class, and interface. Step 4:Add Layout Next, go to Solution Explorer-> Project Name (SQLite) ->Resources Folder ->layout Folder. Right-click on Add -> Add item. A new dialog box will open. Select Android the layout, give a name for NewUser.xml and click Add buttonas shown in the image. Now new Layout Page ready for Design.We will write our design code in this file. Image: Add Layout Step 5: Add Activity Class Now we will add an Activity class to our project in which we will write the Register Related Business Logic code. Go to Solution Explorer-> Project Name (SQLite).Right-click on Add -> Add item. Open new a dialog boxas shown in the image. Select Activity and give name for RegisterActivity.cs. Now, add the New Activity Class. Image: Add Activity Class Step 6: Add Table Next, we need to create a database table, so we create a data layer class in the file, we will write the code to do the table, such as id, name, password, etc. Go to Solution Explorer-> Project Name (SQLite).Right-click to Add -> Add item. Open a new dialog boxas shown in the image. Select Class, give a name for LoginTable.cs Image: Add Table Step 7 : NuGet package Now we will install the NuGet package. Go to Solution Explorer (Right -side)-> Project Name (SQLite) Right click -> Select Manage NuGet Packages. Image: NuGet package Step 8:Install NuGet package Once the NuGet window opens, click on Browser from the above tab and search for SQLite package and install packages.   Planning to Hire Xamarin App Development Company? Your Search ends here. See here   This package will help us to connect with the database as well as provide the required methodology. Image: Install NuGet package Step 9 : LoginTable.cs File Next, Go to Solution Explorer open the LoginTable.cs file, and put the below code. namespace SQLite { classLoginTab { [PrimaryKey, AutoIncrement] publicint id { get; set; } [MaxLength(50)] // Maxlength set in UserName column publicstringuserName{ get; set; } [MaxLength(20)] // Maxlength set in passWord column publicstringpassWord{ get; set; } } } Step 10:MainActivity.cs File Next, Go to Solution Explorer open the MainActivity.cs file, and put the below code. namespace SQLite { publicclassMainActivity :AppCompatActivity { EditTextuserName; EditText Password; Button ncreate; Button nsign; protectedoverridevoidOnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); Xamarin.Essentials.Platform.Init(this, savedInstanceState); SetContentView(Resource.Layout.activity_main); Android.Support.V7.Widget.Toolbar toolbar = FindViewById(Resource.Id.toolbar); SetSupportActionBar(toolbar); FloatingActionButton fab = FindViewById(Resource.Id.fab); fab.Click += FabOnClick; base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.Main); btnsign = FindViewById(Resource.Id.nlogin); btncreate = FindViewByIdResource.Id.nregister); txtusername = FindViewById(Resource.Id.username); txtPassword = FindViewById(Resource.Id.pwd); btnsign.Click += nsign_Click; btncreate.Click += ncreate_Click; CreateTable(); } privatevoidncreate_Click(object send, EventArgs eve) { StartActivity(typeof(RegisterActivity)); } privatevoidnsign_Click(object send, EventArgs eve) { try { stringdpPaths = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user,mydb"); vardbs = newSQLiteConnection(dpPaths); var data = dbs.Table(); var data11 = data.Where(x =>x.username == username.Text&&x.password == Password.Text).FirstOrDefault(); if (data11 != null) { Toast.MakeText(this, "Successfully Login", ToastLength.Short).Show(); } else { Toast.MakeText(this, "Username or Password invalid", ToastLength.Long).Show(); } } catch (Exception ex) { Toast.MakeText(this, ex.ToString(), ToastLength.Long).Show(); } } publicstringCreateTable() { var op = ""; op += "Creating Databse if it doesnt exists"; stringdpPaths = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user,mydb"); vardbs = newSQLiteConnection(dpPaths); op += " Databasesucessfully Created...."; return op; } Step 11:RegisterActivity.cs File Next, Go to Solution Explorer open the RegisterActivity.cs file, and put the below code. namespace SQLite { EditTextusername; EditTexttxtPassword; Button ncreate; [Activity(Label = "RegisterActivity")] publicclassRegisterActivity : Activity { protectedoverridevoidOnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.Newuser); btncreate = FindViewById(Resource.Id.create); txtusername = FindViewById(Resource.Id.userName); txtPassword = FindViewById(Resource.Id.password); btncreate.Click += ncreate_Click; } privatevoidncreate_Click(object sender, EventArgs e) { try { stringdpPaths = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user.db3"); vardbs = newSQLiteConnection(dpPath); dbs.CreateTable(); LoginTable table = newLoginTable(); table.username = username.Text; table.password = Password.Text; dbs.Insert(table); Toast.MakeText(this, "Record Added…", ToastLength.Long).Show(); } catch (Exception e) { Toast.MakeText(this, ex.ToString(), ToastLength.Long).Show(); } } } Step 12: Output Finally let’s see the Output Image: Output   By this way, we successfully created a login form using the SQLite database. Conclusion In this blog, we have created a login form for an Android OS using SQLite database.We tried to explain you the step by step method where we can create a normal login form using class, method, interface, database, and package.

Categories

Ensure your sustainable growth with our team

Talk to our experts
Sustainable
Sustainable
 

Blog Our insights

 A step-by-step guide on Excel Add-in development using React.js
A step-by-step guide on Excel Add-in development using React.js

Table of Content 1.What is an Excel Add-in? 2.Prerequisites for setting up your development environment 3.How to build Excel Add-in using React 4.How to run...

Read More
11 Ways AR and VR (Augmented Reality and Virtual Reality) Transforming the Healthcare sector
11 Ways AR and VR (Augmented Reality and Virtual Reality) Transforming the Healthcare sector

Table of Content 1. Helps in surgical procedures and treats phobias 2. Create new training opportunities for doctors 3. Real-time information helps to escape from painful...

Read More
How E-discovery tools can benefit the Legal industry?
How E-discovery tools can benefit the Legal industry?

Table of Content 1.Gather essential information quickly 2.Automate and streamline tedious tasks 3.Save considerable time and money in the discovery process 4.Analyze...

Read More