Loading

Basic4Android - SQLite Demo (Add, Delete, Update/Edit)

Submitted by: 
Operating System: 
Visitors have accessed this post 26616 times.


Screenshot: 

The beauty of this simple little program is not in its novelty value, but that it can be added to any other program to add functionality and make a point of difference.
Please install the apk installer to see the sample demo in action.

To our webmaster your kindness is highly appreciated.

Hobert Starks always at your service!




Comments

nice sir

hob2006's picture

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

------------------------------------------------------------

Not quite understanding what this is? You can access a mysql database via an android?

hob2006's picture

>I use SQLite database for this application.Please read my post about SQlite.

>Please install the apk file to an android phone.
>This Simple program can Add, Delete, and Edit/Update data using SQLITE database.

>It is possible to use mysql database to an android phone via a network
connection (wi-fi) or in webserver.

>Thank you for your inquiry

Missing bal file

hob2006's picture

It is in the FILEs FOLDER.To see this simple program in action, kindly install the apk installer (in the Objects folder). This apps is for Android phones, tested in samsung galaxy y

hob2006's picture

Sir,

The complete source code is available upon request at [email protected]
Thanks!

admin's picture

I recommend you to post the complete source code so other will not have hard time to locate it.

hob2006's picture

complete source code is now ready to download sir

asadcr's picture

thank u very much

what are the softwares needed to run sqlitedemo program

hob2006's picture

SQLite database engine and Basic4Android IDE.Thank u sir

Thank you for the nice example. More are appreciated!

hob2006's picture

Welcome!

Hi, Im very interested in your app code. I have installed Basic4Android and i paste your code inside. I need add reference to sql and cursor, how i do it?
I need install sqlite, it can be installed in emulator?
Thanks!

hob2006's picture

Sir, This is due to broken license. It works on a licensed b4a IDE. Thanks!

Can we use Eclipse helios in running this application? Thanks.

hob2006's picture

This apps was written in Licensed Basic4Android. This is not compatible with eclipse helios. Thanks!

Can you please tell me how to connect MS SQL Server data base through basic4android.
thanks
Manoj

hob2006's picture

http://www.basic4ppc.com/forum/basic4android-getting-started-tutorials/13166-connect-android-ms-sql-server-tutorial.html#post74199

Without Asp Code we can connect to ms SQL i.e. Directly from hand set to SQL database. Thanks in Advance

so beautif i learn with this sql lite sooooooo tahnks

hello
i need help for run this program source in basic4android
one error runtime >> error device
[email protected]

hob2006's picture

This is due to your broken licensed IDE.Thanks!

1 - Je veux savoir l'emplacement de la base de données SQLDemo dans le système ANDROID...
2 - Est ce que c'est possible de définir un emplacement spécifie dans le chemin d'acces Basic4Android exp. /sdcard/Android/data/db.dql

Merci

hob2006's picture

Please translate in English.Thanks

Hi,

I want connect my device with my sqllite data base in my pc (ethernet) but the SMB not work in declaration : Dim SMB1 AS SMB (B4A not now it) ???

Thanks for help

hob2006's picture

Please connect using Wi-Fi.Thanks!

Dear Permalink

Please help me to update a table from Webserver to devise database in basic4android. I am using the below mentioned code it is updating only one value to all columns.

a.setDatabase("XXX.67.248.XXX","xxxx","manxxx","manxxxx")
L= a.Query("select * from TabDate")
For i = 1 To L.Size -1
SQL1.ExecNonQuery2("INSERT INTO datemstr VALUES (?, ?, ?, ?, ?)", Array As Object(i)
Next

Please help me.

Thanks in Advance

Manoj Kumar

sir pano po maupdate ung data ng .sql file? di sya naguupdate pag nagedit ako ng user and pass

hob2006's picture

Nakikita mo ung updated data sa listview?

Hello Sir ! In An android its possible to store the data(Image, text) in SqlLite and retrieve in xml ? pls advice , thank..

thank;s for your tutorial, its relly helpful, i wonder.. how if my database have a table contain image blop, can i make it grid thumbnail.. like contact grid ?

thnks

Nice

Bb.tazZ's picture

tnx for the code sir ^^

hi can you send me the full source code please at [email protected]

hey can i have the full source code about the Basic4Android - SQLite Demo (Add, Delete, Update/Edit) PLEASE... I badly need it.
JUST SEND IT @ [email protected]

hello, can you help me? how are the syntax to show data from sqlite to listview in basic4andoid? thankyou.

How to store data from XML to SQLite in B4A ?

thanks in advance.

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.