【C#与MYSQL】在VS中使用MYSQL connect Net 连接本地MYSQL

淩亂°似流年 2022-02-26 03:52 237阅读 0赞

【步骤描述】

1、建立VC工程，把MYSQL装好，数据准备好

2、安装好MYSQL connect Net

3、在工程中引用MYSQL数据库对象

4、在代码中写连接和查询的语句

【在工程中引用MYSQL数据库对象】

![Image 1][]![20130505210135568][]![20130505210145983][]

![Image 1][]

【在代码中写连接和查询的语句】

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.Mvc;
    
    using MySql.Data.MySqlClient;		//使用连接和操作MySQL的方法，必须应用MySql.Data.MySqlClient
    
    namespace FirstMVC2Prj.Controllers
    {
        [HandleError]
        public class HomeController : Controller
        {
            public ActionResult Index()
            {
    
                String myInfo = "欢迎使用 ASP.NET MVC! ";
    
                ///获取MYSQ看数据返回值
                MySqlConnection myconn = null;
                MySqlCommand  mycom = null;
                MySqlDataReader myrec = null;
    
                //连接字符串拼装
                myconn = new MySqlConnection("Host = localhost;Database = test;Username = root;Password = fulei");
    
                //连接
                myconn.Open();
    
                if(myconn.State.ToString()=="Open")
                {
                    myInfo = myInfo + "<br> 连接MYSQL成功";
                }
                
                //查询命令赋值，可以写多条语句，多条语句之间用;号隔开
                mycom = new MySqlCommand("select * from persioninfo",myconn);
    
                myrec = mycom.ExecuteReader();
    
                //一次次读，读不到就结束
                while (myrec.Read())
                {
                    myInfo = myInfo + myrec["name"] + " " + myrec["sex"];
                }
    
                //关闭相关对象
                myrec.Close();
                myconn.Close();
    
                /获取MYSQ看数据返回值
    
                 ViewData["Message"] = myInfo;
    
                return View();
            }
    
            public ActionResult About()
            {
                return View();
            }
        }
    }

[Image 1]: 
[20130505210135568]: https://img-blog.csdn.net/20130505210135568
[20130505210145983]: /images/20220226/a9618e6210db4353a3d6d9795286afc3.png