Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL VB.NET
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 3:55am
Edited 25-Jun-11 16:40pm
v3
Comments
Dalek Dave at 10-Dec-10 4:54am
   
Edited for Syntax and Readability.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 8

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.
  Permalink  
v2
Comments
   
This question is 1.5 years old. Why are you answering it?
Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  
Comments
jleonorlane at 30-Nov-10 8:59am
   
...yes a website database...
But how..?i really dont know about on it...
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

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[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 9

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[^]
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 320
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 Sergey Alexandrovich Kryukov 184
0 OriginalGriff 5,415
1 DamithSL 4,422
2 Maciej Los 3,820
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,911


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 25 Jun 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100