VB.Net + MySQL (Connection and database manipulation through smart device)

Question

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 22-May-11 18:54pm

satrio_budidharmawan

Updated 22-May-11 21:01pm

OriginalGriff

v2

Add a Solution

2 solutions

Solution 1

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!

Posted 22-May-11 21:06pm

OriginalGriff

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

satrio_budidharmawan · Accepted Answer · 2011-06-05T21:57:00

Solution 2

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

Posted 5-Jun-11 21:57pm

satrio_budidharmawan

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