locked
Need direction. SQL .dat file hot to manipulate the information so it's usable in Windows Store App

    Question

  • I have seen a lot of information on how to utilize SQLite to build apps and that's great and I can follow most of the exercises; however, I am stuck in that I have a .dat file that I created by export from SQL server and unclear how to get the information into my store application and utilize it.

    Can someone give me a jump start?


    ---------------------------------------------- Help the community and mark posts as Answered if it helps you out ----------------------------------------------

    Monday, September 08, 2014 5:02 PM

Answers

  • So I worked this out by converting the exported text file to xml. I will then use XDoc to get the information into the app.

    ---------------------------------------------- Help the community and mark posts as Answered if it helps you out ----------------------------------------------

    • Marked as answer by Rollo1002 Tuesday, September 09, 2014 4:03 PM
    Tuesday, September 09, 2014 4:02 PM

All replies

  • It depends on what's in the .dat file... you might do better on a SQL forum though.

    Matt Small - Microsoft Escalation Engineer - Forum Moderator
    If my reply answers your question, please mark this post as answered.

    NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

    Monday, September 08, 2014 7:11 PM
    Moderator
  • So the file was created using Batch Copy Paste from SQL and is a export from a single table.

    ---------------------------------------------- Help the community and mark posts as Answered if it helps you out ----------------------------------------------

    Monday, September 08, 2014 7:56 PM
  • So I worked this out by converting the exported text file to xml. I will then use XDoc to get the information into the app.

    ---------------------------------------------- Help the community and mark posts as Answered if it helps you out ----------------------------------------------

    • Marked as answer by Rollo1002 Tuesday, September 09, 2014 4:03 PM
    Tuesday, September 09, 2014 4:02 PM