如何在Repeater控件中實現像GridView控件一樣的編輯、更新、刪除功能?

下面給出示例 vs.net2008(C#)下編寫

后臺.cs代碼


 

1. protected void Page_Load(object sender, EventArgs e) 
2. { 
3.     if (!Page.IsPostBack) 
4.     { 
5.          BindGrid(); 
6.     } 
7.  
8. } 
9.  
10. private void BindGrid() 
11. {           
12.      string strSQL = "SELECT * FROM [User]"; 
13.      OleDbConnection objConnection = new OleDbConnection(GetStrConnection()); 
14.      objConnection.Open(); 
15.      OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection); 
16.      OleDbDataReader reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); 
17.      rptUser.DataSource = reader; 
18.      rptUser.DataBind(); 
19. } 
20.  
21. protected void rptUser_ItemDataBound(object sender, RepeaterItemEventArgs e) 
22. { 
23.     if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) 
24.     { 
25.          System.Data.Common.DbDataRecord record = (System.Data.Common.DbDataRecord)e.Item.DataItem; 
26.          int userId = int.Parse(record["UserId"].ToString()); 
27.          if (userId != id) 
28.          { 
29.              ((Panel)e.Item.FindControl("plItem")).Visible = true; 
30.              ((Panel)e.Item.FindControl("plEdit")).Visible = false; 
31.          } 
32.          else 
33.          { 
34.              ((Panel)e.Item.FindControl("plItem")).Visible = false; 
35.              ((Panel)e.Item.FindControl("plEdit")).Visible = true; 
36.          }        
37.     } 
38. } 
39.  
40. protected void rptUser_ItemCommand(object source, RepeaterCommandEventArgs e) 
41. { 
42.      if (e.CommandName == "Edit") 
43.      { 
44.          id = int.Parse(e.CommandArgument.ToString()); 
45.      } 
46.      else if (e.CommandName == "Cancel") 
47.      { 
48.          id = -1; 
49.      } 
50.      else if (e.CommandName == "Update") 
51.      { 
52.          string name = ((TextBox)this.rptUser.Items[e.Item.ItemIndex].FindControl("txtName")).Text.Trim(); 
53.          string email = ((TextBox)this.rptUser.Items[e.Item.ItemIndex].FindControl("txtEmail")).Text.Trim(); 
54.          string qq = ((TextBox)this.rptUser.Items[e.Item.ItemIndex].FindControl("txtQQ")).Text.Trim(); 
55.          string strSQL = "UPDATE [User] SET Name=@Name,Email=@Email,QQ=@QQ WHERE UserId=@UserId"; 
56.          OleDbConnection objConnection = new OleDbConnection(GetStrConnection()); 
57.          OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection); 
58.          objCommand.Parameters.Add("@Name", OleDbType.VarWChar); 
59.          objCommand.Parameters["@Name"].Value = name; 
60.          objCommand.Parameters.Add("@Email", OleDbType.VarWChar); 
61.          objCommand.Parameters["@Email"].Value = email; 
62.          objCommand.Parameters.Add("@QQ", OleDbType.VarWChar); 
63.          objCommand.Parameters["@QQ"].Value = qq; 
64.          objCommand.Parameters.Add("@UserId", OleDbType.Integer); 
65.          objCommand.Parameters["@UserId"].Value = int.Parse(e.CommandArgument.ToString()); 
66.          objConnection.Open(); 
67.          objCommand.ExecuteNonQuery(); 
68.          objConnection.Close(); 
69.      } 
70.      else if (e.CommandName == "Delete") 
71.      { 
72.          string strSQL = "DELETE * FROM [User] WHERE UserId=@UserId"; 
73.          OleDbConnection objConnection = new OleDbConnection(GetStrConnection()); 
74.          OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection); 
75.          objCommand.Parameters.Add("@UserId", OleDbType.Integer); 
76.          objCommand.Parameters["@UserId"].Value = int.Parse(e.CommandArgument.ToString()); 
77.          objConnection.Open(); 
78.          objCommand.ExecuteNonQuery(); 
79.          objConnection.Close(); 
80.      } 
81.  
82.      BindGrid(); 
83. } 
84.  
85. private string GetStrConnection() 
86. { 
87.     return "Provider=Microsoft.Jet.OleDb.4.0;data source=" + Server.MapPath("~/Database/test.mdb"); 
88. } 
89. 前臺.aspx代碼 
90.  
91. <form id="form1" runat="server"> 
92.     <asp:Repeater ID="rptUser" runat="server" onitemcommand="rptUser_ItemCommand"  
93.         onitemdatabound="rptUser_ItemDataBound"> 
94.         <HeaderTemplate> 
95.             <table width="960" align="center" cellpadding="3" cellspacing="1" style="background-color: #ccc;"> 
96.                 <thead style="background-color: #eee;"> 
97.                     <tr> 
98.                         <th width="10%"> 
99.                             用戶ID 
100.                         </th> 
101.                         <th> 
102.                             用戶名 
103.                         </th> 
104.                         <th width="22%"> 
105.                             郵件 
106.                         </th> 
107.                         <th width="20%"> 
108.                             QQ 
109.                         </th> 
110.                         <th width="15%"> 
111.                             注冊時間 
112.                         </th> 
113.                         <th width="12%"> 
114.                             操作 
115.                         </th> 
116.                     </tr> 
117.                 </thead> 
118.                 <tbody style="background-color: #fff;"> 
119.         </HeaderTemplate> 
120.         <ItemTemplate> 
121.             <asp:Panel ID="plItem" runat="server"> 
122.                 <tr style="text-align: center;"> 
123.                     <td> 
124.                         <%# DataBinder.Eval(Container.DataItem, "UserId")%> 
125.                     </td> 
126.                     <td> 
127.                         <%# DataBinder.Eval(Container.DataItem, "Name")%> 
128.                     </td> 
129.                     <td> 
130.                         <%# DataBinder.Eval(Container.DataItem, "Email")%> 
131.                     </td> 
132.                     <td> 
133.                         <%# DataBinder.Eval(Container.DataItem, "QQ")%> 
134.                     </td> 
135.                     <td> 
136.                         <%# DataBinder.Eval(Container.DataItem, "AddTime","{0:yyyy-MM-dd}")%> 
137.                     </td> 
138.                     <td> <asp:LinkButton runat="server" ID="lbtEdit" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "UserId")%>' 
139.                      CommandName="Edit" Text="編輯"></asp:LinkButton>&nbsp;&nbsp; 
140.                     <asp:LinkButton runat="server" ID="lbtDelete" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "UserId")%>' 
141.                      CommandName="Delete" Text="刪除" OnClientClick="return confirm('確定要刪除？')"></asp:LinkButton> 
142.                     </td> 
143.                 </tr> 
144.             </asp:Panel> 
145.             <asp:Panel ID="plEdit" runat="server"> 
146.                 <tr style="text-align: center;"> 
147.                     <td> 
148.                         <%# DataBinder.Eval(Container.DataItem, "UserId")%> 
149.                     </td> 
150.                     <td> 
151.                         <asp:TextBox ID="txtName" Text='<%# DataBinder.Eval(Container.DataItem,"Name") %>' 
152.                             runat="server"></asp:TextBox> 
153.                     </td> 
154.                     <td> 
155.                         <asp:TextBox ID="txtEmail" Text='<%# DataBinder.Eval(Container.DataItem,"Email") %>' 
156.                             runat="server"></asp:TextBox> 
157.                     </td> 
158.                     <td> 
159.                         <asp:TextBox ID="txtQQ" Text='<%# DataBinder.Eval(Container.DataItem,"QQ") %>' runat="server"></asp:TextBox> 
160.                     </td> 
161.                     <td> 
162.                         <%# DataBinder.Eval(Container.DataItem, "AddTime","{0:yyyy-MM-dd}")%> 
163.                     </td> 
164.                     <td> 
165.                       <asp:LinkButton runat="server" ID="lbtUpdate" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "UserId")%>' 
166.                      CommandName="Update" Text="更新"></asp:LinkButton>&nbsp;&nbsp; 
167.                     <asp:LinkButton runat="server" ID="lbtCancel" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "UserId")%>' 
168.                      CommandName="Cancel" Text="取消"></asp:LinkButton> 
169.                     </td> 
170.                 </tr> 
171.             </asp:Panel> 
172.         </ItemTemplate> 
173.         <FooterTemplate> 
174.             </tbody></table> 
175.         </FooterTemplate> 
176.     </asp:Repeater> 
177. </form> 

下載代碼示例：PageDemo.RAR

相關文檔： Repeater控件的分頁實現 Repeater多行間隔顯示分隔符的方法 Repeater中嵌套使用Repeater