Default.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        showDay.Text = MyCalendar.SelectedDate.ToLocalTime().ToShortDateString().ToString();
    }
    public string GetTable()
    {

        SqlData da = new SqlData();
        string strCmd = "select * from Diary order by DateTime desc";
        SqlDataReader sdr = da.ExceRead(strCmd);
        string strTable = null;
        strTable = "<Table class=read>";
        while (sdr.Read())
        {
            strTable += "<tr><th style=width: 100px; height: 17px>标题：</th><th style=width: 100px; height: 17px>" + sdr["Title"].ToString() + "</th></th>";

            strTable += "<tr><td style=width: 100px; height: 17px>内容：</td><td style=width: 100px>" + sdr["Body"] + "</td></tr>";
            strTable += "<tr><td style=width: 100px; height: 17px>发表时间：</td><td style=width: 100px>" + sdr["DateTime"] + "</td></tr>";
        }
        strTable += "</Table>";
        return strTable;
    }
}