?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
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;

public partial class BackDesk_ManageCard_Card : System.Web.UI.Page
{
    DataCon myCon = new DataCon();
    DataOperate sqlBind = new DataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection sqlconn = myCon.getCon();
            sqlconn.Open();
            string sqlstr = "select a.*,b.ModuleID,b.ModuleName from tb_Card as a "
               + "join tb_Module as b on a.ModuleID = b.ModuleID where a.CardID = '"
               + Request["CardID"].ToString() + "'";//接受CardInfo.aspx頁傳值
            SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, sqlconn);
            DataSet myDSCard = new DataSet();
            DataSet myDSModule = new DataSet();
            myAdapter.Fill(myDSCard, "tb_Card");
            myAdapter.Fill(myDSModule, "tb_Module");
            DataRowView rowViewCard = myDSCard.Tables["tb_Card"].DefaultView[0];
            DataRowView rowViewModule = myDSModule.Tables["tb_Module"].DefaultView[0];
            labCardContent.Text = Convert.ToString(rowViewCard["CardContent"]);
            labCardTitle.Text = "帖子標題：" + Convert.ToString(rowViewCard["CardName"]);
            labCardDate.Text = "發帖日期：" + Convert.ToString(rowViewCard["CardDate"]);
            labCardMod.Text = "帖子所屬模塊：" + Convert.ToString(rowViewModule["ModuleName"]);
            sqlconn.Close();
        }
    }
}