Click here to Skip to main content
16,017,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have a problem developing my final project.
Here's brief explanation about my project :

- I have a smartdeviec (PDA) running VB.Net based application
- I have a MySQL Database at web hosting (over the internet) which I need to connect to my PDA.
- My PDA can retrieve and show data (at table or datagrid, maybe)
- My PDA can send parameter for query to MySQL (so that i can select record from any table i want from decided form at my vb.net system.
e.g, I want to select customer live in Australia --> I open CustomerForm at my system, insert location = Australia at textfield, then submit it. The result is Customer live in Australia shown at table or datagrid.

But find it difficult to perform connection between my vb.net smartdevice project with MySQL.
I have tried create WebService, but when i run it on emulator PDA the record of database didn't shown up. The only things shown up is the header (Field name at Database table).

What I need is :
"How to perform connection between PDA (VB.Net) with MySQL, so ican do database manipulation (Insert, delete, update)"
I used :
VS2008
MySQL Connector.Net v5.2

Could anyone help me?
If you don't mind I need you to send me an email at [DELETED][at]gmail.com.


[edit]Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know - OriginalGriff[/edit]
Posted
Updated 22-May-11 21:01pm
v2

You need to ensure that your database has Remoting enabled: if it does than you should be able to connect to it via the domain name/IP (with the appropriate login info for the domain). See you Webhosting service - they should have details. Some MySQL installations do not allow this - particularly the free / cheap ones.

If your database does not support remoting, then you will need to provide a webpage to query the database as scrape the results out of that manually. Or change webhosts!
 
Share this answer
 
Comments
satrio_budidharmawan 23-May-11 3:13am    
It's done already abouot remoting the database.
Because when i tried to use asp to show the query result, it's ok.
But not in mobile device
Thanks everyone,finally I could perform the Connection.
But there're another problem again, I will write an question again.

Thanks a lot in advance
 
Share this answer
 
Comments
amirbalak 19-Mar-12 6:58am    
satrio..please help me..i need to settle my project about database manipulation (Insert, delete, update)in smart devices..if u can help me,send ur sample code to my email..argentata_49@yahoo.com

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900