如何在保存到SQL数据库并检索以显示在标签内时保留换行符

我有一个文本区域,通过按enter,可以在多行中输入一些文本:

<asp:TextBox ID="tbMessage" runat="server" ClientIDMode="Static" 
     TextMode="MultiLine" Columns="30" Rows="5"></asp:TextBox>

我从代码隐藏保存文本( MessageText 列的类型为 varchar ):

using (SqlCommand qSave = new SqlCommand())
{
    qSave.Connection = oCon;
    qSave.CommandType = CommandType.Text;
    qSave.CommandText = @"INSERT INTO [Db1].[dbo].[Table1] (MessageText) VALUES (@MessageText)";
    qSave.Parameters.AddWithValue("@MessageText", tbMessage.Text);

    try
    {
        oCon.Open();
        qSave.ExecuteNonQuery();
    }
    catch (SqlException ce)
    {
    }
    finally
    {
        oCon.Close();
    }
}

我检索列并将其显示在代码后面的标签中:

public void MyFunction()
{
    strSql = @"SELECT * FROM [Db1].[dbo].[Table1]";

    using (SqlConnection conn = new SqlConnection(gloString))
    {
        try
        {
            // create data adapter
            SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
            // this will query your database and return the result to your datatable

            myDataSet = new DataSet();
            da.Fill(myDataSet);

            string specific = "";
            string generic = "";
            string strTemp = "";

            foreach (DataRow r in myDataSet.Tables[0].Rows)
            {
                if (r["MessageText"].ToString().Length <= 65)
                {
                    strTemp = r["MessageText"].ToString();
                }
                else
                {
                    strTemp = TruncateLongString(r["MessageText"].ToString(), 65) + "...";
                }

                specific += "<span class='hoverText tooltip' title='" + this.Server.HtmlEncode(r["MessageText"].ToString().Replace("\r\n", "<br />")) + "'>" + this.Server.HtmlEncode(strTemp) + "</span><span class='dvMsgInitHidden'>" + this.Server.HtmlEncode(r["MessageText"].ToString().Replace("\r\n", "<br />")) + "</span><br /><br />";
            }

            lblMessage.Text = specific;

            upMessage.Update();
        }
        catch (Exception ce)
        {
        }
    }
}

public string TruncateLongString(string str, int maxLength)
{
    return str.Substring(0, maxLength);
}

从下面的截图中可以看到 title 显示正确,但消息都混在一行中:

请帮我解决。