asp.net中repeater嵌套CheckBoxList,RadioButtonList来完成投票

1. <table height="286" cellSpacing="0" cellPadding="0" width="1000" align="center" bgColor="#ffffff"  
2.   
3.                 border="0">  
4.   
5.                 <tbody>  
6.   
7.                     <tr>  
8.   
9.                         <td vAlign="top" height="286">  
10.   
11.                             <div align="left">  
12.   
13.                                 <table height="32" cellSpacing="0" cellPadding="0" width="968" align="center" border="0">  
14.   
15.                                     <tbody>  
16.   
17.                                         <tr>  
18.   
19.                                             <td>  
20.   
21.                                                 <div align="center"></div>  
22.   
23.                                                 <div align="center"><strong><%=Title%></strong><br>  
24.   
25.                                                 </div>  
26.   
27.                                             </td>  
28.   
29.                                         </tr>  
30.   
31.                                     </tbody>  
32.   
33.                                 </table>  
34.   
35.                                 <table cellSpacing="0" cellPadding="0" width="915" align="center" border="0">  
36.   
37.                                     <tbody>  
38.   
39.                                         <tr>  
40.   
41.                                             <td background="../../images/house4_07.jpg" height="1"><FONT face="宋体"></FONT></td>  
42.   
43.                                         </tr>  
44.   
45.                                         <tr>  
46.   
47.                                             <td>  
48.   
49.                                                 <table cellSpacing="0" cellPadding="0" width="915" border="0">  
50.   
51.                                                     <asp:repeater id="Repeater1" Runat="server">  
52.   
53.                                                         <ItemTemplate>  
54.   
55.                                                             <tr>  
56.   
57.                                                                 <td>  
58.   
59.                                                                     <%# DataBinder.Eval(Container, "DataItem.FVoteName") %>  
60.   
61.                                                                     <table width="85%" align="center" border="1" bordercolor="#D6E7FF" cellpadding="0" cellspacing="0">  
62.   
63.                                                                         <tr>  
64.   
65.                                                                             <td>  
66.   
67.                                                                                 <asp:CheckBoxList id="cb" Runat="server" Visible="False"></asp:CheckBoxList>  
68.   
69.                                                                                 <asp:RadioButtonList ID="rb" Runat="server" Visible="False"></asp:RadioButtonList>  
70.   
71.                                                                                 <asp:TextBox ID="tb" TextMode="MultiLine" Columns="40" Rows="4" Runat="server" Visible="False"></asp:TextBox>  
72.   
73.                                                                                 <input type="hidden" id="hb" runat="server" />  
74.   
75.                                                                             </td>  
76.   
77.                                                                         </tr>  
78.   
79.                                                                     </table>  
80.   
81.                                                                 </td>  
82.   
83.                                                             </tr>  
84.   
85.                                                         </ItemTemplate>  
86.   
87.                                                     </asp:repeater></table>  
88.   
89.                                             </td>  
90.   
91.                                         </tr>  
92.   
93.                                         <tr>  
94.   
95.                                             <td align="center"><asp:button id="btnAdd" runat="server" Text="提交"></asp:button></td>  
96.   
97.                                         </tr>  
98.   
99.                                     </tbody>  
100.   
101.                                 </table>  
102.   
103.                             </div>  
104.   
105.                             <div align="right"></div>  
106.   
107.                         </td>  
108.   
109.                     </tr>  
110.   
111.                 </tbody>  
112.   
113.             </table>  

<table height="286" cellSpacing="0" cellPadding="0" width="1000" align="center" bgColor="#ffffff"

				border="0">

				<tbody>

					<tr>

						<td vAlign="top" height="286">

							<div align="left">

								<table height="32" cellSpacing="0" cellPadding="0" width="968" align="center" border="0">

									<tbody>

										<tr>

											<td>

												<div align="center"></div>

												<div align="center"><strong><%=Title%></strong><br>

												</div>

											</td>

										</tr>

									</tbody>

								</table>

								<table cellSpacing="0" cellPadding="0" width="915" align="center" border="0">

									<tbody>

										<tr>

											<td background="../../images/house4_07.jpg" height="1"><FONT face="宋体"></FONT></td>

										</tr>

										<tr>

											<td>

												<table cellSpacing="0" cellPadding="0" width="915" border="0">

													<asp:repeater id="Repeater1" Runat="server">

														<ItemTemplate>

															<tr>

																<td>

																	<%# DataBinder.Eval(Container, "DataItem.FVoteName") %>

																	<table width="85%" align="center" border="1" bordercolor="#D6E7FF" cellpadding="0" cellspacing="0">

																		<tr>

																			<td>

																				<asp:CheckBoxList id="cb" Runat="server" Visible="False"></asp:CheckBoxList>

																				<asp:RadioButtonList ID="rb" Runat="server" Visible="False"></asp:RadioButtonList>

																				<asp:TextBox ID="tb" TextMode="MultiLine" Columns="40" Rows="4" Runat="server" Visible="False"></asp:TextBox>

																				<input type="hidden" id="hb" runat="server" />

																			</td>

																		</tr>

																	</table>

																</td>

															</tr>

														</ItemTemplate>

													</asp:repeater></table>

											</td>

										</tr>

										<tr>

											<td align="center"><asp:button id="btnAdd" runat="server" Text="提交"></asp:button></td>

										</tr>

									</tbody>

								</table>

							</div>

							<div align="right"></div>

						</td>

					</tr>

				</tbody>

			</table>

2，后台代码

view plain copy to clipboard print ?

1. <PRE class=csharp name="code">protected System.Web.UI.WebControls.Repeater Repeater1;   
2.   
3.   
4.   
5.         public Seaskyer.Modules.Utils.DBClass db = new Seaskyer.Modules.Utils.DBClass();   
6.   
7.         protected System.Web.UI.WebControls.Button btnAdd;   
8.   
9.   
10.   
11.         public string Title;   
12.   
13.         //public string cid;   
14.   
15.        
16.   
17.         private void Page_Load(object sender, System.EventArgs e)   
18.   
19.         {   
20.   
21.             if(!Page.IsPostBack)   
22.   
23.             {   
24.   
25.                 string cid = "";   
26.   
27.                 if(db.q("id")!="")   
28.   
29.                 {   
30.   
31.                     cid=db.q("id");   
32.   
33.                 }   
34.   
35.   
36.   
37.   
38.   
39.                 Title = db.getSingleValue("cms_VotePro","FProName","FID",cid);   
40.   
41.   
42.   
43.                 BindRep();   
44.   
45.             }   
46.   
47.         }   
48.   
49.   
50.   
51.         /// <summary>   
52.   
53.         /// 绑定Repeater控件，显示调查中的大类   
54.   
55.         /// </summary>   
56.   
57.         public void BindRep()   
58.   
59.         {   
60.   
61.             string strsql = "select * from cms_vote where FProID='"+db.q("id")+"'";   
62.   
63.             db.dp.CommandText = strsql;   
64.   
65.             DataTable dt = db.dp.DataTableSQL();   
66.   
67.             if(dt.Rows.Count>0)   
68.   
69.             {   
70.   
71.                 this.Repeater1.DataSource = dt;   
72.   
73.                 this.Repeater1.DataBind();   
74.   
75.             }   
76.   
77.         }  
78.  
79.           
80.  
81.  
82.  
83.  
84.  
85.  
86.  
87.         #region Web 窗体设计器生成的代码   
88.   
89.         override protected void OnInit(EventArgs e)   
90.   
91.         {   
92.   
93.             //   
94.   
95.             // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。   
96.   
97.             //   
98.   
99.             InitializeComponent();   
100.   
101.             base.OnInit(e);   
102.   
103.         }   
104.   
105.            
106.   
107.         /// <summary>   
108.   
109.         /// 设计器支持所需的方法 - 不要使用代码编辑器修改   
110.   
111.         /// 此方法的内容。   
112.   
113.         /// </summary>   
114.   
115.         private void InitializeComponent()   
116.   
117.         {       
118.   
119.             this.Repeater1.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.Repeater1_ItemDataBound);   
120.   
121.             this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);   
122.   
123.             this.Load += new System.EventHandler(this.Page_Load);   
124.   
125.   
126.   
127.         }  
128.  
129.         #endregion   
130.   
131.   
132.   
133.         private void Repeater1_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)   
134.   
135.         {   
136.   
137.             CheckBoxList cb    = (CheckBoxList)e.Item.FindControl("cb");   
138.   
139.             RadioButtonList rb = (RadioButtonList)e.Item.FindControl("rb");   
140.   
141.             TextBox tb         = (TextBox)e.Item.FindControl("tb");   
142.   
143.             System.Web.UI.HtmlControls.HtmlInputHidden hb = (HtmlInputHidden)e.Item.FindControl("hb");   
144.   
145.             DataRowView rowv = (DataRowView)e.Item.DataItem;   
146.   
147.             //提取分类ID   
148.   
149.             string Fid  = rowv["FVoteId"].ToString();   
150.   
151.             string type = rowv["FType"].ToString();   
152.   
153.   
154.   
155.             string strsql = "select * from cms_VoteItem where FVoteId='"+Fid+"'";   
156.   
157.   
158.   
159.             //Response.Write("<script>alert('"+strsql+"');</script>");   
160.   
161.             db.dp.CommandText = strsql;   
162.   
163.             DataTable dt = db.dp.DataTableSQL();   
164.   
165.                
166.   
167.             switch(Convert.ToInt32(type))   
168.   
169.             {   
170.   
171.                 case 1:   
172.   
173.                     rb.Visible = true;   
174.   
175.                     cb.Visible = false;   
176.   
177.                     tb.Visible = false;   
178.   
179.                     rb.DataSource = dt;   
180.   
181.                     rb.DataTextField = "FItemName";   
182.   
183.                     rb.DataValueField = "FID";   
184.   
185.                     rb.DataBind();   
186.   
187.                     break;   
188.   
189.                 case 2:   
190.   
191.                     rb.Visible = false;   
192.   
193.                     cb.Visible = true;   
194.   
195.                     tb.Visible = false;   
196.   
197.                     cb.DataSource = dt;   
198.   
199.                     cb.DataTextField = "FItemName";   
200.   
201.                     cb.DataValueField = "FID";   
202.   
203.                     cb.DataBind();   
204.   
205.                     break;   
206.   
207.                 case 3:   
208.   
209.                     tb.Visible = true;   
210.   
211.                        
212.   
213.                     rb.Visible = false;   
214.   
215.                     cb.Visible = false;   
216.   
217.                     break;   
218.   
219.             }   
220.   
221.         }   
222.   
223.   
224.   
225.         private void btnAdd_Click(object sender, System.EventArgs e)   
226.   
227.         {   
228.   
229.             string cb = "";//复选框   
230.   
231.             string rb = "";//单选框   
232.   
233.             string tb = "";//如果有文本框   
234.   
235.             foreach   (RepeaterItem   item   in   this.Repeater1.Items)       
236.   
237.             {     
238.   
239.   
240.   
241.                 CheckBoxList cb1    = (CheckBoxList)item.FindControl("cb");   
242.   
243.                 RadioButtonList rb1 = (RadioButtonList)item.FindControl("rb");   
244.   
245.                 TextBox tb1         = (TextBox)item.FindControl("tb");   
246.   
247.   
248.   
249.                 //CheckBox cb =   (CheckBox)item.FindControl("CheckBoxRole");     
250.   
251.                 if(cb1.Visible==true)   
252.   
253.                 {   
254.   
255.                     for(int i=0;i<cb1.Items.Count;i++)   
256.   
257.                     {   
258.   
259.                         if(cb1.Items[i].Selected==true)   
260.   
261.                         {   
262.   
263.                             cb += "'"+cb1.Items[i].Value+"'" + ",";   
264.   
265.                         }   
266.   
267.                     }   
268.   
269.                 }   
270.   
271.      
272.   
273.                 if(rb1.Visible==true)   
274.   
275.                 {   
276.   
277.                     for(int i=0;i<rb1.Items.Count;i++)   
278.   
279.                     {   
280.   
281.                         if(rb1.Items[i].Selected==true)   
282.   
283.                         {   
284.   
285.                             rb = "'"+rb1.Items[i].Value+"'";   
286.   
287.                         }   
288.   
289.                     }   
290.   
291.                 }   
292.   
293.   
294.   
295.                 if(tb1.Visible==true)   
296.   
297.                 {   
298.   
299.                     tb = tb1.Text + "|";   
300.   
301.                 }   
302.   
303.             }   
304.   
305.   
306.   
307.             string id = "";   
308.   
309.   
310.   
311.             if(cb.Trim()!="")   
312.   
313.             {   
314.   
315.                 cb = cb.Substring(0,cb.Length-1);   
316.   
317.                 id = cb;   
318.   
319.             }   
320.   
321.   
322.   
323.             if(rb.Trim()!="")   
324.   
325.             {   
326.   
327.                 if(id.Trim()!="")   
328.   
329.                 {   
330.   
331.                     id += "," + rb;   
332.   
333.                 }   
334.   
335.                 else  
336.   
337.                 {   
338.   
339.                     id += rb;   
340.   
341.                 }   
342.   
343.             }   
344.   
345.             //id = cb + rb;   
346.   
347.   
348.   
349.             if(id.Trim()=="")   
350.   
351.             {   
352.   
353.                 Response.Write("<script>alert('你没有进行选择!');history.go(-1);</script>");   
354.   
355.             }   
356.   
357.             string strsql = "update cms_VoteItem set FItemNum=FItemNum+1 where FID in ("+id+")";   
358.   
359.             db.dp.CommandText = strsql;   
360.   
361.             db.dp.ExecuteNonQuery();   
362.   
363.             Response.Write("<script>alert('投票结束!');location.href='VoteView.aspx?id="+db.q("id")+"';</script>");   
364.   
365. //          Response.Write(id);   
366.   
367.         }</PRE>  

  
  

   
   

    
    

     
     view plain
     
     copy to clipboard
     
     print
     
     ?
    
    
   
   
   
   
protected System.Web.UI.WebControls.Repeater Repeater1;   
  
  
  
        public Seaskyer.Modules.Utils.DBClass db = new Seaskyer.Modules.Utils.DBClass();   
  
        protected System.Web.UI.WebControls.Button btnAdd;   
  
  
  
        public string Title;   
  
        //public string cid;   
  
       
  
        private void Page_Load(object sender, System.EventArgs e)   
  
        {   
  
            if(!Page.IsPostBack)   
  
            {   
  
                string cid = "";   
  
                if(db.q("id")!="")   
  
                {   
  
                    cid=db.q("id");   
  
                }   
  
  
  
  
  
                Title = db.getSingleValue("cms_VotePro","FProName","FID",cid);   
  
  
  
                BindRep();   
  
            }   
  
        }   
  
  
  
        /// <summary>   
  
        /// 绑定Repeater控件，显示调查中的大类   
  
        /// </summary>   
  
        public void BindRep()   
  
        {   
  
            string strsql = "select * from cms_vote where FProID='"+db.q("id")+"'";   
  
            db.dp.CommandText = strsql;   
  
            DataTable dt = db.dp.DataTableSQL();   
  
            if(dt.Rows.Count>0)   
  
            {   
  
                this.Repeater1.DataSource = dt;   
  
                this.Repeater1.DataBind();   
  
            }   
  
        }  
 
          
 
 
 
 
 
 
 
        #region Web 窗体设计器生成的代码   
  
        override protected void OnInit(EventArgs e)   
  
        {   
  
            //   
  
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。   
  
            //   
  
            InitializeComponent();   
  
            base.OnInit(e);   
  
        }   
  
           
  
        /// <summary>   
  
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改   
  
        /// 此方法的内容。   
  
        /// </summary>   
  
        private void InitializeComponent()   
  
        {       
  
            this.Repeater1.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.Repeater1_ItemDataBound);   
  
            this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);   
  
            this.Load += new System.EventHandler(this.Page_Load);   
  
  
  
        }  
 
        #endregion   
  
  
  
        private void Repeater1_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)   
  
        {   
  
            CheckBoxList cb    = (CheckBoxList)e.Item.FindControl("cb");   
  
            RadioButtonList rb = (RadioButtonList)e.Item.FindControl("rb");   
  
            TextBox tb         = (TextBox)e.Item.FindControl("tb");   
  
            System.Web.UI.HtmlControls.HtmlInputHidden hb = (HtmlInputHidden)e.Item.FindControl("hb");   
  
            DataRowView rowv = (DataRowView)e.Item.DataItem;   
  
            //提取分类ID   
  
            string Fid  = rowv["FVoteId"].ToString();   
  
            string type = rowv["FType"].ToString();   
  
  
  
            string strsql = "select * from cms_VoteItem where FVoteId='"+Fid+"'";   
  
  
  
            //Response.Write("<script>alert('"+strsql+"');</script>");   
  
            db.dp.CommandText = strsql;   
  
            DataTable dt = db.dp.DataTableSQL();   
  
               
  
            switch(Convert.ToInt32(type))   
  
            {   
  
                case 1:   
  
                    rb.Visible = true;   
  
                    cb.Visible = false;   
  
                    tb.Visible = false;   
  
                    rb.DataSource = dt;   
  
                    rb.DataTextField = "FItemName";   
  
                    rb.DataValueField = "FID";   
  
                    rb.DataBind();   
  
                    break;   
  
                case 2:   
  
                    rb.Visible = false;   
  
                    cb.Visible = true;   
  
                    tb.Visible = false;   
  
                    cb.DataSource = dt;   
  
                    cb.DataTextField = "FItemName";   
  
                    cb.DataValueField = "FID";   
  
                    cb.DataBind();   
  
                    break;   
  
                case 3:   
  
                    tb.Visible = true;   
  
                       
  
                    rb.Visible = false;   
  
                    cb.Visible = false;   
  
                    break;   
  
            }   
  
        }   
  
  
  
        private void btnAdd_Click(object sender, System.EventArgs e)   
  
        {   
  
            string cb = "";//复选框   
  
            string rb = "";//单选框   
  
            string tb = "";//如果有文本框   
  
            foreach   (RepeaterItem   item   in   this.Repeater1.Items)       
  
            {     
  
  
  
                CheckBoxList cb1    = (CheckBoxList)item.FindControl("cb");   
  
                RadioButtonList rb1 = (RadioButtonList)item.FindControl("rb");   
  
                TextBox tb1         = (TextBox)item.FindControl("tb");   
  
  
  
                //CheckBox cb =   (CheckBox)item.FindControl("CheckBoxRole");     
  
                if(cb1.Visible==true)   
  
                {   
  
                    for(int i=0;i<cb1.Items.Count;i++)   
  
                    {   
  
                        if(cb1.Items[i].Selected==true)   
  
                        {   
  
                            cb += "'"+cb1.Items[i].Value+"'" + ",";   
  
                        }   
  
                    }   
  
                }   
  
     
  
                if(rb1.Visible==true)   
  
                {   
  
                    for(int i=0;i<rb1.Items.Count;i++)   
  
                    {   
  
                        if(rb1.Items[i].Selected==true)   
  
                        {   
  
                            rb = "'"+rb1.Items[i].Value+"'";   
  
                        }   
  
                    }   
  
                }   
  
  
  
                if(tb1.Visible==true)   
  
                {   
  
                    tb = tb1.Text + "|";   
  
                }   
  
            }   
  
  
  
            string id = "";   
  
  
  
            if(cb.Trim()!="")   
  
            {   
  
                cb = cb.Substring(0,cb.Length-1);   
  
                id = cb;   
  
            }   
  
  
  
            if(rb.Trim()!="")   
  
            {   
  
                if(id.Trim()!="")   
  
                {   
  
                    id += "," + rb;   
  
                }   
  
                else  
  
                {   
  
                    id += rb;   
  
                }   
  
            }   
  
            //id = cb + rb;   
  
  
  
            if(id.Trim()=="")   
  
            {   
  
                Response.Write("<script>alert('你没有进行选择!');history.go(-1);</script>");   
  
            }   
  
            string strsql = "update cms_VoteItem set FItemNum=FItemNum+1 where FID in ("+id+")";   
  
            db.dp.CommandText = strsql;   
  
            db.dp.ExecuteNonQuery();   
  
            Response.Write("<script>alert('投票结束!');location.href='VoteView.aspx?id="+db.q("id")+"';</script>");   
  
//          Response.Write(id);   
  
        }  
  
  
protected System.Web.UI.WebControls.Repeater Repeater1;



		public Seaskyer.Modules.Utils.DBClass db = new Seaskyer.Modules.Utils.DBClass();

		protected System.Web.UI.WebControls.Button btnAdd;



		public string Title;

		//public string cid;

	

		private void Page_Load(object sender, System.EventArgs e)

		{

			if(!Page.IsPostBack)

			{

                string cid = "";

				if(db.q("id")!="")

				{

                    cid=db.q("id");

				}





                Title = db.getSingleValue("cms_VotePro","FProName","FID",cid);



				BindRep();

			}

		}



		/// <summary>

		/// 绑定Repeater控件，显示调查中的大类

		/// </summary>

		public void BindRep()

		{

            string strsql = "select * from cms_vote where FProID='"+db.q("id")+"'";

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();

			if(dt.Rows.Count>0)

			{

                this.Repeater1.DataSource = dt;

				this.Repeater1.DataBind();

			}

		}

		







		#region Web 窗体设计器生成的代码

		override protected void OnInit(EventArgs e)

		{

			//

			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

			//

			InitializeComponent();

			base.OnInit(e);

		}

		

		/// <summary>

		/// 设计器支持所需的方法 - 不要使用代码编辑器修改

		/// 此方法的内容。

		/// </summary>

		private void InitializeComponent()

		{    

			this.Repeater1.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.Repeater1_ItemDataBound);

			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);

			this.Load += new System.EventHandler(this.Page_Load);



		}

		#endregion



		private void Repeater1_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)

		{

			CheckBoxList cb    = (CheckBoxList)e.Item.FindControl("cb");

			RadioButtonList rb = (RadioButtonList)e.Item.FindControl("rb");

			TextBox tb         = (TextBox)e.Item.FindControl("tb");

			System.Web.UI.HtmlControls.HtmlInputHidden hb = (HtmlInputHidden)e.Item.FindControl("hb");

			DataRowView rowv = (DataRowView)e.Item.DataItem;

			//提取分类ID

			string Fid  = rowv["FVoteId"].ToString();

			string type = rowv["FType"].ToString();



			string strsql = "select * from cms_VoteItem where FVoteId='"+Fid+"'";



			//Response.Write("<script>alert('"+strsql+"');</script>");

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();

			

			switch(Convert.ToInt32(type))

			{

                case 1:

					rb.Visible = true;

					cb.Visible = false;

					tb.Visible = false;

					rb.DataSource = dt;

					rb.DataTextField = "FItemName";

					rb.DataValueField = "FID";

					rb.DataBind();

					break;

				case 2:

					rb.Visible = false;

					cb.Visible = true;

					tb.Visible = false;

					cb.DataSource = dt;

					cb.DataTextField = "FItemName";

					cb.DataValueField = "FID";

					cb.DataBind();

					break;

				case 3:

                    tb.Visible = true;

                    

					rb.Visible = false;

					cb.Visible = false;

					break;

			}

		}



		private void btnAdd_Click(object sender, System.EventArgs e)

		{

			string cb = "";//复选框

			string rb = "";//单选框

			string tb = "";//如果有文本框

			foreach   (RepeaterItem   item   in   this.Repeater1.Items)    

			{  



				CheckBoxList cb1    = (CheckBoxList)item.FindControl("cb");

				RadioButtonList rb1 = (RadioButtonList)item.FindControl("rb");

				TextBox tb1         = (TextBox)item.FindControl("tb");



				//CheckBox cb =   (CheckBox)item.FindControl("CheckBoxRole");  

				if(cb1.Visible==true)

				{

					for(int i=0;i<cb1.Items.Count;i++)

					{

						if(cb1.Items[i].Selected==true)

						{

							cb += "'"+cb1.Items[i].Value+"'" + ",";

						}

					}

				}

  

				if(rb1.Visible==true)

				{

					for(int i=0;i<rb1.Items.Count;i++)

					{

						if(rb1.Items[i].Selected==true)

						{

                            rb = "'"+rb1.Items[i].Value+"'";

						}

					}

				}



				if(tb1.Visible==true)

				{

					tb = tb1.Text + "|";

				}

			}



			string id = "";



			if(cb.Trim()!="")

			{

                cb = cb.Substring(0,cb.Length-1);

                id = cb;

			}



			if(rb.Trim()!="")

			{

				if(id.Trim()!="")

				{

					id += "," + rb;

				}

				else

				{

					id += rb;

				}

			}

            //id = cb + rb;



			if(id.Trim()=="")

			{

                Response.Write("<script>alert('你没有进行选择!');history.go(-1);</script>");

			}

			string strsql = "update cms_VoteItem set FItemNum=FItemNum+1 where FID in ("+id+")";

			db.dp.CommandText = strsql;

			db.dp.ExecuteNonQuery();

			Response.Write("<script>alert('投票结束!');location.href='VoteView.aspx?id="+db.q("id")+"';</script>");

//			Response.Write(id);

		}

3,显示投票结果前台

view plain copy to clipboard print ?

1. <table height="286" cellSpacing="0" cellPadding="0" width="1000" align="center" bgColor="#ffffff"  
2.   
3.                 border="0">  
4.   
5.                 <tbody>  
6.   
7.                     <tr>  
8.   
9.                         <td vAlign="top" height="286">  
10.   
11.                             <div align="left">  
12.   
13.                                 <table height="32" cellSpacing="0" cellPadding="0" width="968" align="center" border="0">  
14.   
15.                                     <tbody>  
16.   
17.                                         <tr>  
18.   
19.                                             <td>  
20.   
21.                                                 <div align="center"></div>  
22.   
23.                                                 <div align="center"><strong><%=Title%></strong><br>  
24.   
25.                                                 </div>  
26.   
27.                                             </td>  
28.   
29.                                         </tr>  
30.   
31.                                     </tbody>  
32.   
33.                                 </table>  
34.   
35.                                 <table cellSpacing="0" cellPadding="0" width="915" align="center" border="0">  
36.   
37.                                     <tbody>  
38.   
39.                                         <tr>  
40.   
41.                                             <td background="../../images/house4_07.jpg" height="1"><FONT face="宋体"></FONT></td>  
42.   
43.                                         </tr>  
44.   
45.                                         <tr>  
46.   
47.                                             <td>  
48.   
49.                                                 <table cellSpacing="0" cellPadding="0" width="915" border="0">  
50.   
51.                                                     <asp:repeater id="Repeater1" Runat="server">  
52.   
53.                                                         <ItemTemplate>  
54.   
55.                                                             <tr>  
56.   
57.                                                                 <td>  
58.   
59.                                                                     <%# DataBinder.Eval(Container, "DataItem.FVoteName") %>  
60.   
61.                                                                     <asp:Repeater ID="rep" Runat="server">  
62.   
63.                                                                         <ItemTemplate>  
64.   
65.                                                                             <table width="85%" align="center" border="1" bordercolor="#D6E7FF" cellpadding="0" cellspacing="0">  
66.   
67.                                                                                 <tr>  
68.   
69.                                                                                     <td width="10%">  
70.   
71.                                                                                         选项：   
72.   
73.                                                                                     </td width="20%">  
74.   
75.                                                                                     <td><%# DataBinder.Eval(Container, "DataItem.FItemName") %></td>  
76.   
77.                                                                                     <td width="10%">票数：</td>  
78.   
79.                                                                                     <td width="10%"><%# DataBinder.Eval(Container, "DataItem.FItemNum") %></td>  
80.   
81.                                                                                     <td width="10%">百分比:</td>  
82.   
83.                                                                                     <td width="40%"><img src="images/654.gif" height="5" width="<%# IsViews(DataBinder.Eval(Container, "DataItem.FVoteId").ToString(),DataBinder.Eval(Container, "DataItem.FItemNum").ToString()) %>"><%# IsView(DataBinder.Eval(Container, "DataItem.FVoteId").ToString(),DataBinder.Eval(Container, "DataItem.FItemNum").ToString()) %></td>  
84.   
85.                                                                                 </tr>  
86.   
87.                                                                             </table>  
88.   
89.                                                                         </ItemTemplate>  
90.   
91.                                                                     </asp:Repeater>  
92.   
93.                                                                 </td>  
94.   
95.                                                             </tr>  
96.   
97.                                                         </ItemTemplate>  
98.   
99.                                                     </asp:repeater></table>  
100.   
101.                                             </td>  
102.   
103.                                         </tr>  
104.   
105.                                         <tr>  
106.   
107.                                             <td align="center"></td>  
108.   
109.                                         </tr>  
110.   
111.                                     </tbody>  
112.   
113.                                 </table>  
114.   
115.                             </div>  
116.   
117.                             <div align="right"><FONT face="宋体"></FONT></div>  
118.   
119.                         </td>  
120.   
121.                     </tr>  
122.   
123.                 </tbody>  
124.   
125.             </table>  

<table height="286" cellSpacing="0" cellPadding="0" width="1000" align="center" bgColor="#ffffff"

				border="0">

				<tbody>

					<tr>

						<td vAlign="top" height="286">

							<div align="left">

								<table height="32" cellSpacing="0" cellPadding="0" width="968" align="center" border="0">

									<tbody>

										<tr>

											<td>

												<div align="center"></div>

												<div align="center"><strong><%=Title%></strong><br>

												</div>

											</td>

										</tr>

									</tbody>

								</table>

								<table cellSpacing="0" cellPadding="0" width="915" align="center" border="0">

									<tbody>

										<tr>

											<td background="../../images/house4_07.jpg" height="1"><FONT face="宋体"></FONT></td>

										</tr>

										<tr>

											<td>

												<table cellSpacing="0" cellPadding="0" width="915" border="0">

													<asp:repeater id="Repeater1" Runat="server">

														<ItemTemplate>

															<tr>

																<td>

																	<%# DataBinder.Eval(Container, "DataItem.FVoteName") %>

																	<asp:Repeater ID="rep" Runat="server">

																		<ItemTemplate>

																			<table width="85%" align="center" border="1" bordercolor="#D6E7FF" cellpadding="0" cellspacing="0">

																				<tr>

																					<td width="10%">

																						选项：

																					</td width="20%">

																					<td><%# DataBinder.Eval(Container, "DataItem.FItemName") %></td>

																					<td width="10%">票数：</td>

																					<td width="10%"><%# DataBinder.Eval(Container, "DataItem.FItemNum") %></td>

																					<td width="10%">百分比:</td>

																					<td width="40%"><img src="images/654.gif" height="5" width="<%# IsViews(DataBinder.Eval(Container, "DataItem.FVoteId").ToString(),DataBinder.Eval(Container, "DataItem.FItemNum").ToString()) %>"><%# IsView(DataBinder.Eval(Container, "DataItem.FVoteId").ToString(),DataBinder.Eval(Container, "DataItem.FItemNum").ToString()) %></td>

																				</tr>

																			</table>

																		</ItemTemplate>

																	</asp:Repeater>

																</td>

															</tr>

														</ItemTemplate>

													</asp:repeater></table>

											</td>

										</tr>

										<tr>

											<td align="center"></td>

										</tr>

									</tbody>

								</table>

							</div>

							<div align="right"><FONT face="宋体"></FONT></div>

						</td>

					</tr>

				</tbody>

			</table>

4,后台代码

view plain copy to clipboard print ?

1. protected System.Web.UI.WebControls.Repeater Repeater1;   
2.   
3.   
4.   
5.         public Seaskyer.Modules.Utils.DBClass db = new Seaskyer.Modules.Utils.DBClass();   
6.   
7.   
8.   
9.         public string Title;   
10.   
11.   
12.   
13.         //public string cid;   
14.   
15.        
16.   
17.         private void Page_Load(object sender, System.EventArgs e)   
18.   
19.         {   
20.   
21.             if(!Page.IsPostBack)   
22.   
23.             {   
24.   
25.                 string cid = "";   
26.   
27.                 if(db.q("id")!="")   
28.   
29.                 {   
30.   
31.                     cid=db.q("id");   
32.   
33.                 }   
34.   
35.   
36.   
37.                 Title = db.getSingleValue("cms_VotePro","FProName","FID",cid);   
38.   
39.   
40.   
41.                 BindRep();   
42.   
43.             }   
44.   
45.         }   
46.   
47.   
48.   
49.         /// <summary>   
50.   
51.         /// 绑定Repeater控件，显示调查中的大类   
52.   
53.         /// </summary>   
54.   
55.         public void BindRep()   
56.   
57.         {   
58.   
59.             string strsql = "select * from cms_vote where FProID='"+db.q("id")+"'";   
60.   
61.             db.dp.CommandText = strsql;   
62.   
63.             DataTable dt = db.dp.DataTableSQL();   
64.   
65.             if(dt.Rows.Count>0)   
66.   
67.             {   
68.   
69.                 this.Repeater1.DataSource = dt;   
70.   
71.                 this.Repeater1.DataBind();   
72.   
73.             }   
74.   
75.         }  
76.  
77.  
78.  
79.         #region Web 窗体设计器生成的代码   
80.   
81.         override protected void OnInit(EventArgs e)   
82.   
83.         {   
84.   
85.             //   
86.   
87.             // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。   
88.   
89.             //   
90.   
91.             InitializeComponent();   
92.   
93.             base.OnInit(e);   
94.   
95.         }   
96.   
97.            
98.   
99.         /// <summary>   
100.   
101.         /// 设计器支持所需的方法 - 不要使用代码编辑器修改   
102.   
103.         /// 此方法的内容。   
104.   
105.         /// </summary>   
106.   
107.         private void InitializeComponent()   
108.   
109.         {       
110.   
111.             this.Repeater1.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.Repeater1_ItemDataBound);   
112.   
113.             this.Load += new System.EventHandler(this.Page_Load);   
114.   
115.   
116.   
117.         }  
118.  
119.         #endregion   
120.   
121.   
122.   
123.         private void Repeater1_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)   
124.   
125.         {   
126.   
127.             Repeater rep  = (Repeater)e.Item.FindControl("rep");   
128.   
129.   
130.   
131.             DataRowView rowv = (DataRowView)e.Item.DataItem;   
132.   
133.             //提取分类ID   
134.   
135.             string Fid  = rowv["FVoteId"].ToString();   
136.   
137.   
138.   
139.             string strsql = "select * from cms_VoteItem where FVoteId='"+Fid+"'";   
140.   
141.   
142.   
143.                
144.   
145.   
146.   
147.             //Response.Write("<script>alert('"+strsql+"');</script>");   
148.   
149.             db.dp.CommandText = strsql;   
150.   
151.             DataTable dt = db.dp.DataTableSQL();   
152.   
153.   
154.   
155.             rep.DataSource = dt;   
156.   
157.             rep.DataBind();   
158.   
159.         }   
160.   
161.   
162.   
163.   
164.   
165.         public string IsView(string cid,string num)   
166.   
167.         {   
168.   
169.             string strsql = "select sum(FItemNum) from cms_VoteItem where FVoteId='"+cid+"'";   
170.   
171.             db.dp.CommandText = strsql;   
172.   
173.             DataTable dt = db.dp.DataTableSQL();   
174.   
175.             double Sums = Convert.ToInt32(dt.Rows[0][0].ToString());   
176.   
177.             if(num=="0")   
178.   
179.                 return "0%";   
180.   
181.             else  
182.   
183.                 return (Convert.ToDouble(num)/Sums).ToString("P");   
184.   
185.         }   
186.   
187.   
188.   
189.         public string IsViews(string cid,string num)   
190.   
191.         {   
192.   
193.             string strsql = "select sum(FItemNum) from cms_VoteItem where FVoteId='"+cid+"'";   
194.   
195.             db.dp.CommandText = strsql;   
196.   
197.             DataTable dt = db.dp.DataTableSQL();   
198.   
199.             double Sums = Convert.ToInt32(dt.Rows[0][0].ToString());   
200.   
201.             if(num=="0")   
202.   
203.                 return "0%";   
204.   
205.             else  
206.   
207.                 return (Convert.ToDouble(num)/Sums*300).ToString();   
208.   
209.         }  

protected System.Web.UI.WebControls.Repeater Repeater1;



		public Seaskyer.Modules.Utils.DBClass db = new Seaskyer.Modules.Utils.DBClass();



		public string Title;



		//public string cid;

	

		private void Page_Load(object sender, System.EventArgs e)

		{

			if(!Page.IsPostBack)

			{

				string cid = "";

				if(db.q("id")!="")

				{

					cid=db.q("id");

				}



				Title = db.getSingleValue("cms_VotePro","FProName","FID",cid);



				BindRep();

			}

		}



		/// <summary>

		/// 绑定Repeater控件，显示调查中的大类

		/// </summary>

		public void BindRep()

		{

			string strsql = "select * from cms_vote where FProID='"+db.q("id")+"'";

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();

			if(dt.Rows.Count>0)

			{

				this.Repeater1.DataSource = dt;

				this.Repeater1.DataBind();

			}

		}



		#region Web 窗体设计器生成的代码

		override protected void OnInit(EventArgs e)

		{

			//

			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

			//

			InitializeComponent();

			base.OnInit(e);

		}

		

		/// <summary>

		/// 设计器支持所需的方法 - 不要使用代码编辑器修改

		/// 此方法的内容。

		/// </summary>

		private void InitializeComponent()

		{    

			this.Repeater1.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.Repeater1_ItemDataBound);

			this.Load += new System.EventHandler(this.Page_Load);



		}

		#endregion



		private void Repeater1_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)

		{

		    Repeater rep  = (Repeater)e.Item.FindControl("rep");



			DataRowView rowv = (DataRowView)e.Item.DataItem;

			//提取分类ID

			string Fid  = rowv["FVoteId"].ToString();



			string strsql = "select * from cms_VoteItem where FVoteId='"+Fid+"'";



			



			//Response.Write("<script>alert('"+strsql+"');</script>");

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();



			rep.DataSource = dt;

			rep.DataBind();

		}





		public string IsView(string cid,string num)

		{

            string strsql = "select sum(FItemNum) from cms_VoteItem where FVoteId='"+cid+"'";

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();

			double Sums = Convert.ToInt32(dt.Rows[0][0].ToString());

			if(num=="0")

				return "0%";

			else

			    return (Convert.ToDouble(num)/Sums).ToString("P");

		}



		public string IsViews(string cid,string num)

		{

			string strsql = "select sum(FItemNum) from cms_VoteItem where FVoteId='"+cid+"'";

			db.dp.CommandText = strsql;

			DataTable dt = db.dp.DataTableSQL();

			double Sums = Convert.ToInt32(dt.Rows[0][0].ToString());

			if(num=="0")

				return "0%";

			else

				return (Convert.ToDouble(num)/Sums*300).ToString();

		}

其中的表cms_VotePro是记录复式的主标题 cms_vote是记录投票项 cms_VoteItem是最后的小项了