July « 2010 « extremeweblog.com

20Jul

Specifying values for In clause in SP from C#

Filed in .Net | SQL Leave a comment

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

19Jul

Client side checking in GridView that at least on checkbox is selected

Filed in .Net Leave a comment

http://www.codeproject.com/KB/webforms/GridViewcheckBoxes.aspx

Found a very good article on the above link

<span class="code-keyword">&lt;</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">&gt;</span>

<asp:Button ID="btnPost" runat="server" Text="Post"

OnClientClick="javascript:return TestCheckBox();"

OnClick="btnPost_Click" />

<span class="code-keyword">
</span>

1 2	<span class="code-keyword"> </span>

&lt;script type=<span class="code-string">"</span><span class="code-string">text/javascript"</span>&gt;
   <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">&lt;%= this.GridView1.ClientID %&gt;'</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 &lt; Inputs.length; ++n)
         <span class="code-keyword">if</span>(Inputs[n].type == <span class="code-string">'</span><span class="code-string">checkbox'</span> &amp;&amp;
            Inputs[n].id.indexOf(TargetChildControl,<span class="code-digit">0</span>) &gt;= <span class="code-digit">0</span> &amp;&amp;
            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">&lt;/</span><span class="code-leadattribute">script</span><span class="code-keyword">&gt;</span>

var TargetBaseControl = null;

window.onload = function()

{

try

{

//get target base control.

TargetBaseControl =

document.getElementById('<%= this.GridView1.ClientID %>');

}

catch(err)

{

TargetBaseControl = null;

}

function TestCheckBox()

{

if(TargetBaseControl == null) return false;

//get target child control.

var TargetChildControl = "chkBxSelect";

//get all the control of the type INPUT in the base control.

var Inputs = TargetBaseControl.getElementsByTagName("input");

for(var n = 0; n < Inputs.length; ++n)

if(Inputs[n].type == 'checkbox' &&

Inputs[n].id.indexOf(TargetChildControl,0) >= 0 &&

Inputs[n].checked)

return true;

alert('Select at least one checkbox!');

return false;

}

</script>

19Jul

Adding .flv file format in IIS MIME

Filed in .Net Leave a comment

On the Windows 2003 server, open the Internet Information Services Manager.

Expand the Local Computer Server.
Right-click the local computer server and select Properties.
Select the MIME Types tab.
Click New and enter the following information:
Associated Extension box: .flv
MIME Type box: video/x-flv
Click OK.
Restart the World Wide Web Publishing service

M	T	W	T	F	S	S
« Jun				Oct »
			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