Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Building Apps for Windows Phone 8.1: (19) Programming SQLite on Windows Phone 8.1

Download

Right click “Save as…”

Learn how to use the popular open source database SQLite for data storage in your Windows and Windows Phone apps.

Full course outline:

Follow the Discussion

  • I have one thing to ask, In this video we saw queries which actually returns only A single column and then store the result using statement[0],statement[1] .... 

     

    WHAT if the query return multiple rows from the database? How do we get the values of each row.?

  • JanJan

    Is there any documentation or API for SQL PCL? How am I supposed to know how methods of SQL PCL work? I found many useful resources on SQLite statements but nothing on how to actually use them with PCL besides your video.

  • FagunFagun

    Can you give me the source code of this tutorial.

  • Greg Duncangduncan411 It's amazing what a professional photographer can do...

    @Fagun:Source for all the demos can be found here.

  • MrJMrJ

    Hello

    I want use database(Sql Ce or SQLite) in my project windows phone 8.1، but I can't add database in solution explorer and show me this error

    In SQL Compact Edition

    "The selected projecttype does not support Windows Phone 7.1/8-wrong
    TargetFrameworkMoniker:WindowsPhoneApp,Version=v8.1"


    In SQLite

    When add a references() to my project WP8.1 show me this error after Install (NuGet)
    "
    Install failed. Rolling back...
    Could not install package 'SQLitePCL 3.8.4.4'. You are trying to install this package into a project that targets 'WindowsPhoneApp,Version=v8.1', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author."

    Please Help Me

    Thank you.


  • JanJan

    @faysal:
    Look at http://marcominerva.wordpress.com/2014/02/13/the-new-portable-class-library-for-sqlite/ for an example of retrieving more than one result.

    @MrJ:
    I think SQLite PCL does not support WP8.1 yet. Don't hesitate to correct me please.

  • I create windows phone 8.1 app with sqlite pcl
    my app dont work !!!
    not create data base and not store my data
    how I can solved this ??
  • Can someone post a sample on working Universal app 8.1 using SQLite. The demos provided in the above link has targeted for Windows phone 8, but not 8.1. Any help is appreciated...Thanks !

  • it's a pain...i can't understand ! i mean no one using sql in wp8.1?

  • JeffJeff

    Re SQLITE on WP8.1

    I think you just need to apply the VSIX for WP8.1 available at:
    http :// visualstudiogallery . msdn.microsoft.com / 5d97faf6-39e3-4048-a0bc-adde2af75d1b

    then follow the existing WP8 examples

    Regards,
    JP

  • Abdelaziz AhmedAbdelaziz Ahmed

    Hi,
    How i can use sql server compact query with WP8.
    and what's the difference between SQLite & SQL server compact.

    thanks :) .

  • magneticmagnetic

    System.Data.SQLite, SQLite + LINQ, DataTable etc. for Windows Phone 8!
    Project and examples for download: http://sqliteandcsharp.blogspot.com/2014/09/jak-powinna-wygladac-ergonomia-pracy-ze.html

  • zrinAzrinA

    i have the same issue as in the video while making dependencies(pcl for SQLite) .i dont know how to fix.please help..

Remove this comment

Remove this thread

close

Comment on the Post

Already have a Channel 9 account? Please sign in