c#学习（一）--连接Mysql数据库的方式

一、纯代码连接

1、找到Mysql按照目录搜索MySql.Data.dll 找到MySql.Data.dll位置

2、添加MySql.Data.dl引用。

3、编写代码

using System.Data.SqlClient;
using MySql.Data.MySqlClient;

namespace _01AdoNetCourse
{
    class Program
    {
        static void Main(string[] args)
        {
            //SqlConnection connection = new SqlConnection();
            //string connStr = "server=.;database=newsdb;uid=root;pwd=123456";
            string sql_ip = "127.0.0.1";  //IP
            string sql_port = "3306"; //端口号
            string sql_user = "root";  //用户名  
            string sql_pw = "123456";  //密码
            string sql_name = "newsdb"; //数据库名
            string sql_con_state = "off";  //连接状态
            string connectionString = "server = " + sql_ip + "; userid = " + sql_user + "; password = " + sql_pw + "; database =" + sql_name + "; persistsecurityinfo = True;SslMode=None ;Charset=utf8;";
            MySqlConnection connection = new MySqlConnection(connectionString);
            connection.Open();
            Console.WriteLine("==================数据库连接成功==============================");//打印信息
            Console.ReadLine();
            connection.Close();
        }
    }
}

4、运行测试

5、成功

二、配置文件配置
1、同样引入MySql.Data.dll引用

2、添加System.Configuration引用
3、配置App.config 数据库

<connectionStrings>
		<add name="conStri" connectionString="server=localhost;database=newsdb;uid=root;pwd=123456" providerName="MySql.Data.MySqlClient"/>
	</connectionStrings>

4、编写代码连接

 MySqlConnection connection = new MySqlConnection();

            string str = ConfigurationManager.ConnectionStrings["conStri"].ConnectionString;
            connection.ConnectionString = str;
             connection.Open();
            Console.WriteLine("连接成功");
            Console.ReadLine();
            connection.Close();

5、启动

6、成功