投票系統管理界面：
其源代碼：
代碼
1 <%@ Control Language="C#" AutoEventWireup="true" CodeFile="ManageVote.ascx.cs" Inherits="ManageVote" %>
2 <table style="width:800px; height:400px" cellspacing="0">
3 <tr>
4
5 <td style="width:189px; background-image: url(image/login_1.gif);">
6 </td>
7 <td style="background-image: url(image/login_2.gif)">
8 <table style="width:400px; height:400px;">
9 <tr >
10 <td style="width:100px;"></td>
11 <td style="width:195px;"></td>
12 <td style="width:100px;"></td>
13 </tr>
14 <tr >
15 <td style="width:100px;"></td>
16 <td style="width:195px;"></td>
17 <td style="width:100px;"></td>
18 </tr>
19 <tr >
20 <td style="width:100px;"></td>
21 <td style="width:195px;"></td>
22 <td style="width:100px;">
23 <asp:ImageButton ID="returnIndex" runat="server" ImageUrl="~/image/ruturnIndex.gif" OnClick="returnIndex_Click" />
24 </td>
25 </tr>
26 <tr >
27 <td style="width:100px; height: 26px;"></td>
28 <td style="width:195px; height: 26px;">
29
30
31 </td>
32 <td style="width:100px; height: 26px;"></td>
33 </tr>
34 <tr >
35 <td style="width:100px; height: 34px;"></td>
36 <td style="height: 34px; width:300px;" colspan="2">
37
38
39 <asp:DataList ID="DLVoteManage" runat="server" Height="66px" Width="300px" OnDeleteCommand="DLVoteManage_DeleteCommand" DataKeyField="VoteItem_id" >
40 <ItemTemplate>
41 <table>
42 <tr>
43 <td style="width:200px;" align="left">
44 <asp:Label ID="labTitle" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"VoteItem") %>' ForeColor="#C04000"></asp:Label>
45 </td>
46
47 <td>
48 <asp:ImageButton ID="IBdelete" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"VoteItem_id") %>'
49 CommandName="delete" ImageUrl="~/image/delete.gif" CausesValidation="False" OnLoad="IBdelete_Load"/>
50 </td>
51 </tr>
52
53 </table>
54
55
56
57 </ItemTemplate>
58
59
60 </asp:DataList>
61
62
63
64
65
66
67 </td>
68
69 </tr>
70 <tr >
71 <td style="width:100px; height: 34px;"></td>
72 <td style="width:195px; height: 34px;"></td>
73 <td style="width:100px; height: 34px;"></td>
74 </tr>
75 <tr >
76 <td style="width:100px;"></td>
77 <td style="width:195px;"></td>
78 <td style="width:100px;"></td>
79 </tr>
80 <tr >
81 <td style="width:100px;"></td>
82 <td style="width:195px;"></td>
83 <td style="width:100px;"></td>
84 </tr>
85 <tr >
86 <td style="width:100px;"></td>
87 <td style="width:195px;"></td>
88 <td style="width:100px;"></td>
89 </tr>
90 <tr >
91 <td style="width:100px;"></td>
92 <td style="width:195px;"></td>
93 <td style="width:100px;"></td>
94 </tr>
95 <tr >
96 <td style="width:100px;"></td>
97 <td style="width:195px;"></td>
98 <td style="width:100px;"></td>
99 </tr>
100 </table>
101
102
103
104
105 </td>
106 <td style="width:200px; background-image: url(image/login_3.gif);">
107 </td>
108 </tr>
109
110 </table>
111 o
112
背景代碼：
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11
12 public partial class ManageVote : System.Web.UI.UserControl
13 {
14 BaseDb obj = new BaseDb();
15 protected void Page_Load(object sender, EventArgs e)
16 {
17 if (!IsPostBack)
18 {
19 Bind();
20 }
21
22 }
23
24 #region 對DataList進行資料綁定
25 public void Bind()
26 {
27 int userId = GetUserID();
28 DataSet ds = obj.getdatabydataset("select VoteItem_id,VoteItem from VoteItem where User_id = " + userId );
29
30 DLVoteManage.DataSource = ds;
31 DLVoteManage.DataKeyField = "VoteItem_id";
32 DLVoteManage.DataBind();
33
34 }
35
36 #endregion
37
38 #region 獲得部落格ID
39 public int GetBlogID()
40 {
41 int BlogID =3;
42 return BlogID;
43 }
44
45 #endregion
46
47 #region 獲得使用者ID
48 public int GetUserID()
49 {
50 int userID = 0;
51 int BlogId = GetBlogID();
52 try
53 { //根據部落格ID擷取使用者ID
54 DataSet ds = obj.getdatabydataset("select User_id from BlogManage where Blog_id=" + "'" + BlogId + "'");
55
56 userID = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
57
58 }
59 catch (Exception ee)
60 {
61 Response.Write("<script>alert('" + ee.Message + "');</script>");
62 }
63
64 return userID;
65 }
66
67 #endregion
68 protected void DLVoteManage_DeleteCommand(object source, DataListCommandEventArgs e)
69 {
70 int voteItemID = Convert.ToInt32(e.CommandArgument.ToString());
71 obj.ExecuteSql("DELETE FROM VoteItem where VoteItem_id = " + "'" + voteItemID + "'" ) ;
72 obj.ExecuteSql("DELETE FROM VoteSelect where VoteItem_id = " + "'" + voteItemID +"'");
73 Bind();
74 }
75
76 #region 删除前給出提示資訊
77 public void IBdelete_Load(object sender, EventArgs e)
78 {
79
80 ((ImageButton)sender).Attributes["onclick"] = "javascript:return confirm('你确認要删除該條記錄嗎？')";
81 }
82 #endregion
83 protected void returnIndex_Click(object sender, ImageClickEventArgs e)
84 {
85 Response.Redirect("~/VoteIndex.aspx");
86 }
87 }
88