how to connect sqlite database in visual studio professional??

Question

I am trying to connect to sqlite database using java script,html...but i am not yet successful to make that connection.........please help me how to do this connection...Thanks in advance...

Answer 1

Hi satish,

There has a similar thread how to connect sqlite database.

http://social.msdn.microsoft.com/Forums/en-US/winappswithhtml5/thread/9eac12f6-5478-4eb7-bbcf-0770d2b745e5/ .

And with html5/javascript, you may also use indexedDB. IndexedDB is HTML5 specific feature. And this is also only supported by Windows Store app built with HTML/JavaScript (C#/VB.NET and C++ based app cannot benefit from this).

For details, please refer to: http://blogs.msdn.com/b/win8devsupport/archive/2013/01/10/using-html5-javascript-in-windows-store-apps-data-access-and-storage-mechanism-iii.aspx .

---

Roy
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

You could use the WinRT SQLite3 component.

Answer 3

hi Tian,

         is there any docs for sqlite daabase connection in JS,HTML..........

Answer 4

Hi,

There is no sample that I know. But you can use the method I provide above.

---

Roy
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 5

Hi Satish,

See Tim Heuer's blog entry UPDATED HOWTO: SQLite with Windows 8 apps for a walkthrough on how to use SQLite from a Windows Store app. If you scroll down to the JavaScript section Tim explains how to set up a project to use SQLite and the SQLite3 component that Phil mentioned.

--Rob

Answer 6

hi Rob,

           that blog seems to C# but i am searching for Javascript,HTML.............please help me in this issue..........

Answer 7

Hi Satish,

Please read the whole blog. As I mentioned in my post, there is a section on JavaScript.

--Rob