locked
Database using SQLite (.Net) RRS feed

  • General discussion

  • Can you please tell me how to create a simple two tables database using SQLite (.Net).

    I have installed SQLite for windows runtime and have added the NuGet Package Manager.. How to proceed now?

    Thank you..

    Tuesday, February 4, 2014 4:55 AM

All replies

  • Check out this tool http://sourceforge.net/projects/sqlitemanstudio/


    There are few more available.

    Thanks,

    Karthick

    Tuesday, February 4, 2014 6:27 AM
  • Thank u so much. Can u please guide me how to proceed further. 

    Initially I have made a simple app containing three text boxes (FName, LName and Age) in visual basic express 2012 for windows 8.. I want to store the data in the table that I have just created using SQLite Studio. Data is entered at runtime in the textboxes.

    Please Help. Thank You.

    Tuesday, February 4, 2014 8:02 AM
  • See the link, 

    http://code.msdn.microsoft.com/windowsapps/Sqlite-For-Windows-8-Metro-2ec7a882

    Hope it will help you.

    Tuesday, February 4, 2014 8:16 AM
  • I am not getting it.. I have added the references. Now what code I have to write and in which file? Plzz tell me related to VB.Net, not C#.

    Thanks.

    Wednesday, February 5, 2014 11:19 AM
  • Ok, I had problems with this as well. So here we go.

    1. Use the NuGet package manager and the "Extensions and updates..." under the "TOOLS" menu to get SQLite and integrate it with Visual Studio (I'm using 2012)

    2. Download the SQLite wrapper at: http://code.msdn.microsoft.com/windowsapps/Visual-Basic-Sqlite-WinRT-bf6fe131

    3. Put it somewhere convenient (I used my project folder)  and using the "Batch Build" option under the "BUILD" menu compile it all. Just select everything and compile it as you can then grab the DLL you need dependent on your target build

    4. After adding the SQLite references to your project add a new reference that uses the target DLL that was created from compiling the wrapper. So, for my project I'm compiling an ARM application so I need to browse to "x:\visual basic sqlite winrt wrapper\c#\bin\arm\release\" and add the reference to SqliteMetro.dll

    You can then use standard code (And it shows up in the intellisense dropdown :) )

    Imports SQLite


    Jeff

    Sunday, March 2, 2014 12:44 PM