I've been developing a stock control system using VS2003 & MS SQL 2005. Now I need to add the option to use Bar Code scanners.
The Bar Code Scanners are Windows CE5.0 devices with inbuilt wireless networking. I have upgraded to VS2005 for this project as I understand its better suited to this task, so am also getting used to new environment.
I can build & deploy an app that reads direct from the MS SQL DB. I've not installed SQL CE as I seem to be able to access the DB direct. I can fill a datagrid with the contents of a table, so that's all fine.
I want to be able to update the DB. The datagrid is editable, which I believe is the case - is that correct. I have added Text Boxes to the form, but there does appear to be a datasource option.
Problem is, I'm just not sure I'm approaching this correctly. Should I be installing SQL CE? Is there an updatable datagrid option?
I will be working in an environment where the wireless link may fail occassionally and so would like to store updates locally if no connection & then update in batch when I can get a connection. That sounds to me like writing to a local dataset & then performing an update() as & when. I guess I could create a form that adds / amends rows in the dataset & configure a data adapter to update the dataset - but is that the best approach.
I'm likely to be spending a lot of time in the near future on this project - so just after a 'heads up' really. Am I on the right lines? Any tips / advise greatly received.