| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
bdnp
9年前发布

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.");           }        }     }