how to add databse functionality to my mobile device application

Question

Hi,

Iam developing an application for my windows mobile 6 device on my computer with vista home premium 64 bit.

I have installed visual studio 8 trial version
.net framework 3.5
sql ce 3.5

Using visual c# I have created the required form interface  to accept the required data.
however unable to move further. I want to add the database functionality to my application, but i dont see any options on the screen.
want to save the data accepted and retrieve it when needed. but how. all that I see is dataset, datagrid in the toolbox on the left, under device data.
If I right click on the project and select add new item I see an related item called database. I do not see anything called sql...
Am I looking for right options in right places or something is missing, unable to know. am totally new to this environment. anybody help me. how to  create databse and use it - preferably sql ce 3.5 

Answer 1

Hi there, 

One possible solution is to write to a dataset and read/write to an xml file to store the data. 

More details can be found in here:

http://msdn.microsoft.com/en-us/library/84sxtbxh.aspx

hth,

Stu

Answer 2

Hi,

How would your applciation communicate with the device?
Could you pleae be more specific abou the scenario?

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

Hi,

you need to connect to sql mobile database--->on top of connect to sql server 2005 there is an option to connect sql mobile database......... choose the path and create the database it saves as an *.sdf file---> come back to ur application, add *.sdf file as an existing item  to your project and start querring  and deploy it................

Hope it works........

---

Nagarjuna Dilip