[Resolved] Simple application without remote access

[karahim]

Hi

I wish to develop an application for Pocket PC, that have Windows CE, I need to:
- Upload data from PC to Pocket PC using ActiveSync
- Maintain data on Pocket PC using Pocket PC database (SQL CE, or whatever)
- Download data to PC from Pocket PC using ActiveSync

SQL CE requires IIS, my Pocket PC application does not require any online interaction with any other server or device. Is it necessary to install IIS or SQL CE to achieve my objective?

I am trying to create a Smart Device Application on VB .Net, the toolbox of design environment is not showing the Data Controls. What controls I should use for database handling?

Please guide me for this.

Thanks

karahim

[Shaggy Hiker]

I think you will have a harder time NOT installing SQL CE. It seems to install itself whenever you are using a PDA as a test platform. I have not heard about needing IIS on the PDA, but I have never dealt with it, either. SQL CE is a pretty good database for use on the PDA, so you might as well use it.

What form of data are you uploading?

[Strider]

-sqlce only requires IIS when using Remote Data Access (RDA), and IIS will be installed on a server.
-sqlce is free for the device, i.e: no licencing required

-in Compact framework you need to code all your database handling
look here -> http://samples.gotdotnet.com/quickst...pactFramework/ for code examples

[karahim]

Thanks Shaggy Hiker and Strider for your replies.

From a document on internet i read that IIS needs to be installed on server before installing SQLCE on handheld, that is what i was trying to get clarification on it. Now it is understood from Strider's reply that IIS is not required if not using remote access.

Shaggy, data that i was talking about are a number of SQL tables having codes and description columns in it, which i have to populate in combo boxes of my handheld application.

Strider, site that you mentioned seems to be very helpful for me.
I learnt from somewhere that to install SQLCE on handheld, include SQL Server CE in your project, on the Project menu, click Add Reference, and select System.Data.SqlServerCe. I followed this but data control is still not appearing in form desining environment.

It would be great if you could provide me a sample code that suits my situation.

Regards

karahim

[Strider]

These are samples only, copying and pasting these samples may need some changes

There are no data designer tools in the compact framework everything is done by code, which is much better

'creating connection to database
Dim l_conn As New New SqlCeConnection("Data Source=\My Documents\test.sdf"
 
'Creating a table
Dim l_sqlcmd As SqlCeCommand = l_conn.CreateCommand()
 
l_sqlcmd.CommandText = "Create TABLE tbl_Customers(CustomerNo int PRIMARY KEY, CustomerName nvarchar(30), Addr1 nvarchar(30), Addr2 nvarchar(30), Addr3 nvarchar(30), Addr4 nvarchar(30))"
l_sqlcmd.ExecuteNonQuery()
 
'Executing SQL Command
Dim sqlcmd As SqlCeCommand = l_conn.CreateCommand()
sqlcmd .CommandType = CommandType.Text
sqlcmd.CommandText = "SELECT * FROM tbl_Customers
sqlcmd.ExecuteNonQuery()
'or
sqlcme.ExecuteScalar()
'or 
Dim l_dr As DataReader
l_dr = sqlcmd.ExecuteNonQuery()
 
'using dataadapter
Dim sqlDA As SqlCeDataAdapter
Dim ds As New DataSet
 
'Select everything from the table.
sqlDA = New SqlCeDataAdapter("SELECT * FROM tbl_Customers, l_conn)
 
'Fill the DataTable within the DataSet.
sqlDA.Fill(ds, "DataSet")

[karahim]

Thanks alot Strider for sample code.