How to connect to MySQL Database

Question

New to C  programming  I d like to be able to access MySQL Databases   I know MySQL connector NET and MySQL for Visual Studio are required for C  development   Do I need to install them into my app   Is it possible I can just release the connector DLL with the program  Update   Are both of them required for the end-user or just the connector   Is there anything else they would need

User · Answer

Another library to consider is MySqlConnector  https   mysqlconnector net   Mysql Data is under a GPL license  whereas MySqlConnector is MIT

User · Answer

You must to download MySQLConnection NET from here   Then you need add MySql Data DLL to MSVisualStudio like this    Open menu project Add  Reference Browse to C  Program Files  x86  MySQL MySQL Connector Net 8 0 12 Assemblies v4 5 2 Add MySql Data dll   If you want to know more visit  enter link description here  To use in the code you must import the library   using MySql Data MySqlClient    An example with connectio to Mysql database  NO SSL MODE  by means of Click event    using System  using System Windows  using MySql Data MySqlClient    namespace Deportes WPF    public partial class Login   Window       private MySqlConnection connection      private string server      private string database      private string user      private string password      private string port      private string connectionString      private string sslM       public Login                 InitializeComponent             server    server name           database    database name           user    user id           password    password           port    3306           sslM    none            connectionString   String Format  server  0  port  1  user id  2   password  3   database  4   SslMode  5    server  port  user  password  database  sslM            connection   new MySqlConnection connectionString              private void conexion                 try                       connection Open                 MessageBox Show  successful connection                 connection Close                      catch  MySqlException ex                        MessageBox Show ex Message   connectionString                        private void btn1 Click object sender  RoutedEventArgs e                conexion

User · Answer

Install Oracle s MySql Data NuGet package  using MySql Data  using MySql Data MySqlClient   namespace Data       public class DBConnection               private DBConnection                                public string Server   get  set            public string DatabaseName   get  set            public string UserName   get  set            public string Password   get  set             private MySqlConnection Connection   get  set            private static DBConnection  instance   null          public static DBConnection Instance                         if   instance    null                   instance   new DBConnection               return  instance                         public bool IsConnect                         if  Connection    null                                if  String IsNullOrEmpty databaseName                       return false                  string connstring   string Format  quot Server  0   database  1   UID  2   password  3  quot   Server  DatabaseName  UserName  Password                   Connection   new MySqlConnection connstring                   Connection Open                                   return true                         public void Close                         Connection Close                               Example  var dbCon   DBConnection Instance    dbCon Server    quot YourServer quot   dbCon DatabaseName    quot YourDatabase quot   dbCon UserName    quot YourUsername quot   dbCon Password    quot YourPassword quot   if  dbCon IsConnect            suppose col0 and col1 are defined as VARCHAR in the DB     string query    quot SELECT col0 col1 FROM YourTable quot       var cmd   new MySqlCommand query  dbCon Connection       var reader   cmd ExecuteReader        while reader Read                  string someStringFromColumnZero   reader GetString 0           string someStringFromColumnOne   reader GetString 1           Console WriteLine someStringFromColumnZero    quot   quot    someStringFromColumnOne             dbCon Close

User · Answer

private void Initialize                 server    localhost           database    connectcsharptomysql           uid    username           password    password           string connectionString          connectionString    SERVER     server          DATABASE              database          U enter code here ID     uid          PASSWORD     password                 connection   new MySqlConnection connectionString

User · Answer

you can use Package Manager to add it as package and it is the easiest way to do  You don t need anything else to work with mysql database    Or you can run below command in  Package Manager Console  PM gt  Install-Package MySql Data   NUGET Mysql Data

User · Answer

Looking at the code below  I tried it and found  Instead of writing DBCon    DBConnection Instance    you should put DBConnection DBCon - new DBConnection     That worked for me   and instead of MySqlComman cmd   new MySqlComman query  DBCon GetConnection     you should put MySqlCommand cmd   new MySqlCommand query  DBCon GetConnection      it s missing the d

[c#] How to connect to MySQL Database?

Examples related to c#

Examples related to mysql

Examples related to nuget-package

Examples related to mysql-connector