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

public?partial?class?show?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{
????????????bind（）;
????????}

????}
????public?void?bind（）
????{
????????SqlConnection?con?=?new?SqlConnection（“Data?Source=（local）;Initial?Catalog=telsystem;Integrated?Security=True“）;
????????con.Open（）;
????????string?strid?=?Page.Request.QueryString[“序號“];
????????string?sqlstr?=?“select?*?from?activity_table?where?序號=‘“?+?strid?+?“‘“;
????????SqlDataAdapter?myda?=?new?SqlDataAdapter（sqlstr?con）;
????????DataSet?myds?=?new?DataSet（）;
????????myda.Fill（myds?“activity_table“）;
????????DataRowView?mydv?=?myds.Tables[“activity_table“].DefaultView[0];
????????Label2.Text?=?Convert.ToString（mydv.Row[“標題“]）;
????????Label3.Text?=?Convert.ToString（mydv.Row[“時間“]）;
????????Label5.Text?=?Convert.ToString（mydv.Row[“活動簡介“]）;
????????Label7.Text?=?Convert.ToString（mydv.Row[“參與方式“]）;
????????Label9.Text?=?Convert.ToString（mydv.Row[“活動時間“]）;
????????Label11.Text?=?Convert.ToString（mydv.Row[“哪些客戶可參與“]）;
????????Label13.Text?=?Convert.ToString（mydv.Row[“活動內容“]）;
????????Label15.Text?=?Convert.ToString（mydv.Row[“溫馨提示“]）;
????????con.Close（）;
????}
}