×

Discussion Board

Results 1 to 13 of 13
  1. #1
    Registered User
    Join Date
    Jun 2013
    Posts
    19

    Sqlite for Windows Phone 7.5 Select Query Help

    Hi ,


    I have been trying to use SQLite in Windows Phone 7.5 Project. I am able to insert data in Sqlite Database but my not able to get back the data using Select Query. Could you please help me out with resolving the error?


    The data that i receive is blank always even though there is data available in db as per my query. I have verified existence of Data using windows Phone Power Tools by checking Sqlite database stored in IsolatedStorage


    I have tried two times, files for both my projects are


    1) http://sdrv.ms/19DGxGv


    2) http://sdrv.ms/GIVlNj .


    Note: I need the project of windows Phone 7.5 and not windows phone 8. So please dont upgarde it to Windows Phone 8.
    Last edited by Harneet; 2013-10-11 at 12:03.

  2. #2
    Nokia Developer Champion
    Join Date
    Feb 2013
    Location
    Dublin, Ireland
    Posts
    568

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Which WP 7.5 SQLite library are you using, all of which are quite old?

  3. #3
    Registered User
    Join Date
    Jun 2013
    Posts
    19

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    you could download the project files and look at that library. I am not sure which one I am using. Bcz this is first tym I ve been using sqlite in wp7.5

  4. #4
    Nokia Developer Champion
    Join Date
    Feb 2013
    Location
    Dublin, Ireland
    Posts
    568

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    And why did you decide to use SQLite on WP 7.5 (which is not officially supported) instead of the built-in MS-SQL CE database, which is and has far better documentation?

  5. #5
    Registered User
    Join Date
    Jun 2013
    Posts
    19

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Hey i am not good at LINQ to SQL that is why i prefer SQLite

  6. #6
    Nokia Developer Champion
    Join Date
    Feb 2013
    Location
    Dublin, Ireland
    Posts
    568

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Quote Originally Posted by Harneet View Post
    Hey i am not good at LINQ to SQL that is why i prefer SQLite
    No problem, just checking

    Have you tried working through these tutorials?

    http://dotnetslackers.com/articles/s...ows-Phone.aspx

    http://www.codeguru.com/csharp/.net/...pplication.htm

  7. #7
    Registered User
    Join Date
    Jun 2013
    Posts
    19

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    did u find where I went wrong?

  8. #8
    Registered User
    Join Date
    Dec 2013
    Posts
    3

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Quote Originally Posted by theothernt View Post
    And why did you decide to use SQLite on WP 7.5 (which is not officially supported) instead of the built-in MS-SQL CE database, which is and has far better documentation?
    Hi, Can you please provide me documentation for built-in MS-SQL CE database on WP 7.5.
    Thanks!

  9. #9
    Nokia Developer Champion
    Join Date
    Mar 2013
    Posts
    523

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Perhaps this article series can help you to get started with SQL CE on WP7: http://www.half-cooked.com/using-sql...1-apps-part-1/

  10. #10
    Registered User
    Join Date
    Dec 2013
    Posts
    3

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Thanks Dev, I will look into it and get back in case any concerns!!!
    Addition to that I have one more query -
    How can compare it (SQL CE) in comparison to Isolated Storage? Suggest pros/ cons, if any.
    Thanks!

  11. #11
    Nokia Developer Champion
    Join Date
    Mar 2013
    Posts
    523

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    IsolatedStorage is either a dictionary or file based storage, the other is a relational database that is actually using files in the isolated storage to store it's data.

    So it's basically database vs. file based storage.

  12. #12
    Registered User
    Join Date
    Dec 2013
    Posts
    3

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    thank you, One more query - any idea about concurrency of SQL CE database?

  13. #13
    Nokia Developer Champion
    Join Date
    Feb 2013
    Location
    Dublin, Ireland
    Posts
    568

    Re: Sqlite for Windows Phone 7.5 Select Query Help

    Quote Originally Posted by winit.ramesh View Post
    thank you, One more query - any idea about concurrency of SQL CE database?
    It looks like you have to handle that yourself...

    http://queconejo.wordpress.com/2011/...tabase-access/

Similar Threads

  1. SQLite query problem!
    By RajeevSahu in forum [Archived] Beginning Qt
    Replies: 1
    Last Post: 2011-06-30, 08:31
  2. Replies: 1
    Last Post: 2010-09-02, 06:17
  3. Select date sql query comparision.....
    By kalgi in forum Symbian
    Replies: 2
    Last Post: 2009-09-09, 06:20
  4. select access point query when using browser control
    By rajani_sp1 in forum Symbian User Interface
    Replies: 8
    Last Post: 2008-03-17, 07:16
  5. UNION in SELECT clause in database query.
    By globalline in forum Symbian
    Replies: 0
    Last Post: 2003-04-13, 19:13

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×