Connect to a website database from VB.NET app

Question

0.00/5 (No votes)

See more:

Hello guys,

I want my desktop application to connect in Website database (MySQL Database is used).

Will I use the website URL, e.g., http://www.codeproject.com as my host?

Please help.

Thanks in advance.

Posted 30-Nov-10 2:55am

jleonorlane

Updated 25-Jun-11 15:40pm

Deeksha Shenoy

v3

Add a Solution

Comments

Dalek Dave 10-Dec-10 4:54am

Edited for Syntax and Readability.

5 solutions

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)

Abdelrahman Tarek · Answer 1 · 2011-06-24T23:50:00

TRY this CODE in VB ..

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        WebBrowser1.Navigate("http://login.website.co/")
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        WebBrowser1.Document.GetElementById("login").SetAttribute("value", TextBox1.Text)
        WebBrowser1.Document.GetElementById("passwd").SetAttribute("value", TextBox2.Text)

        WebBrowser1.Document.GetElementById(".save").InvokeMember("click")
    End Sub

End Class

(Register from the website and login from the program suitable for online gaming.)
(Or you can put a small webbrowser inside your program and just when you click "Login", it will load and log into your website.)

For the "Login" and "passwd" 6-7 line in the code, you need to edit the HTML code of the website by using a webbrowser like Internet Explorer, Mozzila, Opera, etc. and see if they are the same or not, if not just copy and replace them in the code.

If you have more problems, just contact me on Cassanovazzz@live.com or facebook.com/Bo00oDy.

Rajesh Anuhya · Answer 2 · 2010-11-30T02:58:00

Solution 1

what do you mean by website database..,

You mean that database is located in another server, that have a public IP., if yes change the host address with that public IP.

Posted 30-Nov-10 2:58am

Rajesh Anuhya

Comments

jleonorlane 30-Nov-10 8:59am

...yes a website database...
But how..?i really dont know about on it...

Gregory Gadow · Answer 3 · 2010-11-30T03:09:00

There is no such thing as a "website database."

Assuming you really mean "How do I connect to a web service that provides data," the only possible answer is "Consult with the documentation and/or help desk of the company that is providing the data." Connecting and communicating with a web service depends on how the interface contracts are written; there is no one-size-fits-all answer. As far as writing a web service, that is a very complicated process with no simple answer. There are several examples here at Code Project that you can reference, and plenty of text books and other resources.

Prerak Patel · Answer 4 · 2010-12-09T22:35:00

Solution 7

You may require the port which is being used for mySQL on your server, if it's not the default one.

http://www.connectionstrings.com/mysql[^]

Posted 9-Dec-10 22:35pm

Prerak Patel

Simon_Whale · Answer 5 · 2011-06-25T11:46:00

Firstly make sure that you have downloaded the MySql Connector package found here Download the ADO.NET Driver for MySQL (Connector/NET) [^]

A good place to read about connection strings is as follows MySql Connection Strings[^]

Examples of MySQl Data connections can be found here MySQL connection example[^]

Connect to a website database from VB.NET app

5 solutions

Solution 8

Solution 1

Solution 2

Solution 7

Solution 9

Add your solution here

Preview 0