How to connect android with SQLite database | Android SQLite Database Example |

Рет қаралды 81,130

5 жыл бұрын

This video shows you, how to create the SQLite database in your device as well as also gives you easy concept how to simply insert information in the table created in SQLite database. This assumes that you are familiar with SQL databases in general and helps you get started with SQLite databases on Android.
Download the source code :
***************************************
drive.google.com/file/d/1RhZO...
Download SQLite Database Browser here :
sqlitebrowser.org/

Пікірлер: 107

@DeepakSharma-vd1wl 4 жыл бұрын

Thannk you sir. For help of this video my project complete. Thanks once again 🤗🤗🤗

@purnachandramodak7985 3 жыл бұрын

Thank you sir, aap kitna easy samjhate hai...

@aleezafashion3574 5 жыл бұрын

i got the all concept in once. thanx a lot sir jee

@mdmansuralam3506 5 жыл бұрын

Found a good one. Kindly upload further videos pls.

@shahnawazalam8901 5 жыл бұрын

great way to make us understand

@jaysuthar225 Жыл бұрын

Thank you sir easy to learn video 👍

@vatsalpatel5879 4 жыл бұрын

nice video !! found very helpful with database work

@tmarman6936 5 жыл бұрын

great job bro it's really worked tnx tnx a lot dude

@MuhammadAhmad-qg1ri 3 жыл бұрын

Amazing Tutorial 😍😍

@mmythily4574 4 жыл бұрын

I like the keyboard sound 🤪

@rimi2419 Жыл бұрын

this helps me a lot..thank you

@MdShahin-ux9xv 4 жыл бұрын

Great job Sir... :)

@ansaralam895 5 жыл бұрын

Really helpfull video

@sabrinafeliz4822 3 жыл бұрын

hello sir please i have a problem i use external database but when i added a new table to database it doesn't work . can you tell me why please

@nurel-arifahhafizah5897 3 жыл бұрын

Thank youu sir. You save my life 😭😭😭😭

@MdJamalmca 3 жыл бұрын

😊. you can also go through this kzfaq.info/get/bejne/d7aKn9Z9ucm8ZZs.html

@ChiragRathi-xr2tl Жыл бұрын

hello sir you are good teacher , please sir add android studio camera part video

@Rahulpal-yt3ix 3 жыл бұрын

I m created database then after I see in SQLlite database soft then it show only attribute data not show inside the table so can help me to solve this?

@sabaparveen6019 4 жыл бұрын

Very good video sir jee

@anjumitagi9442 3 жыл бұрын

I am getting error in DbManager class. In the line super (context, db name, factory null,version 1);

@aleezafashion3574 5 жыл бұрын

please upload videos on fetching data from SQLite

@mdbabuddin71 5 жыл бұрын

Nice video sir jee

@user-su6wu1zp1d 11 ай бұрын

sir, you are terrific very helpful to me plz help us make me a full developer Android studio

@MdJamal-qv7mm 5 жыл бұрын

This one is good. but if u upload how to connect with wamp server, this will be helpful for us

@amarmaurya3467 5 жыл бұрын

sir , my device file explorer not show any files .

@jamalganjupazila 2 жыл бұрын

Please need a quick and easy solution: "Could not open database file, reason: database disk image is malformed sqlite". Please help me.

@Shubham.Kumar.Mishra 3 жыл бұрын

Sir pls make a video on how to import large csv file directly into sql file

@JagseerSingh-ey7vy 3 жыл бұрын

Hlo MD can you give me the source code as its showing restriction when I am clicking on link

@priyanshugupta7904 3 жыл бұрын

salute

@roshanshaw1981 5 жыл бұрын

Superb one

@eunicefoo6820 Жыл бұрын

Could not find the databases folder after insert data :(

@rajendra1515 4 жыл бұрын

Thanks sir

@sodagarali4442 2 жыл бұрын

very helpful video

@knowledge6218 5 жыл бұрын

why not show button for add record

@SANJAYMEENA-cp5yr 3 жыл бұрын

Sir Jese hum network me ni h or data upload krna h Jese Hi network me aye automatically sync hokr upload Ho jaye

@indianshaan1307 2 жыл бұрын

good explanation

@OfficialMotivation3423 Жыл бұрын

Very good ☺️☺️

@prakashanuvadia8870 3 жыл бұрын

nice explain.....

@sanjaytanti3085 3 жыл бұрын

Nice Video sir

@ishanmadushanka3709 2 жыл бұрын

thank you

@anoopnp7964 4 жыл бұрын

it is help full, audio is not clear and audibale due disturbance in background sound. And voice is not loud enough to hear and not clear.

@prathameshtemkar5662 3 жыл бұрын

Thank you

@akshatsingh28 3 жыл бұрын

Was there strict need for relative layout or you chose it for your convenience? Please guide

@melonman1276 3 жыл бұрын

No, But you should use relative as shown

@hazarablood-bank3242 3 жыл бұрын

where to find online free sql lite database

@aadan123 3 жыл бұрын

sir mera upload failed aa rha ha sub kuch same kya ha

@knowledge6218 5 жыл бұрын

hi button is not show for add

@coding_dare 2 жыл бұрын

Hello bro Actually i want to learn about how to connect database with an android app

@_ProjectGuide 4 жыл бұрын

It is showing Table count zero.

@sonu39721 3 жыл бұрын

sir I got message successfully added but not getting any element in db browser, pls help

@kaaviyam2710 Жыл бұрын

same here

@alu6337 3 жыл бұрын

Hello Sir, database is created but it is not taking input values, whenever I enter details and click the add button, its showing failed and doesn't show record details in the database. Please Help!

@siddharthsharma5807 3 жыл бұрын

yes same problem happend with me... did u got ur solution then do let me know

@BilalKhan-do1xg 4 жыл бұрын

Asalamualykum sir ....... thanks for this video but we are curious for how to show the existing data in sqlite databaes on next activity plzzz sir if you have enough time to give for next video...... kindly very thanks for you

@MdJamalmca 4 жыл бұрын

Walekum Assalam. ok sultan, i will try to make videos on your required topic

@khanbacha3351 4 жыл бұрын

Warmly thankful to you sir..... plzzzz make it as soon as possible.....

@MdJamalmca 4 жыл бұрын

kzfaq.info/get/bejne/p790mNiaqtq-fWg.html

@MdJamalmca 4 жыл бұрын

kzfaq.info/get/bejne/p790mNiaqtq-fWg.html

@creativediaries4200 4 жыл бұрын

Sir, my device file explorer is not showing the (databases) folder inside my package.....how to resolve this.??

@MdJamalmca 4 жыл бұрын

In Device File Explorer, check which device is showing in drop down. make it assure you have create the database in the same device which is showing in drop down.

@creativediaries4200 4 жыл бұрын

@@MdJamalmca Thanks sir, problem got resolved!!

@_ProjectGuide 4 жыл бұрын

Sir, Database is created successfully and also after entering the data it is showing successfully inserted but whenever i opened database file i am not able to find my table.

@ilaydaozb Жыл бұрын

did you solve the problem, I have same problem too

@_ProjectGuide Жыл бұрын

@@ilaydaozb No I have changed thr database to Firebase. I have connect my to Firebase

@ilaydaozb Жыл бұрын

@@_ProjectGuide oh Okay, thank you. I think its impossible to connection to sqlite for me 🥲

@sangharshapps8600 3 жыл бұрын

sir ye hum hosting ke uper phpmyadmin me jo database hota he use kaise connect karte hai.

@MdJamalmca 3 жыл бұрын

in that case you need php api files in the hostinage space. point that file using domain name. and then u android will send information to that php api file and that php api will connect to phpmyadmin kzfaq.info/get/bejne/oN9gZpiVrcmuonk.html this is sample video. you just need to chang the 10.0.2.2 with your domain name.

@manjunathakotagunasi6049 4 жыл бұрын

Bro, database is created but its not taking input values, whenever i enter details and click the add button, its showing failed to add details to data base

@sarra2288 4 жыл бұрын

Same :( did you find the solution?

@manjunathakotagunasi6049 4 жыл бұрын

@@sarra2288 yes

@nouramms497 4 жыл бұрын

please tell us how did you solve it?

@Rahulpal-yt3ix 3 жыл бұрын

may be problem in table name in insert ()

@Daily_Viral_Reels 4 жыл бұрын

Sir, android sqlite ka complete video banaye

@MdJamalmca 4 жыл бұрын

sure. i will make it very soon.

@akbarshaikh8448 4 жыл бұрын

Sir can you provide source code in text format

@MdJamalmca 4 жыл бұрын

drive.google.com/file/d/1RhZOaf2xqnP3EcXA6n6xBmkH5gr-EHIw/view?usp=sharing

@atiqahhh9800 4 жыл бұрын

If we remove table that we created in DBManager in Android studio, would it be deleted in the sql browser too?

@MdJamalmca 4 жыл бұрын

no. But From the next time, when you again browse the database in DB-Browser after deleting the table in DB Manager(A/S) , then there will be no table in DB Browser too.

@atiqahhh9800 4 жыл бұрын

@@MdJamalmca thank you sir but what if we drop tables in the browser? Will the codings in Android studio deleted? If not, does that mean that we can't really update our database through the browser and we can only view our data on it?

@MdJamalmca 4 жыл бұрын

@@atiqahhh9800 DB Browser is another platform and it is independent completely. using DB Browser we can see the content directly like SQL server. so thats why we use DB browser to browse the database created in android device. we pull out the database from device and check its content and structure using DB Browser.

@vicksheetshanbhag7820 4 жыл бұрын

DB is created but tables inside db are not created, what might be the problem?

@MdJamalmca 4 жыл бұрын

check the sql command properly.

@vicksheetshanbhag7820 4 жыл бұрын

That issue is solved Actually I didn't know that we have to choose 3 files including .db file for viewing Sqlite DB. Thank you

@bettuanumathew7932 4 жыл бұрын

where is the code

@MdJamalmca 4 жыл бұрын

kzfaq.info/get/bejne/d7aKn9Z9ucm8ZZs.html

@rabiakanwal8506 4 жыл бұрын

i have an issue when i write db.execSQL(). db is red and not referenced

@MdJamalmca 4 жыл бұрын

check the sql written in the bracket or its proper concatenation with table name

@rabiakanwal8506 4 жыл бұрын

@@MdJamalmca one more thing. Sqlite install C foldet mein krna hai. Ya C mein andriodproject mein?

@MdJamalmca 4 жыл бұрын

no need to install. it is already come with android studio. just inherit SQLiteOpenHelper class

@MdJamalmca 4 жыл бұрын

Please watch the complete video once, hope it will clear your all confusion. 🙂

@rabiakanwal8506 4 жыл бұрын

Yah i saw your whole video and implement but in package database is not showing of mine

@maruko8324 3 жыл бұрын

is this video, bass boosted

@mariusradu3849 4 жыл бұрын

Code link maybe?

@MdJamalmca 4 жыл бұрын

kzfaq.info/get/bejne/d7aKn9Z9ucm8ZZs.html

@beatriceandra1527 5 жыл бұрын

forgot the most important part : submit button

@pnarpercin737 4 жыл бұрын

the title is english but the video is not?

@abdulkadir2959 3 жыл бұрын

it's gibberish, something Indian idk, report them as misleading because this shit is definitely not English. they're doing it for the views.

@Sj-yf2jg 3 жыл бұрын

fix your sound system first.

@prestristan8092 4 жыл бұрын

damn... english titles...

@harshadlondhe1756 Жыл бұрын

intro nahi dala unsubscribed

@CK-mu6ns 4 жыл бұрын

Hey benchot, talk in english if you have an english title

@lutaayaabdulsalaam9978 2 жыл бұрын

Speak some English man