How to do android database? How to fill all data through database like MySql

Question

0.00/5 (No votes)

See more:

Mobile

Android

SQLite

I'm beginner in android and i want to know how to fill all data in database.. Thanks for your help...

Posted 21-Feb-15 3:22am

JaironLanda

Add a Solution

2 solutions

Solution 2

Check these out:
1. Connecting your Android app to your WAMP server[^]
2. A Simple Android SQLite Example[^]

Posted 21-Feb-15 3:44am

Peter Leow

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Accepted Answer · 2015-02-21T03:43:00

Solution 1

In Android you can use the SQLite databases to store your data in the database-form. You can get help in this scenario from this CodeProject article[^], which explains how you can work with SQLite databases, for storing and extracting the data.

You can at the same time, read this third-party tutorial on working with the SQLite database in Android: http://www.tutorialspoint.com/android/android_sqlite_database.htm[^]

Finally, you can read the official Android's developer documentation about SQLite databases at their own developer's documentation website. The link, http://developer.android.com/training/basics/data-storage/databases.html[^], would be the place where you will find the official documentations about the SQLite usage in Android applications.

Posted 21-Feb-15 3:43am

Afzaal Ahmad Zeeshan

Comments

JaironLanda 21-Feb-15 10:35am

Hello! Thanks for your answer!. If i want to store articles in the database, what should i do?

Afzaal Ahmad Zeeshan 21-Feb-15 10:40am

Articles yet would be just text, you can store their data in database too. Databases support saving the text (character; nvarchar in database) data in them. So you won't have any problem. Saving the images won't be a good idea. You can skip this idea, and store the images in file system, instead of databases.

JaironLanda 21-Feb-15 10:47am

I'm beginner..hehe how to store and retrieve articles? I'm sorry still beginner..Thanks for your help!

Afzaal Ahmad Zeeshan 21-Feb-15 10:49am

SELECT command to retrieve, INSERT INTO command to insert. :) You can read more about them in some sort of documentation or tutorial.

JaironLanda 21-Feb-15 10:54am

i'm just want store the article and then i want retrieve back...And how to insert long article? Thanks for your help!

Afzaal Ahmad Zeeshan 21-Feb-15 12:00pm

Did you even try to search for the SELECT and INSERT INTO commands?

Kuthuparakkal 21-Feb-15 16:02pm

My 5+

Afzaal Ahmad Zeeshan 22-Feb-15 3:24am

Thanks for your vote. :)