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 stackoverflow.com/help/how-to-ask before asking.Muhammad Saqlain– Muhammad Saqlain2017-03-17 10:19:36 +00:00Commented Mar 17, 2017 at 10:19
-
Quite broad, you could use ODBC, OLEDB, MySQL .NET connector... Have you tried anything besides writting the connection string?Cleptus– Cleptus2017-03-17 10:26:08 +00:00Commented Mar 17, 2017 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 indicatedjastrupgeeky– jastrupgeeky2017-03-17 10:34:38 +00:00Commented Mar 17, 2017 at 10:34
-
5Possible duplicate of How to connect to MySQL Database?Marek Urbanowicz– Marek Urbanowicz2017-03-17 11:00:17 +00:00Commented Mar 17, 2017 at 11:00
-
Possible duplicate of MySQL Connection String C#Mantas Čekanauskas– Mantas Čekanauskas2017-03-17 11:19:42 +00:00Commented Mar 17, 2017 at 11:19
|
Show 1 more comment
2 Answers
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);
Comments
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();
}