一.配置方法
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);
}
}