How to connect MYsql with .net

Question

Hi to all how to use MYSQL data base in my .net project which is requirment for connect to mysql database plz help me thanks

Sam Hobbs · Answer

Go to MySQL . Click on the Downloads tab near the top. Scroll down until you see something relevant. It's that easy; if you did that before writing this question, you would have had the download in the amount of time it took for you to create this question.

Imran Pervez · Answer

1. first search and download from net "mysql-connector-net-1.0.10.1" OR "mysql-connector-net-6.1.4" library and install it your system 2. Add Reference "MySql.data" in your project 3. I send some code may be help full for u using MySql.Data.MySqlClient; MySqlConnection connection; //open connection if (this.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); //close connection this.CloseConnection(); }

How to connect MYsql with .net

Answers (2)