用c#连接MySQL数据库需要用到mysql-connector-net,这个组件网上查找就可以下载,安装直接按next,按默认路径安装。
using System;
using System.Data;
using MySql.Data.MySqlClient;
namespace mysql_test
{
class Program
{
private static bool IsCanConnectioned = false;
public static void Main(string[] args)
{
Console.WriteLine("开始测试连接mysql数据库!");
//以下三种方式都是可以的
//MySqlConnection connection=new MySqlConnection("Host =localhost;Database=TD_OA;Username=root;Password=myoa888;Port=3336");
//MySqlConnection connection=new MySqlConnection("Server=127.0.0.1;Database=TD_OA;Uid=root;Pwd=myoa888;Port=3336");
MySqlConnection connection=new MySqlConnection("server=localhost;user id=root;password=myoa888;database=TD_OA;Port=3336");
try
{
//Open DataBase
//打开数据库
connection.Open();
IsCanConnectioned = true;
Console.WriteLine("连接成功1!");
String query1="select * from user";
MySqlCommand mySqlCmd=connection.CreateCommand();
mySqlCmd.CommandType=CommandType.Text;
mySqlCmd.CommandText=query1;
MySqlDataReader mySqlReader;
mySqlReader=mySqlCmd.ExecuteReader();
while(mySqlReader.Read()){
Console.WriteLine(mySqlReader[4].ToString());
Console.WriteLine(mySqlReader["USER_NAME"].ToString());
}
}
catch
{
//Can not Open DataBase
//打开不成功 则连接不成功
IsCanConnectioned = false;
}
if(IsCanConnectioned){
Console.WriteLine("连接成功2!");
}
connection.Close();
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
}
}
}