<div>
 foreach (Control ctrl in this.Controls)<br />
&nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (ctrl is CheckBox)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CheckBox chk = (CheckBox)ctrl as CheckBox;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (chk.Checked)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Code to add to query <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />
&nbsp; &nbsp; &nbsp; &nbsp; }
</div>


foreach (Control ctrl in this.Controls)
        {
            if (ctrl is CheckBox)
            {
                CheckBox chk = (CheckBox)ctrl as CheckBox;
                if (chk.Checked)
                {
                    //Code to add to query
                }
            }
        }

<div>
Thanks but I have about 20 checkboxes how do I know if say checkbox20 is equal to cookery?
</div>


Thanks but I have about 20 checkboxes how do I know if say checkbox20 is equal to cookery?

<div>
<div class="content wysiwyg-content">
I have a checkbox list control that contains about 20 checkboxes that capture an individuals interests. &nbsp;For example, fishing, music, cookery etc<br />
<br />
I need to use these checkboxes as a search for a dynamic query to sql server. &nbsp;So if &quot;cookery&quot; is checked then I alter my sql query like this<br />
<br />
&nbsp; &nbsp;if (checkbox number 23 is checked) &nbsp; &nbsp; &nbsp; //it must be cookery so add it to our WHERE clause<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oClause.column = &quot;[Cookery]&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oClause.operand = &quot;&nbsp;= &quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oClause.criteria = &quot;1&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cClauses.Add(oClause);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />
<br />
What is the best way to loop through the checkbox list to add checked items to my sql query?<br />
<br />

</div>
</div>


I have a checkbox list control that contains about 20 checkboxes that capture an individuals interests.  For example, fishing, music, cookery etc

I need to use these checkboxes as a search for a dynamic query to sql server.  So if "cookery" is checked then I alter my sql query like this

   if (checkbox number 23 is checked)       //it must be cookery so add it to our WHERE clause
            {
                oClause.column = "[Cookery]";
                oClause.operand = " = ";
                oClause.criteria = "1";
                cClauses.Add(oClause);
            }

What is the best way to loop through the checkbox list to add checked items to my sql query?



Loop though checkbox list asp.net c#

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).