Prerequisite

If you did not understand this lecture.Delete a row from android SQLite database .You should also read my previous lectures  Android how can add data into SQLite and Android SQLite how can retrieve data and Android SQLite get a single row from table. After reading these lecture you will also able Delete a single row from database.

Introduction

In this lecture well we describe how can Delete a single row from Android SQLite Database.And also describe what is SQLite.why we can use it.After Reading this lecture you will understand how can Delete row from android SQLite Database . And i hope you will create Database of your application and also Delete row from database after reading this series.

What is Android SQLite database

SQLite is a embedded (RDBMS) Stand for Relation Database Management system.Most relation database such as ORA-CAL and SQL are example that are working independently and store the information .SQLite is referred to as embedded because it is provided in the form of a library that is linked into applications.The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.There is no sever that are running in the background.All the Database function are perform internally.

Description of Deleting a Row

In this lecture we learn about how can delete a row from android SQLite database.So we use previous layout and add a button in this layout..When user enter a particular name for search and click on button the email and phone number related to name are appears.And if user want to delete this information click on delete button all the information will delete from database.So this is a work that will done this section.please read this lecture carefully all the detail is provides step by step.For more detail about android SQLite Database how can delete information please click on Delete a row from android SQLite database

Layout XML BASIC

XML Layout 

First of you will open a XML file of layout and set Linear Layout  and add  Edit text

Different property that are used in layout.xml file  explain here

  • warp_content   warp_content means height and width similar to the text that are entered.
  • Match_parent   means height and width similar to parent.
  • Edit text              The Edit Text control allows a user to enter text into an application
  • Button                  When user click on a button show information

Search_content_layout.XML

  • In this example we are going to create a simple UI that includes only (Text  view)  with Different attributes.And Write the following code into Search_content_layout.XML
And Write the following code SearchContantActivity. java class
 And Write the following code UserDbHandler. java class
Run the Application

Alt Tag android sqlite delete image

Run the application.And  click on third button a new activity will open.And user enter a particular name for search  and click on button the email and phone number related to name are appears .And if user want to delete a information click on delete button all the information will delete from database.

Alt Tag android sqlite delete search

 

Conclusion

In this lecture we learn about Android SqLite database how can get Delete row from database.. I hope you will understand this lecture.Thank you for reading this lecture Hope you got the idea.