Hello friends ? I want to use mysql database in vb.net ..
What is the full procudure for using mysql in vb.net..
thanks in advance......
yusuf.business -3 Newbie Poster
Oxiegen 88 Basically an Occasional Poster Featured Poster
Well, first of all you'll need the Mysql Connector/NET.
You will find it here.
Second, everything you've read so far about connecting to an MS SQL server, either here or elsewhere, you can apply when dealing with MySQL.
All you have to do is replace any reference to SqlConnection, SqlCommand and so on, with MySqlConnection, MySqlCommand and so on.
Also, the connectionstring is different: check this site.
finito 46 Nearly a Posting Virtuoso
If you want a good read and full explaination I suugest you check the following links with explainations.
http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-2
http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3/
yusuf.business -3 Newbie Poster
thanks friend very very much .......
but it is necessary to install mysql server....
Is mysql connector along will not work ....
Oxiegen 88 Basically an Occasional Poster Featured Poster
Well.
If you already have a MySQL server somewhere, then the MySQL connector is enough for the connection.
finito 46 Nearly a Posting Virtuoso
You need MySql Server instructions?
What OS?
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.