ASP.NET读取设置Web.config文件--数据库

一.配置方法

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);
                }
            }