ppc aplication

[adeline]

im doing an application. im using the visual basic .net 2003 to build an application , just the window form, no web services etc. and uses the pocket pc 2002 emulator. i have a few questions.
1. how do i do the database. heard that only can create db in the emulator, means no external db.
2. is it true?
3. what is the command to clear the text boxes in the form? (textBox1.Clear()?)
4. is there any website i can have a look to have the coding for the components(buttons,textbox etc...)

[Strider]

1. The Pocket PC 2002 emulator is very very poor & lacking many features.
I would recommend using the 2003 emulator that comes with Visual Studio 2003 Pro

2. You can clear textboxes in a few different ways.
a. textbox1.text = "" b. textbox1.text = vbnullstring
c. Dim l_ctrl As Control
For each l_ctrl in Me.Controls
If Typeof(l_ctrl) Is Textbox Then
l_ctrl.text = vbnullstring
End If
Next

options c loops through each control on the form and for every textbox it finds it sets its text to an empty string

4.
http://samples.gotdotnet.com/quickst...pactFramework/
http://www.gotdotnet.com/community/u...e=CreationDate
http://www.develop.com/compactframework/
http://www.codeproject.com/netcf/

[adeline]

can i use the microsoft access as the db for my project?

[adeline]

i am not using the emulator anymore, im using a pocket pc device now. thanks !

[Strider]

Are you asking if you can using MS Pocket Access on the device or desktop MS Access on the device.

The compact framework does not support Pocket Access Database (.cdb). This was used in eVB. SQL Server CE is does not require licences for use on the compact framework.

However they are 3rd party tools you can buy in which you can access Pocket Access databases on your device. (http://www.inthehand.com/ADOCE.aspx)

However if you wish to use Access on the desktop and sql server ce on the device you can use webservices to retrieve the data from the access database & populate your device database.

If you do not wish to use webservices you can use the following 3rd party tools (http://www.gui-innovations.com/html/sqllinkce.html)

But why use access when you can use MSDE or SQL Express which provide a SQL Server database that can be sychronised with the SQL Server CE database on the device.

THE CHOICE IS YOURS !!! !!! !!!

[adeline]

1.can i use the normal sql server 2000 (not ce edition) for the db?
2. can i just use the desktop microsoft access? y i need sql server ce?
3.what is the 3rd party tools for?

thanks

[Strider]

1. Yes
2. Yes/No
3. Read the Websites and you will see


What type application are you trying to create?

[adeline]

im trying to create a mobile application using pocket pc. mobile expenses tracker, it basically have expenses and income. im using the vb .net2003 (create the interface for the pocket pc, take data in n out from database). then im tryin to use micosoft access as the db(to store the data, input n output of data to the emulator). as i know all this can be done, then i save the fila as .cab. is it true what has my fren told me?

[Strider]

1. Do you plan to store data on the Device? Yes or No? Why?
2. Is this application to work over WIFI or GRPS? Yes or No?
3. Or is this a Batch (collect lots of data before sync-ing) or Live application (updates backend database immidately)?

4. You said 3 posts ago you are no longer using the emulator, in the last post you said you are using the emulator. Which is it?

[adeline]

1. yes (coz when user enter their expenses today, the data need to be kept).
2. no, just using the cable.
3. i think live application coz when user enter the expenses on today, and user use another function tht to calculate total expenses for today, therefore the expenses on today need to be updated to calculate the total expenses.
4. today i confronted a lecturer, he said that on the emulator , i cant get the data from the database that i created . as the emulator cant access the data there.

[Strider]

1. If you need to store data on the device you will either have to use
a. SQL Server CE (best option)
b. XML
c. Store then in text files (prob csv)
d. Pocket Access (however you would need to use/purchase the ADOCE 3rd party tools, http://www.inthehand.com/ADOCE.aspx)

2. If the device is to be connected with a PC using ActiveSync, i'd recommend as an option: exporting the data from you access database on the PC to CSV files, then copy these across to the device (using ActiveSync or RAPI), then import the data into you the sql server ce database on the handheld

3. I'd highly recommend avoiding using the Pocket PC Emulator 2002, as it is very poor to use. Why cant you use the Pocket PC 2003 Emulator that comes with Visual Studio? You can copy data to the emulator & use SQL Server CE

4. Id recommend you maybe getting a book (http://www.amazon.com/gp/product/159...lance&n=283155)
so you can see all the options available to you

also READ the following articles as they may give you more insight
http://www.ondotnet.com/pub/a/dotnet...compactce.html
http://www.ondotnet.com/pub/a/dotnet...20.html?page=1

[adeline]

i dont understand sql server ce
really at all .....

[Strider]

You understand something by learning about it... Hence reading articles books etc...

http://msdn.microsoft.com/SQL/2000/SQLCE/default.aspx

What programming knowledge do you have? What experience?

It seems like your completely new to VB.Net

[adeline]

yes i am new to vb .net.
after reading also dunt understand, therefore i opt for simple db like microsoft access.
:~(

[Strider]

Yes for a newbie .Net can look a bit overwhelming.
But bear in mind everything you have read on this post... You know the options available to you!!! Now go lean about them.

There are plently of links provided to go learning

START HERE ..... http://samples.gotdotnet.com/quickst...pactFramework/