?? card.aspx.cs
字號:
?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();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -