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

Download this episode

Download Video

Download captions

Description

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      faysal

      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.?

    • User profile image
      Jan

      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.

    • User profile image
      Fagun

      Can you give me the source code of this tutorial.

    • User profile image
      gduncan411
    • User profile image
      MrJ

      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.


    • User profile image
      Jan

      @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.

    • User profile image
      mhbayan
      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 ??
    • User profile image
      kvbhaskar7

      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 !

    • User profile image
      _Shahriar

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

    • User profile image
      Jeff

      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

    • User profile image
      Abdelaziz Ahmed

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

      thanks :) .

    • User profile image
      magnetic

      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

    • User profile image
      zrinA

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

    • User profile image
      Tam

      Please can someone explain how to do if you want to copy .db file to the phone storage that you can see the file in the file explore?

    • User profile image
      spanayotov

      I have a question related to discovering devices on my home network. The "Device Hub" in the phone settings shows only wifi devices. I have a Buffalo NAS which is wired connected to my router. I also web enabled this, so I can see it from the internet (created home cloud in a way). I can see this device on windows file explorer and also through IE browser on my windows 8.1 home PC. But on my Nokia 1020 I can only use the Buffalo app to see it from the web. I can't see it through any file explorer through my home network. Is there a solution for this? If you point me to some examples I'll be willing to try to create such a phone app.

      I'll appreciate your help.

    • User profile image
      spanayotov

      Can someone send me or point me to the code for the CardReader example from the end of session 15?

      Thanks.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.