select * from pk where charindex(‘,’+cast(pkid as varchar(50))+’ ‘,’,12 ,13 ‘,1) > 0
But I think i would be slow if you have large data
Blog by Shoaib Azeem
Filed in Uncategorized Leave a comment
select * from pk where charindex(‘,’+cast(pkid as varchar(50))+’ ‘,’,12 ,13 ‘,1) > 0
Filed in Uncategorized Leave a comment
http://www.codeproject.com/KB/webforms/GridViewcheckBoxes.aspx
Found a very good article on the above link
1 2 3 |
<span class="code-keyword"><</span><span class="code-leadattribute">asp:Button</span> <span class="code-attribute">ID</span><span class="code-keyword">="</span><span class="code-keyword">btnPost"</span> <span class="code-attribute">runat</span><span class="code-keyword">="</span><span class="code-keyword">server"</span> <span class="code-attribute">Text</span><span class="code-keyword">="</span><span class="code-keyword">Post"</span> <span class="code-attribute">OnClientClick</span><span class="code-keyword">="</span><span class="code-keyword">javascript:return TestCheckBox();"</span> <span class="code-attribute">OnClick</span><span class="code-keyword">="</span><span class="code-keyword">btnPost_Click"</span> <span class="code-keyword">/</span><span class="code-keyword">></span> |
1 2 |
<span class="code-keyword"> </span> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
<script type=<span class="code-string">"</span><span class="code-string">text/javascript"</span>> <span class="code-keyword">var</span> TargetBaseControl = <span class="code-keyword">null</span>; window.onload = <span class="code-keyword">function</span>() { <span class="code-keyword">try</span> { <span class="code-comment">//</span><span class="code-comment">get target base control.</span> TargetBaseControl = document.getElementById(<span class="code-string">'</span><span class="code-string"><%= this.GridView1.ClientID %>'</span>); } <span class="code-keyword">catch</span>(err) { TargetBaseControl = <span class="code-keyword">null</span>; } } <span class="code-keyword">function</span> TestCheckBox() { <span class="code-keyword">if</span>(TargetBaseControl == <span class="code-keyword">null</span>) <span class="code-keyword">return</span> <span class="code-keyword">false</span>; <span class="code-comment">//</span><span class="code-comment">get target child control.</span> <span class="code-keyword">var</span> TargetChildControl = <span class="code-string">"</span><span class="code-string">chkBxSelect"</span>; <span class="code-comment">//</span><span class="code-comment">get all the control of the type INPUT in the base control.</span> <span class="code-keyword">var</span> Inputs = TargetBaseControl.getElementsByTagName(<span class="code-string">"</span><span class="code-string">input"</span>); <span class="code-keyword">for</span>(<span class="code-keyword">var</span> n = <span class="code-digit">0</span>; n < Inputs.length; ++n) <span class="code-keyword">if</span>(Inputs[n].type == <span class="code-string">'</span><span class="code-string">checkbox'</span> && Inputs[n].id.indexOf(TargetChildControl,<span class="code-digit">0</span>) >= <span class="code-digit">0</span> && Inputs[n].checked) <span class="code-keyword">return</span> <span class="code-keyword">true</span>; alert(<span class="code-string">'</span><span class="code-string">Select at least one checkbox!'</span>); <span class="code-keyword">return</span> <span class="code-keyword">false</span>; } <span class="code-keyword"></</span><span class="code-leadattribute">script</span><span class="code-keyword">></span> |
Filed in Uncategorized Leave a comment
On the Windows 2003 server, open the Internet Information Services Manager.