C# 連接 MySQL 數據庫的代碼

using System;
using System.Data;

class MySqlConnect
   {
      static void Main()
      {
         string connString = @"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false";
         MySqlConnection conn = new MySqlConnection(connString);

     try
     {
        conn.Open();
        Console.WriteLine("Connection opened.");

        Console.WriteLine("Connection Properties:");  
        Console.WriteLine("\tConnection String: {0}",conn.ConnectionString);   
        Console.WriteLine("\tDatabase: {0}",conn.Database);  
        Console.WriteLine("\tServerVersion: {0}",
           conn.ServerVersion);
        Console.WriteLine(
           "\tState: {0}",
           conn.State);
     }
     catch (MySqlException e)
     {
        Console.WriteLine("Error: " + e); 
     }
     finally
     {
        conn.Close();
        Console.WriteLine("Connection closed.");
     }
  }

}</pre>