StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11096642
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-06-19T07:51:24.053
FavoriteCount
0
LastActivityDate
2012-06-19T07:51:24.053
LastEditDate
LastEditorUserId
0
OwnerUserId
1216003
ParentId
11096305
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Try the following method, which is working perfectly for me and also easy to understand Create one separate class which extends SQLiteOpenHelper <pre><code>public class DataBase extends SQLiteOpenHelper{ public static final String DATABASE_NAME = "Databasename"; public static final int DATABASE_VERSION = 1; public static final String SETTINGSID = BaseColumns._ID; public static final String ST_PHONENUMBER = "PhoneNumber"; public static final String ST_NAME = "Name"; public static final String ST_SECUREENABLED = "SecureSMS"; public DataBase(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); // TODO Auto-generated constructor stub } </code></pre> In <code>onCreate()/onUpgrade()</code> method you can create/delete your table <pre><code> @Override public void onCreate(SQLiteDatabase db) { String settings = "CREATE TABLE IF NOT EXISTS " + SETTINGS_TABLE + " (" + SETTINGSID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + ST_PHONENUMBER + " TEXT, " + ST_NAME + " TEXT, " + ST_SECUREENABLED + " TEXT"+ ");"; db.execSQL(settings); @Override public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) { db.execSQL("DROP TABLE IF EXISTS " + SETTINGS_TABLE); db.execSQL("DROP TABLE IF EXISTS " + LOCATION_TABLE); onCreate(db); } </code></pre> Insert values into database using the following method <pre><code> public void insertSettings(String phonenumber, String name,String securenames) { SQLiteDatabase db = getReadableDatabase(); ContentValues values = new ContentValues(); values.put(ST_PHONENUMBER, phonenumber); values.put(ST_NAME, name); values.put(ST_SECUREENABLED, securenames); db.insertOrThrow(SETTINGS_TABLE, null, values); } </code></pre> I hope this will guide in you in a right direction...
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POneed step by step process to use sqlite database in android
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USvinothp
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.