Wireless database synchronization and upload

  • Thread starter Thread starter Goran Djuranovic
  • Start date Start date
G

Goran Djuranovic

Hi all,
I need to create an application that will allow user to scan item and upload
its information to the SQL Server database wirelessly.
I am using:
- Visual Studio .NET 2003 (VB.NET)
- Pocket PC 2003 (Win CE 4.2)
- Symbol Scanner Extension

I can get the value read from the scanner but then what?
Can anyone point me to the right direction on how to start?
 
If you have a connection to the network via your wirleess and can see the
server, then you can just use standard command object constructs. I'm not
sure if you are wanting to send it all as a blob or parse the values from
the reader and send them individually..but assuming that you want to send
each of the items which maps to a filed in the DB you could just build a SQL
Statement set your command's commandtext to this string. Then you can
simply open your connection, fire an executenonquery and you should be good
to go. IF you want to do the blob approach, you'll need to use a stream but
the logic is essentially the same.

HTH,

Bill
 
William, this is what I really would like to do. I would like to be able to
scan item and store that value instantly to the SQL Server without storing
it on the device. I am not sure if I can, or have to, use SQL CE or
WebService, or something else. If you know of any sample application out
there that utilizes wireless uploading, please let me know.

Thanks for your response
Goran
 
Back
Top