Member Avatar for getz

Hi, I am new to vb.net and mysql. I am using Ms Visual Studio.NET 2003. After scan 2D barcode, it will retrieve information from mysql and display the info in Symbol Pocket Pc. The problem is I dont know how to connect the 2D barcode with MySQL in vb.net and display the info in Pocket Pc. I never do such project before. can someone help me?Thanks in advance..

  • 2 Contributors
  • 2 Replies
  • 125 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by getz

Dani AI

Generated

pointed to general ADO/SQLServer material, but for (VS.NET 2003 + Pocket PC + Symbol scanner + MySQL) the practical, reliable pattern is: have the Pocket PC send the scanned code to a server-side service that talks to MySQL, then return results to the device. Direct DB connections from a Pocket PC are fragile (no Connector/NET support for many CF setups, firewall/NAT issues, and security risks).

Minimal workflow

  • Scanner input: simplest first — configure the Symbol scanner as a keyboard wedge so the scanned code populates a TextBox on the device. Handle the Enter/Return or TextChanged to trigger lookup.
  • Server: implement a small web service (ASMX, ASP.NET page, or a tiny REST endpoint in PHP) that accepts the barcode, queries MySQL with parameterized SQL, and returns a compact result (XML, JSON, or a pipe-delimited string).
  • Device client: call that service. In VS2003 you can add a Web Reference to an ASMX service (auto-generated proxy) or use a simple HttpWebRequest to GET/POST and parse the response. Always run network calls off the UI thread.

Example server-side (ASMX + Connector/NET) and client usage are good next steps. For the server use parameterized queries and keep DB credentials server-side only. On the device, test reachability first by loading the service URL in the device browser or pinging the server IP.

Troubleshooting and cautions

  • Verify network (Wi-Fi) and firewall settings; test with the desktop browser first.
  • If scanner SDK is needed (more control than wedge), use the Symbol/Motorola SDK matching the device — only use SDK APIs if keyboard wedge cannot be used.
  • Validate inputs and use parameterized queries to avoid SQL injection.
  • Consider HTTPS or simple token auth if the link crosses untrusted networks.

This approach keeps the device code simple, avoids unsupported drivers on the CF, and is the most maintainable for a VS2003 / Pocket PC solution.

Recommended Answers

All 2 Replies

Member Avatar for getz

tq 4 de help. do you know how to connect the barcode that has been scanned to Mysql in order to retrieve info from it(Mysql)? Right now my problem is to connect the value of scanned barcode to mysql.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.