Saturday, April 21, 2012

Sqlite Database With Cursor Adapter in Android








First Create Database Helper :



now in your first layout : res/main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
    <ListView
    android:layout_height="fill_parent"
    android:id="@+id/@android:list"
    android:layout_width="fill_parent"></ListView>
</LinearLayout>

second layout for insert Values: res/inslayout.xml

<?xml version="1.0" encoding="UTF-8"?>
    <RelativeLayout android:id="@+id/relativeLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    xmlns:android="http://schemas.android.com/apk/res/android">
   
        <EditText android:hint="Enter Your Name"
       
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="14dp"
        android:layout_alignParentRight="true"
        android:id="@+id/insName">
            <requestFocus></requestFocus>
        </EditText>
       
        <EditText android:hint="Enter Your Number"
        android:layout_width="wrap_content"
        android:inputType="phone"
        android:layout_height="wrap_content"
        android:layout_below="@+id/insName"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="17dp"
        android:layout_alignParentRight="true"
        android:id="@+id/insNumber"></EditText>
       
        <Button android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/insNumber"
        android:layout_alignParentLeft="true"
        android:text="@string/Add_User"
        android:id="@+id/insBtn"></Button>
       
        <Button android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignTop="@+id/insBtn"
        android:layout_alignParentRight="true"
        android:id="@+id/insCancel"
        android:text="@string/Cancle"></Button>
       
    </RelativeLayout>

now third Layout for Edit Values : res/editlayout.xml

<?xml version="1.0" encoding="UTF-8"?>
    <RelativeLayout android:id="@+id/relativeLayout1"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    xmlns:android="http://schemas.android.com/apk/res/android">
        <EditText
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_alignParentLeft="true"
        android:layout_marginTop="15dp"
        android:layout_alignParentRight="true"
        android:id="@+id/Ename">
            <requestFocus></requestFocus>
        </EditText>
        <EditText
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:inputType="phone"
        android:layout_below="@+id/Ename"
        android:layout_alignParentLeft="true"
        android:layout_alignParentRight="true"
        android:id="@+id/Enumber">
           
        </EditText>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_below="@+id/Enumber"
        android:layout_alignParentLeft="true"
        android:id="@+id/Eok"
        android:text="@string/OK"></Button>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_below="@+id/Enumber"
        android:layout_alignParentRight="true"
        android:id="@+id/Ecancle"
        android:text="@string/Cancle"></Button>
        <Button
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_alignTop="@+id/Ecancle"
        android:layout_centerHorizontal="true"
        android:id="@+id/EDelete"
        android:text="@string/Delete"></Button>
    </RelativeLayout>

now in your main Activity :