一.配置方法

1. 添加 MySql 引用

2.C#读取web.config文件信息

在 web.config 文件中可以宏定义设置数据库配置

<?xml version="1.0"?> <!-- 有关如何配置 ASP.NET 应用程序的详细信息，请访问 http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration> <appSettings> <add key="name" value="name1"/> </appSettings> </configuration>

Eg:

<appSettings> <add key="ConnectionString" value="Database='mytest';Data Source=localhost;User ID=root;Password=;CharSet=utf8"/> </appSettings>

3.C#读取

string name = System.Web.Configuration.WebConfigurationManager.AppSettings[“name”];

Eg:

string connectionString = System.Web.Configuration.WebConfigurationManager.

4.C#设置

System.Web.Configuration.WebConfigurationManager.AppSettings.Set("name", "name2");

---

---

---

二.在 Controller 文件方法中调用数据库如下:

string connectionString = System.Web.Configuration.WebConfigurationManager.AppSettings["ConnectionString"]; //获取数据库 string queryString = "SELECT Name FROM student"; using (MySqlConnection connection = new MySqlConnection(connectionString)) //连接数据库 { MySqlCommand command = new MySqlCommand(queryString, connection); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) {//使用DataReader对象保存读取的数据 return Json(new { msg=reader.Read()},JsonRequestBehavior.AllowGet); } }