- 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.");
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/2303201511953.html
来源: http://www.codesnippet.cn/detail/2303201511953.html