Advertisement
IT45200

C# - MYSQL Connector

Mar 27th, 2019 (edited)
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.72 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using MySql.Data.MySqlClient;
  7.  
  8. namespace mySQL_connector
  9. {
  10.  
  11.     class DBConnector
  12.     {
  13.  
  14.         public static MySqlConnection
  15.                  GetDBConnection(string host, int port, string database, string username, string password)
  16.         {
  17.             // Connection String.
  18.             String connString = "Server=" + host + ";Database=" + database
  19.                 + ";port=" + port + ";User Id=" + username + ";password=" + password;
  20.  
  21.             MySqlConnection conn = new MySqlConnection(connString);
  22.  
  23.             return conn;
  24.         }
  25.  
  26.     }
  27.     class DBUtils
  28.     {
  29.         public static MySqlConnection GetDBConnection()
  30.         {
  31.             string host = "localhost";
  32.             int port = 3306;
  33.             string database = "myDatabase";
  34.             string username = "myUser";
  35.             string password = "myPassword";
  36.  
  37.             return DBConnector.GetDBConnection(host, port, database, username, password);
  38.         }
  39.  
  40.     }
  41.  
  42.  
  43.  
  44.     class Program
  45.     {
  46.  
  47.         public static MySqlConnection con;
  48.         static void Main(string[] args)
  49.         {
  50.  
  51.  
  52.             Console.WriteLine("Getting Connection ...");
  53.             MySqlConnection conn = DBUtils.GetDBConnection();
  54.  
  55.             try
  56.             {
  57.                 Console.WriteLine("Openning Connection ...");
  58.  
  59.                 conn.Open();
  60.  
  61.                 Console.WriteLine("Connection successful!");
  62.             }
  63.             catch (Exception e)
  64.             {
  65.                 Console.WriteLine("Error: " + e.Message);
  66.             }
  67.  
  68.             Console.Read();
  69.            
  70.        
  71.         }
  72.     }
  73. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement