C# 连接 MySQL 数据库的代码

c#
2015-05-02 0 784
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.");
         }
      }
   }

遇见资源网 c# C# 连接 MySQL 数据库的代码 http://www.ox520.com/12110.html

常见问题

相关文章

发表评论
暂无评论
官方客服团队

为您解决烦忧 - 24小时在线 专业服务