当前文件：
FHWUUXMQKKG24/articlemanage.aspx.cs[7K，2009-6-12 11:42:31]，
打开代码结构图
1
using System;
2using System.Collections;
3using System.Data.OleDb;
4using System.ComponentModel;
5using System.Data;
6using System.Drawing;
7using System.Web;
8using System.Web.SessionState;
9using System.Web.UI;
10using System.Web.UI.WebControls;
11using System.Web.UI.HtmlControls;
12
13namespace temp
14
...{
15
/**//// <summary>
16
/// articlemanage 的摘要说明。
17
/// </summary>
18 public class articlemanage : System.Web.UI.Page
19 ...{
20 protected System.Web.UI.WebControls.DataGrid DG_Article;
21 protected System.Web.UI.WebControls.Panel Pl_Result;
22 protected System.Web.UI.WebControls.Label Lb_State;
23 protected System.Web.UI.WebControls.LinkButton LB_First;
24 protected System.Web.UI.WebControls.LinkButton LB_Pre;
25 protected System.Web.UI.WebControls.LinkButton LB_Next;
26 protected System.Web.UI.WebControls.LinkButton LB_Last;
27 protected System.Web.UI.WebControls.TextBox Tb_Go;
28 protected System.Web.UI.WebControls.Button Bt_Go;
29 protected System.Web.UI.WebControls.Panel Pl_Type;
30 protected System.Web.UI.WebControls.Label Lb_Wrong;
31 protected DataSet myDataSet=new DataSet ();
32 protected System.Web.UI.WebControls.Button del_bt;
33 protected System.Web.UI.WebControls.CheckBox Cb_All;
34 public int count;
35
36 private void Page_Load(object sender, System.EventArgs e)
37 ...{
38 // 在此处放置用户代码以初始化页面
39 if(Request["d_adminuser"]!=null && Request["d_adminuser"]!="")
40 ...{
41 if(Request["d_adminuser"]=="temp2")
42 ...{
43 //是否回传!
44 if(!IsPostBack)
45 ...{
46 bind();
47 }
48 }
49 }
50 else
51 ...{
52 Response.Write("<script language=javascript>alert('您无权访问本页，请先登录！');location.href='login.aspx';</script>");
53
54 }
55
56 }
57 private void bind()
58 ...{
59 string dbname=".\\dbxcl\\temp.mdb";
60 string strConnection=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath (dbname)+";";
61 OleDbConnection objConnection=new OleDbConnection(strConnection);
62 objConnection.Open();
63
64 DataSet myDataSet=new DataSet ();
65
66 string strSel="select * from d_heartword order by d_hwhits desc";
67 OleDbCommand myCommand=new OleDbCommand( strSel, objConnection );
68
69 OleDbDataAdapter myDbAdapter=new OleDbDataAdapter ();
70 myDbAdapter.SelectCommand=myCommand;
71
72 myDbAdapter.Fill (myDataSet,"d_detail");
73
74 if (myDataSet.Tables ["d_detail"].Rows .Count >0)
75 ...{
76 DG_Article.DataSource=myDataSet.Tables["d_detail"].DefaultView;
77 DG_Article.DataBind();
78 DG_Article.Columns [0].ItemStyle .Width =50;
79 DG_Article.Columns [2].ItemStyle .Width =200;
80 DG_Article.Columns [3].ItemStyle .Width =80;
81 DG_Article.Columns [4].ItemStyle .Width =120;
82 DG_Article.Columns [5].ItemStyle .Width =80;
83 DG_Article.Columns [6].ItemStyle .Width =80;
84 DG_Article.Columns [7].ItemStyle .Width =80;
85 DG_Article.Columns [8].ItemStyle .Width =80;
86 }
87
88 count=myDataSet.Tables ["d_detail"].Rows .Count;
89
90 showState();
91
92 myDataSet.Dispose();
93 objConnection.Dispose();
94 }
95
96 private void Bt_Go_Click(object sender, System.EventArgs e)
97 ...{
98 if(Tb_Go.Text.Trim ()!="")
99 ...{
100 int index=System.Convert .ToInt32 (Tb_Go.Text .Trim ())-1;
101 if(index>=0&&index<DG_Article.PageCount )
102 ...{
103 DG_Article.CurrentPageIndex =index;
104 }
105 }
106 bind ();
107 showState();
108 }
109
110 private void LB_Click(object sender, System.EventArgs e)
111 ...{
112 string arg=((LinkButton)sender).CommandArgument;
113 switch(arg)
114 ...{
115 case "Pre":
116 if(DG_Article.CurrentPageIndex >0)
117 DG_Article.CurrentPageIndex --;
118 break;
119 case"Next":
120 if(DG_Article.CurrentPageIndex <(DG_Article.PageCount -1))
121 DG_Article.CurrentPageIndex ++;
122 break;
123 case"Last":
124 DG_Article.CurrentPageIndex =DG_Article.PageCount -1;
125 break;
126 default:
127 DG_Article.CurrentPageIndex =System.Convert .ToInt32 (arg);
128 break;
129 }
130 bind ();
131 showState();
132 }
133
134 private void showState()
135 ...{
136 LB_First.Text ="首页";
137 LB_Pre.Text ="前一页";
138 LB_Next.Text ="下一页";
139 LB_Last.Text ="末页";
140 int currentPage=DG_Article.CurrentPageIndex+1;
141 int totalPage=DG_Article.PageCount;
142 Lb_State.Text ="页次："+"<b>"+currentPage+"</b>"+"/"+"<b>"+totalPage+"</b>" +" 页 每页 "+"<b>"+DG_Article.PageSize+"</b>"+" 主题数 "+"<b>"+count+"</b>" ;
143 }
144
145 Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
146 override protected void OnInit(EventArgs e)
147 ...{
148 //
149 // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
150 //
151 InitializeComponent();
152 base.OnInit(e);
153 }
154
155 /**//// <summary>
156 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
157 /// 此方法的内容。
158 /// </summary>
159 private void InitializeComponent()
160 ...{
161 this.DG_Article.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DG_Article_ItemCommand);
162 this.DG_Article.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DG_Article_PageIndexChanged);
163 this.LB_First.Click += new System.EventHandler(this.LB_Click);
164 this.LB_Pre.Click += new System.EventHandler(this.LB_Click);
165 this.LB_Next.Click += new System.EventHandler(this.LB_Click);
166 this.LB_Last.Click += new System.EventHandler(this.LB_Click);
167 this.Tb_Go.TextChanged += new System.EventHandler(this.Bt_Go_Click);
168 this.Bt_Go.Click += new System.EventHandler(this.Bt_Go_Click);
169 this.Cb_All.CheckedChanged += new System.EventHandler(this.Cb_All_CheckedChanged);
170 this.del_bt.Click += new System.EventHandler(this.del_bt_Click);
171 this.Load += new System.EventHandler(this.Page_Load);
172
173 }
174 #endregion
175
176 private void DG_Article_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
177 ...{
178 DG_Article.CurrentPageIndex =e.NewPageIndex;
179 bind ();
180 showState();
181 }
182
183 private void del_bt_Click(object sender, System.EventArgs e)
184 ...{
185 int a=1;
186 for(int i=0;i<DG_Article.Items.Count;i++)
187 ...{
188 CheckBox c = (CheckBox) DG_Article.Items[i].FindControl("CB_Del");
189 if(((CheckBox)DG_Article.Items[i].FindControl("CB_Del")).Checked==true)
190 ...{
191 string id=DG_Article.Items[i].Cells[1].Text;
192 a=a+1;
193 string dbname=".\\dbxcl\\temp.mdb";
194 string strConnection=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath (dbname)+";";
195 OleDbConnection objConnection=new OleDbConnection(strConnection);
196 objConnection.Open();
197
198 string deletesql="delete from d_heartword where d_hwid="+id;
199 OleDbCommand deletecom=new OleDbCommand(deletesql,objConnection);
200 deletecom.ExecuteNonQuery();
201 objConnection.Close();
202 }
203 }
204
205 DG_Article.EditItemIndex = -1;
206 bind();
207 Response.Flush();
208 if(a==1)
209 ...{
210 Response.Write("<script>alert('对不起！您没有选择任何纪录，无法删除！');</script>");
211 return;
212 }
213
214
215 }
216
217 private void DG_Article_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
218 ...{
219 if(e.CommandName.ToUpper() == "DELETE")
220 ...{
221 string sId = e.CommandArgument.ToString();
222 string dbname=".\\dbxcl\\temp.mdb";
223 string strConnection=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath (dbname)+";";
224 OleDbConnection objConnection=new OleDbConnection(strConnection);
225 objConnection.Open();
226
227 string delStr="delete from d_heartword where d_hwid="+sId;
228 OleDbCommand myCommandDel=new OleDbCommand( delStr, objConnection );
229 myCommandDel.ExecuteNonQuery ();
230 Response.Flush();
231 }
232 }
233
234 private void Cb_All_CheckedChanged(object sender, System.EventArgs e)
235 ...{
236 for(int i=0;i<DG_Article.Items.Count;i++)
237 ...{
238 if(Cb_All.Checked)
239 ...{
240 CheckBox c = (CheckBox) DG_Article.Items[i].FindControl("CB_Del");
241 c.Checked=true;
242 }
243 else
244 ...{
245 CheckBox c = (CheckBox) DG_Article.Items[i].FindControl("CB_Del");
246 c.Checked=false;
247 }
248
249 }
250 }
251 }
252
}
253
打包下载该项目完整源码：冬雷物语个人综合网站源码