how do i connect to mysql database using c#?

Question

how do i connect to Mysql database using c#?

i have this code

entstring MyConnection = "server=localhost; port=3306; databae=database_name; uid=root;pwd=;sslMode=None; ;

You can find thousands of guide for this. Please read https://stackoverflow.com/help/how-to-ask before asking. — Muhammad Saqlain, Mar 17 '17 at 10:19
Quite broad, you could use ODBC, OLEDB, MySQL .NET connector... Have you tried anything besides writting the connection string? — Cleptus, Mar 17 '17 at 10:26
i was just trying to get my code out cause i struggled with it during my project...my connection wasnt working cause my sslMode wasn't indicated — jastrupgeeky, Mar 17 '17 at 10:34
Possible duplicate of [How to connect to MySQL Database?](http://stackoverflow.com/questions/21618015/how-to-connect-to-mysql-database) — Marek Urbanowicz, Mar 17 '17 at 11:00
Possible duplicate of [MySQL Connection String C#](http://stackoverflow.com/questions/25651318/mysql-connection-string-c-sharp) — Mantas Čekanauskas, Mar 17 '17 at 11:19

score 1 · Answer 1 · answered Mar 17 '17 at 10:30

First download MySql.Data package from nuget package manager then add namespace

//Add MySql Library
using MySql.Data.MySqlClient;

Connection Code-

string connString = "server=server;user=user;database=db;password=*****;";
MySqlConnection con = new MySqlConnection(connString);

score 0 · Answer 2 · answered Mar 17 '17 at 10:29

this is an idea .

string MyConnection = "server=localhost; port=3306; databae=database_name; uid=root;pwd=;sslMode=None; ;

string Query =  "INSERT INTO table_name(username,password)VALUES('"+textbox_name.Text+"','"+password_name.Password+"');
MySqlConnection con = new MySqlConnection(MyConnection);
MySqlCommand command = new MySqlCommand(Query,con);
con.open();
try{
command.ExcuteNonQuery();

}

    catch(Expection ex)

{

MessageDialog box = new MessageDialog(ex.ToString());
box.ShowAsync();

}

con.close();

}

how do i connect to mysql database using c#?

2 Answers2