Working with SQLite database for windows mobile application

Question

Dear sir This is sulochana am new to develop an windows phone app here am trying to connect SQLite database for login credentials but am unable to connect the SQLite database.

sulochana g · Answer

I did not try to connect other database i will try and let you know

Sumit Jolly · Answer

not sure why are you unable to connect with sqllite. can you try to connect with any other database say ms-access (mdb)?

sulochana g · Answer

Can you please any one solve this problem am unable to connect the SQLite Database from code

sulochana g · Answer

Yes i given the path only this type of exception is coming

Sumit Jolly · Answer

did you try what i suggested? Dim path1 = C:\windowsphoneapp\ Sample.sqlite and is this sqllite exception thrown after above statement

sulochana g · Answer

Dear sir I tried this tutorial while establishing the connection from app this type of error msg its showing A first chance exception of type 'SQLite.Net.SQLiteException' occurred in SQLite.Net.DLL.

Sumit Jolly · Answer

i see that path is problem. do one thing for testing give complete path e.g. Dim path1 = C:\windowsphoneapp\ Sample.sqlite replace  C:\windowsphoneapp\ Sample.sqlite with your machine path where Sample.sqllite exists try it and let me know if it's establishing connection or not.

sulochana g · Answer

Dear sir I tried this article and i had created sqlite database in SQLitemanager and i read the connection string like this Dim path1 = Path.Combine(Path.Combine(ApplicationData.Current.LocalFolder.Path Sample.sqlite)) connection = New SQLiteConnection(New SQLitePlatformWP8() path1) when i read the connection its coming the different path and its shows an error msg path is not defined.

Sumit Jolly · Answer

this link is step by step tutorial for what you're trying to acheive. http://khatrishashank.wordpress.com/2013/12/05/windows-phone-8-app-with-sqlite/ Please click checkbox This is correct answer if you find it helpful!