.net 如何连接mysql

﹏ヽ暗。殇╰゛Y 2022-02-04 05:36 366阅读 0赞

序言：之前一直做JAVA的，没有尝试过做.net。但是由于需要，尝试用.net去连mysql;

第一步安装驱动：

驱动地址：[http://download.csdn.net/detail/zhengyong15984285623/5596241][http_download.csdn.net_detail_zhengyong15984285623_5596241]

mysql-connector-net-6.6.5.msi

该为mysql与,net的驱动；（安装后进行下一步操作）

第二步:新建一个网站。选择 “网站”--> “添加引用”--> .NET”-->MySql.Data

![20130529163548615][]

![20130529163747628][]

使用：

1. 在网页的.cs文件中引用using MySql.Data.MySqlClient;文件头

2.在web.config.xml中配置数据源

3. 程序中获取数据源操控数据库：

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using MySql.Data.MySqlClient;
    using System.Configuration;
    
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //创建connnetction
            MySqlConnection myConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString);
            myConnection.Open();
            string insert = "insert into tuser(id,username,password) values('001','admin','123456')"; 
            MySqlCommand myCommand = new MySqlCommand(insert, myConnection);
            myCommand.ExecuteNonQuery();             
            string query = "select * from tuser";       
            myCommand = new MySqlCommand(query, myConnection);     
            MySqlDataReader myDataReader = myCommand.ExecuteReader();       
            string user = "";         
            while (myDataReader.Read() == true)        
            {              
                user += myDataReader["username"];          
                user += myDataReader["password"];         
            }            
            myDataReader.Close();     
            myConnection.Close();
            Label1.Text = user;
        }
    }

[http_download.csdn.net_detail_zhengyong15984285623_5596241]: http://download.csdn.net/detail/zhengyong15984285623/5596241
[20130529163548615]: /images/20220204/6000fc622ed4409da09f001f47cb6267.png
[20130529163747628]: /images/20220204/192022ab473a412f8193794644229a28.png