Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using MySql.Data.MySqlClient;
- namespace mySQL_connector
- {
- class DBConnector
- {
- public static MySqlConnection
- GetDBConnection(string host, int port, string database, string username, string password)
- {
- // Connection String.
- String connString = "Server=" + host + ";Database=" + database
- + ";port=" + port + ";User Id=" + username + ";password=" + password;
- MySqlConnection conn = new MySqlConnection(connString);
- return conn;
- }
- }
- class DBUtils
- {
- public static MySqlConnection GetDBConnection()
- {
- string host = "localhost";
- int port = 3306;
- string database = "myDatabase";
- string username = "myUser";
- string password = "myPassword";
- return DBConnector.GetDBConnection(host, port, database, username, password);
- }
- }
- class Program
- {
- public static MySqlConnection con;
- static void Main(string[] args)
- {
- Console.WriteLine("Getting Connection ...");
- MySqlConnection conn = DBUtils.GetDBConnection();
- try
- {
- Console.WriteLine("Openning Connection ...");
- conn.Open();
- Console.WriteLine("Connection successful!");
- }
- catch (Exception e)
- {
- Console.WriteLine("Error: " + e.Message);
- }
- Console.Read();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement