ashx读写MySql数据库

using MySql.Data.MySqlClient;

MySqlConnection con = new MySqlConnection();

/// <summary>
/// 数据库连接配置
/// </summary>
public void OpenDatabase()
{
    con.ConnectionString = "Data Source=连接地址;User ID=登录名;Password=密码;DataBase=数据库名称";
    con.Open();
}

/// <summary>
/// 查询contents表
/// </summary>
/// <returns></returns>
public string GetContents() {
    string Body = "";
    OpenDatabase();
    MySqlCommand cmd = new MySqlCommand("SELECT * FROM contents", con);
    MySqlDataReader dr = cmd.ExecuteReader();
    //循环数据
    while (dr.Read())
    {
        Body += dr["title"].ToString()+"\n";
    }
    dr.Close();
    con.Close();
    return Body;
}