using?System;
using?System.Collections;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;

public?partial?class?database_dataGridTest?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{
????????????bindNotice（）;
????????}
????}
????protected?void?bindNotice（）
????{
????????string?sqlStr;
????????sqlStr?=?“select?n.*u.RealName?from?KESHE_notice?nUserInfo?u?where?u.UserName=n.Uploader“;
????????DataTable?dt?=?PubClass.GetDsFromSql（sqlStr）.Tables[0];
????????dgNotice.DataSource?=?dt;
????????dgNotice.DataBind（）;
????}
????protected?void?dgNotice_PageIndexChanged（object?source?DataGridPageChangedEventArgs?e）
????{
????????dgNotice.CurrentPageIndex?=?e.NewPageIndex;
????????bindNotice（）;
????}
????protected?void?dgNotice_DeleteCommand（object?source?DataGridCommandEventArgs?e）
????{
????????string?NoticeID?=?dgNotice.DataKeys[e.Item.ItemIndex].ToString（）;
????????string?sqlStr;
????????sqlStr?=?“delete?from?KESHE_notice?where?NoticeID=‘“?+?NoticeID?+?“‘“;
????????if?（PubClass.ExecuteSql（sqlStr））
????????{
????????????bindNotice（）;
????????}
????}
????protected?void?dgNotice_SelectedIndexChanged（object?sender?EventArgs?e）
????{
????????//綁定用戶信息詳情
????????int?index?=?dgNotice.SelectedIndex;
????????string?uploader?=?dgNotice.Items[index].Cells[4].Text.Trim（）;
????????bindUserInfo（uploader）;
????}
????protected?void?bindUserInfo（string?UserName）
????{
????????string?sqlStr;
????????sqlStr?=?“select?*?from?UserInfo?where?UserName=‘“?+?UserName?+?“‘“;
????????DataTable?dtUser=PubClass.GetDsFromSql（sqlStr）.Tables[0];
????????lblUserInfo.Text?=?“姓名：“?+?dtUser.Rows[0][“RealName“].ToString（）?+?“——聯(lián)系電話：“?+?dtUser.Rows[0][“Tel“].ToString（）?+?“——家庭住址：“?+?dtUser.Rows[0][“Address“].ToString（）;
????}
????protected?void?dgNotice_ItemDataBound（object?sender?DataGridItemEventArgs?e）
????{
????????//刪除數(shù)據(jù)提示
????????linkButton?hint?=?e.Item.FindControl（“sct“）?as?linkButton;
????????if?（hint?!=?null）
????????{
????????????hint.Attributes.Add（“onclick“?“var?d?=?‘您確定要刪除該新聞嗎？‘;return?window.confirm（d）;“）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1487??2018-06-23?20:40??keshe\App_Code\PubClass.cs

?????文件????5242880??2018-06-23?20:39??keshe\App_Data\KESHEMIS.mdf

?????文件????2097152??2018-06-23?20:39??keshe\App_Data\KESHEMIS_log.ldf

?????文件???????6190??2018-06-21?10:24??keshe\App_themes\Indexstyle.css

?????文件????????549??2018-06-21?09:32??keshe\App_themes\responsive.css

?????文件???????2915??2014-01-07?10:58??keshe\App_themes\responsiveslides.css

?????文件???????2168??2016-01-15?16:09??keshe\App_themes\zerogrid.css

?????文件???????5268??2017-07-05?15:03??keshe\css\common.css

?????文件???????1645??2017-07-05?15:03??keshe\css\css.css

?????文件??????11771??2017-07-05?15:03??keshe\css\index.css

?????文件????????330??2017-07-05?15:03??keshe\css\kjyIndex.css

?????文件???????1272??2017-07-05?15:03??keshe\css\menu.css

?????文件????????327??2017-07-05?15:03??keshe\css\styleSheet.css

?????文件???????3767??2018-06-23?14:14??keshe\data_delete.aspx

?????文件???????2474??2018-06-23?10:38??keshe\data_delete.aspx.cs

?????文件???????1661??2018-06-23?14:17??keshe\data_find.aspx

?????文件???????1203??2018-06-23?17:51??keshe\data_find.aspx.cs

?????文件???????2848??2018-06-23?20:18??keshe\data_insert.aspx

?????文件???????2240??2018-06-23?20:26??keshe\data_insert.aspx.cs

?????文件???????4924??2018-06-23?15:10??keshe\data_update.aspx

?????文件???????3749??2018-06-23?13:14??keshe\data_update.aspx.cs

?????文件???????1976??2017-07-05?15:03??keshe\images\01.gif

?????文件???????2125??2017-07-05?15:03??keshe\images\02.gif

?????文件???????2391??2017-07-05?15:03??keshe\images\04.gif

?????文件???????2317??2017-07-05?15:03??keshe\images\06.gif

?????文件??????11330??2018-03-29?15:10??keshe\images\1.jpg

?????文件???????8735??2018-03-29?15:11??keshe\images\2.jpg

?????文件??????10993??2017-07-05?15:03??keshe\images\20130111150859609.gif

?????文件???????7526??2017-07-05?15:03??keshe\images\20160330091651808.jpg

?????文件??????12094??2018-03-29?15:11??keshe\images\3.jpg

............此處省略83個文件信息