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

Answer 1

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.

Answer 2

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

Answer 3

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