<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2643030478504447675</id><updated>2011-07-30T21:33:58.142+05:30</updated><category term='Blogger'/><category term='FTP'/><title type='text'>.Net Climbers</title><subtitle type='html'>Your climbing start's here, from basic to master.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-504232271020468671</id><published>2010-02-03T10:37:00.000+05:30</published><updated>2010-02-03T10:39:06.625+05:30</updated><category scheme='http://www.blogger.com/atom/ns#' term='FTP'/><category scheme='http://www.blogger.com/atom/ns#' term='Blogger'/><title type='text'>Important: Changes to Blogger FTP Service</title><content type='html'>Google Blogger is Going to Stop its services of allowing to host your blog on FTP.&lt;br /&gt;Please read the notice below i have received one from GOOGLE.COM&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.induway.com/"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 150px; height: 40px;" src="http://www.blogger.com/img/logo40.png" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;div&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;Dear FTP  user:&lt;/span&gt;&lt;/span&gt; &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;You are receiving this  e-mail because one or more of your blogs at Blogger.com are set up to publish  via FTP. We recently announced a planned shut-down of FTP support on Blogger  Buzz (the official Blogger blog),  and wanted to make sure you saw the  announcement. We will be following up with more information via e-mail in the  weeks ahead, and regularly updating a blog dedicated to this service shut-down  here: &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://blogger-ftp.blogspot.com/" target="_blank"&gt;http://blogger-ftp.blogspot.&lt;wbr&gt;com/&lt;/a&gt;.  &lt;/span&gt;&lt;/span&gt;  &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;The full text of the  announcement at Blogger Buzz follows.&lt;/span&gt;&lt;/span&gt; &lt;/div&gt; &lt;blockquote style="border: medium none ; margin: 0px 0px 0px 40px;"&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;Last May, &lt;a title="we talked at length about a number of challenges facing Blogger users" style="color: rgb(85, 26, 139); text-decoration: none;" onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html" target="_blank"&gt;we discussed a number of challenges facing&lt;/a&gt;[1] Blogger users  who relied on FTP to publish their blogs. FTP remains a significant drain on our  ability to improve Blogger: &lt;b&gt;only .5% of active blogs are published via  FTP &lt;/b&gt;— yet the percentage of our engineering resources devoted to supporting  FTP vastly exceeds that. On top of this, critical infrastructure that our FTP  support relies on at Google will soon become unavailable, which would require  that we completely rewrite the code that handles our FTP  processing.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;&lt;br /&gt;Three years ago we &lt;a title="launched Custom Domains three years ago" style="color: rgb(85, 26, 139); text-decoration: none;" onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2007/01/blogger-custom-domains.html" target="_blank"&gt; &lt;script&gt;&lt;!-- D(["mb","launched Custom Domains\u003c/a\u003e[2] to give users the simplicity of Blogger, the scalability of Google hosting, and the flexibility of hosting your blog at your own URL. Last year\u0026#39;s post \u003ca href\u003d\"http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html\" style\u003d\"color:#551a8b;text-decoration:none\" title\u003d\"we discussed the reasons many users remain on FTP\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ediscussed the advantages of custom domains over FTP\u003c/a\u003e[3] and addressed a number of reasons users have continued to use FTP publishing. (If you\u0026#39;re interested in reading more about Custom Domains, our Help Center has a \u003ca href\u003d\"http://www.google.com/support/blogger/bin/answer.py?hl\u003den\u0026amp;answer\u003d55373\" style\u003d\"color:#551a8b;text-decoration:none\" title\u003d\"good overview\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003egood overview\u003c/a\u003e[4] of how to use them on your blog.) In evaluating the investment needed to continue supporting FTP, we have decided that we could not justify diverting further engineering resources away from building new features for all users.\u003c/font\u003e\u003c/font\u003e\u003cbr\u003e\n  \u003cfont face\u003d\"georgia, serif\"\u003e\u003cfont color\u003d\"#333333\"\u003e\u003cbr\u003e\n  For that reason, \u003cb\u003ewe are announcing today that we will no longer support FTP publishing in Blogger after March 26, 2010\u003c/b\u003e. We realize that this will not necessarily be welcome news for some users, and we are committed to making the transition as seamless as possible. To that end:\u003cbr\u003e\n  \u003c/font\u003e\u003c/font\u003e\u003cbr\u003e\n\n\u003c/blockquote\u003e\n\u003cul\u003e\n  \u003cul\u003e\n    \u003cli\u003e\n      \u003cfont face\u003d\"georgia, serif\"\u003e\u003cfont color\u003d\"#333333\"\u003e\u003cb\u003eWe are building a migration tool\u003c/b\u003e\u003c/font\u003e\u003c/font\u003e that will walk users through a migration from their current URL to a Blogger-managed URL (either a Custom Domain or a Blogspot URL) \u003cb\u003ethat will be available to all users the week of February 22\u003c/b\u003e. This tool will handle redirecting traffic from the old URL to the new URL, and will handle the vast majority of situations.\n    \u003c/li\u003e\n    \u003cli\u003e\n      \u003cfont face\u003d\"georgia, serif\"\u003e\u003cfont color\u003d\"#333333\"\u003e",1] );  //--&gt;&lt;/script&gt; launched Custom Domains&lt;/a&gt;[2] to give users the simplicity of Blogger, the  scalability of Google hosting, and the flexibility of hosting your blog at your  own URL. Last year's post &lt;a title="we discussed the reasons many users remain on FTP" style="color: rgb(85, 26, 139); text-decoration: none;" onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html" target="_blank"&gt;discussed the advantages of custom domains over FTP&lt;/a&gt;[3] and  addressed a number of reasons users have continued to use FTP publishing. (If  you're interested in reading more about Custom Domains, our Help Center has a &lt;a title="good overview" style="color: rgb(85, 26, 139); text-decoration: none;" onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.google.com/support/blogger/bin/answer.py?hl=en&amp;amp;answer=55373" target="_blank"&gt;good overview&lt;/a&gt;[4] of how to use them on your blog.) In  evaluating the investment needed to continue supporting FTP, we have decided  that we could not justify diverting further engineering resources away from  building new features for all users.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;&lt;br /&gt;For that reason, &lt;b&gt;we are  announcing today that we will no longer support FTP publishing in Blogger after  March 26, 2010&lt;/b&gt;. We realize that this will not necessarily be welcome news  for some users, and we are committed to making the transition as seamless as  possible. To that end:&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/blockquote&gt; &lt;ul&gt;&lt;ul&gt;&lt;li&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;&lt;b&gt;We are building a  migration tool&lt;/b&gt;&lt;/span&gt;&lt;/span&gt; that will walk users through a migration from  their current URL to a Blogger-managed URL (either a Custom Domain or a Blogspot  URL) &lt;b&gt;that will be available to all users the week of February 22&lt;/b&gt;. This  tool will handle redirecting traffic from the old URL to the new URL, and will  handle the vast majority of situations.  &lt;/li&gt;&lt;li&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt; &lt;script&gt;&lt;!-- D(["mb","\u003cb\u003eWe will be providing a \u003ca href\u003d\"http://blogger-ftp.blogspot.com/\" style\u003d\"color:#551a8b;text-decoration:none\" title\u003d\"dedicated blog\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ededicated blog\u003c/a\u003e[5] and help documentation\u003c/b\u003e\u003c/font\u003e\u003c/font\u003e\n\n    \u003c/li\u003e\n    \u003cli\u003e\n      \u003cfont face\u003d\"georgia, serif\"\u003e\u003cfont color\u003d\"#333333\"\u003e\u003cb\u003eBlogger team members will also be available to answer questions on the forum, comments on the blog, and in a few scheduled conference calls once the tool is released\u003c/b\u003e\u003c/font\u003e\u003c/font\u003e.\n    \u003c/li\u003e\n  \u003c/ul\u003e\n\u003c/ul\u003e\n\u003cblockquote style\u003d\"border:none;margin:0 0 0 40px\"\u003e\n  \u003cbr\u003e\n  \u003cfont face\u003d\"georgia, serif\"\u003e\u003cfont color\u003d\"#333333\"\u003eWe have a number of big releases planned in 2010. While we recognize that this decision will frustrate some users, we look forward to showing you the many great things on the way. Thanks for using Blogger.\u003c/font\u003e\u003c/font\u003e\n\n\u003c/blockquote\u003e\n\u003cdiv style\u003d\"text-align:auto\"\u003e\n  \u003cbr\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  Regards,\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  \u003cbr\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  Rick Klau\n\u003c/div\u003e\n\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  Blogger Product Manager\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  Google\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  1600 Amphitheatre Parkway\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  Mountain View, CA 94043\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n\n  \u003cbr\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  [1] \u003ca href\u003d\"http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ehttp://buzz.blogger.com/2009/\u003cWBR\u003e05/ftp-vs-custom-domains.html\u003c/a\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  [2] \u003ca href\u003d\"http://buzz.blogger.com/2007/01/blogger-custom-domains.html\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ehttp://buzz.blogger.com/2007/\u003cWBR\u003e01/blogger-custom-domains.html\u003c/a\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  [3] \u003ca href\u003d\"http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003e",1] );  //--&gt;&lt;/script&gt; &lt;b&gt;We will be providing a &lt;a title="dedicated blog" style="color: rgb(85, 26, 139); text-decoration: none;" onclick="return top.js.OpenExtLink(window,event,this)" href="http://blogger-ftp.blogspot.com/" target="_blank"&gt;dedicated blog&lt;/a&gt;[5] and  help documentation&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;  &lt;/li&gt;&lt;li&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;&lt;b&gt;Blogger team members will  also be available to answer questions on the forum, comments on the blog, and in  a few scheduled conference calls once the tool is released&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;.  &lt;/li&gt;&lt;/ul&gt;&lt;/ul&gt; &lt;blockquote style="border: medium none ; margin: 0px 0px 0px 40px;"&gt;&lt;br /&gt;&lt;span style="font-family:georgia, serif;"&gt;&lt;span style="color:#333333;"&gt;We have a number of big releases  planned in 2010. While we recognize that this decision will frustrate some  users, we look forward to showing you the many great things on the way. Thanks  for using Blogger.&lt;/span&gt;&lt;/span&gt; &lt;/blockquote&gt; &lt;div&gt;&lt;br /&gt;&lt;/div&gt; &lt;div style="text-align: left;"&gt;Regards, &lt;/div&gt; &lt;div style="text-align: left;"&gt;&lt;br /&gt;&lt;/div&gt; &lt;div style="text-align: left;"&gt;Rick Klau &lt;/div&gt; &lt;div style="text-align: left;"&gt;Blogger Product Manager &lt;/div&gt; &lt;div style="text-align: left;"&gt;Google &lt;/div&gt; &lt;div style="text-align: left;"&gt;1600 Amphitheatre Parkway &lt;/div&gt; &lt;div style="text-align: left;"&gt;Mountain View, CA 94043 &lt;/div&gt; &lt;div style="text-align: left;"&gt;&lt;br /&gt;&lt;/div&gt; &lt;div style="text-align: left;"&gt;[1] &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html" target="_blank"&gt;http://buzz.blogger.com/2009/&lt;wbr&gt;05/ftp-vs-custom-domains.html&lt;/a&gt;  &lt;/div&gt; &lt;div style="text-align: left;"&gt;[2] &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2007/01/blogger-custom-domains.html" target="_blank"&gt;http://buzz.blogger.com/2007/&lt;wbr&gt;01/blogger-custom-domains.html&lt;/a&gt;  &lt;/div&gt; &lt;div style="text-align: left;"&gt;[3] &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://buzz.blogger.com/2009/05/ftp-vs-custom-domains.html" target="_blank"&gt; &lt;script&gt;&lt;!-- D(["mb","http://buzz.blogger.com/2009/\u003cWBR\u003e05/ftp-vs-custom-domains.html\u003c/a\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  [4] \u003ca href\u003d\"http://www.google.com/support/blogger/bin/answer.py?hl\u003den\u0026amp;answer\u003d55373\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ehttp://www.google.com/support/\u003cWBR\u003eblogger/bin/answer.py?hl\u003den\u0026amp;\u003cWBR\u003eanswer\u003d55373\u003c/a\u003e\n\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  [5] \u003ca href\u003d\"http://blogger-ftp.blogspot.com/\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\u003ehttp://blogger-ftp.blogspot.\u003cWBR\u003ecom/\u003c/a\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  \u003cbr\u003e\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  ----\n\u003c/div\u003e\n\u003cdiv style\u003d\"text-align:left\"\u003e\n  This e-mail is being sent to notify you of important changes to your Blogger account.\n\u003c/div\u003e\n\n\u003cbr\u003e\u003c/div\u003e\n\u003c/span\u003e\u003c/div\u003e",0] ); D(["ce"]);  //--&gt;&lt;/script&gt; http://buzz.blogger.com/2009/&lt;wbr&gt;05/ftp-vs-custom-domains.html&lt;/a&gt; &lt;/div&gt; &lt;div style="text-align: left;"&gt;[4] &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.google.com/support/blogger/bin/answer.py?hl=en&amp;amp;answer=55373" target="_blank"&gt;http://www.google.com/support/&lt;wbr&gt;blogger/bin/answer.py?hl=en&amp;amp;&lt;wbr&gt;answer=55373&lt;/a&gt;  &lt;/div&gt; &lt;div style="text-align: left;"&gt;[5] &lt;a onclick="return top.js.OpenExtLink(window,event,this)" href="http://blogger-ftp.blogspot.com/" target="_blank"&gt;http://blogger-ftp.blogspot.&lt;wbr&gt;com/&lt;/a&gt; &lt;/div&gt; &lt;div style="text-align: left;"&gt;&lt;br /&gt;&lt;/div&gt; &lt;div style="text-align: left;"&gt;---- &lt;/div&gt; &lt;div style="text-align: left;"&gt;This e-mail is being sent to notify you of  important changes to your Blogger account. &lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-504232271020468671?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/504232271020468671/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2010/02/important-changes-to-blogger-ftp.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/504232271020468671'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/504232271020468671'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2010/02/important-changes-to-blogger-ftp.html' title='Important: Changes to Blogger FTP Service'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-6491339345923905426</id><published>2009-08-24T12:57:00.000+05:30</published><updated>2009-08-24T14:24:43.332+05:30</updated><title type='text'>How to open new tab in the browser with button click ?</title><content type='html'>Hello,&lt;br /&gt;&lt;br /&gt;Please find below code that can help you to solve your problem of opening page in new tab of browser.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;use this below code in the code behind&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;btnPrint.Attributes.Add ("OnClick","openwindow()");&lt;br /&gt;&lt;br /&gt;and &lt;span style="font-weight:bold;"&gt;use this code in the head tag&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;script type="text/javascript" language="javascript"&amp;gt;&lt;br /&gt;&lt;br /&gt;      function openwindow()&lt;br /&gt; {&lt;br /&gt; window.open ("PrintReport.aspx",'','width=1000px,height=600px,menubar=yes,scrollbars=yes,&lt;br /&gt;left=0,top=0');      &lt;br /&gt; }&lt;br /&gt;&amp;lt;/script&amp;gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Thankyou&lt;/span&gt;,&lt;br /&gt;Rajesh Singh&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.indianic.com/"&gt;Indianic Infotech ltd&lt;/a&gt; (India)&lt;br /&gt;rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-6491339345923905426?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/6491339345923905426/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/how-to-open-new-tab-in-browser-with.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/6491339345923905426'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/6491339345923905426'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/how-to-open-new-tab-in-browser-with.html' title='How to open new tab in the browser with button click ?'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-7896293207168830860</id><published>2009-08-24T12:47:00.000+05:30</published><updated>2009-08-24T13:50:52.138+05:30</updated><title type='text'>Birth date must Not be greater than today's Date</title><content type='html'>Hello,&lt;br /&gt;&lt;br /&gt;This is one of the important validation that you need to take care, when user enter's data in form.&lt;br /&gt;&lt;br /&gt;Most of the time user tries to enters his/her birth date higher than today's date, so this is poor validation.&lt;br /&gt;&lt;br /&gt;Please find few line code below that will help you comparing users birth date which should be lower than today's date.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;//---------------code of code behind -------------------&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;If Trim(txtBirthDate.Text) = "" Then&lt;br /&gt;     Else&lt;br /&gt;         Dim textboxdate As Date = Convert.ToDateTime(txtBirthDate.Text).Date&lt;br /&gt;         Dim todaysdate As Date = DateTime.Now.Date&lt;br /&gt;         If textboxdate &gt;= todaysdate Then&lt;br /&gt;             datelabel.Visible = True&lt;br /&gt;             datelabel.Text = "Birth date must Not be greater than today's Date"&lt;br /&gt;             flag = False&lt;br /&gt;         End If&lt;br /&gt;     End If&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;//------------------ code ends -------------------------&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;//---------------code for front end --------------------&lt;/span&gt;&lt;br /&gt; &lt;br /&gt;&amp;lt;td&amp;gt;&lt;br /&gt;    &amp;lt;div id="datediv"&amp;gt;&lt;br /&gt;        &amp;lt;asp:Label ID="datelabel" runat="server"&amp;gt;&amp;lt;/asp:Label&amp;gt;&lt;br /&gt;    &amp;lt;/div&amp;gt;&lt;br /&gt;&amp;lt;/td&amp;gt;&amp;gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;//-------------------code ends -------------------------&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Hope this post will help you,&lt;br /&gt;Rajesh Singh,&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.indianic.com/"&gt;Indianic Infotech ltd&lt;/a&gt; (India)&lt;br /&gt;rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-7896293207168830860?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/7896293207168830860/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/birth-date-must-not-be-greater-than.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/7896293207168830860'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/7896293207168830860'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/birth-date-must-not-be-greater-than.html' title='Birth date must Not be greater than today&apos;s Date'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-5368309005260398916</id><published>2009-08-21T15:10:00.000+05:30</published><updated>2009-08-21T15:13:07.132+05:30</updated><title type='text'>Different Types of Methods in VB.NET</title><content type='html'>There are two types of methods in VB .NET: &lt;br /&gt;&lt;br /&gt;those that return a value (Functions) &lt;br /&gt;and those that do not return a value (Sub Procedures)&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Sub Procedures&lt;/span&gt; ( do not return a value )&lt;br /&gt;--------------------&lt;br /&gt;Sub Main()&lt;br /&gt;'sub procedure Main() is called by default&lt;br /&gt;Display()&lt;br /&gt;'sub procedure display() which we are creating&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Sub Display()&lt;br /&gt;MsgBox("Using Sub Procedures")&lt;br /&gt;'executing sub procedure Display()&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Functions&lt;/span&gt; ( return a value )&lt;br /&gt;-------------&lt;br /&gt;Sub Main()&lt;br /&gt;Write("Sum is" &amp; " " &amp; Add())&lt;br /&gt;'calling the function&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Public Function Add() As Integer&lt;br /&gt;'declaring a function add&lt;br /&gt;Dim i, j As Integer&lt;br /&gt;'declaring two integers and assigning values to them&lt;br /&gt;i = 10&lt;br /&gt;j = 20&lt;br /&gt;Return (i + j)&lt;br /&gt;'performing the sum of two integers and returning it's value&lt;br /&gt;End Function&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Hope this post will help you&lt;/span&gt;,&lt;br /&gt;Rajesh Singh&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.Indianic.com/"&gt;Indianic Infotech Ltd&lt;/a&gt; (India)&lt;br /&gt;Rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-5368309005260398916?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/5368309005260398916/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/different-types-of-methods-in-vbnet.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/5368309005260398916'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/5368309005260398916'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/different-types-of-methods-in-vbnet.html' title='Different Types of Methods in VB.NET'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-4934783965475012756</id><published>2009-08-20T18:38:00.001+05:30</published><updated>2009-08-20T18:40:19.126+05:30</updated><title type='text'>C# Code to Delete All file from the Folder</title><content type='html'>You can Copy below code and paste in your code file.&lt;br /&gt;&lt;br /&gt;//-----------------------Code Start here----------------------------&lt;br /&gt;&lt;br /&gt;protected void CleanImageFolder()&lt;br /&gt;{&lt;br /&gt;    string imgFolder = Server.MapPath("~/lab/maskemail/img/");&lt;br /&gt;    string[] imgList = Directory.GetFiles(imgFolder, "*.jpg");&lt;br /&gt;    foreach (string img in imgList)&lt;br /&gt;    {&lt;br /&gt;        FileInfo imgInfo = new FileInfo(img);&lt;br /&gt;        if (imgInfo.LastWriteTime &lt; DateTime.Now.AddMinutes(-3))&lt;br /&gt;        {&lt;br /&gt;            imgInfo.Delete();&lt;br /&gt;        }&lt;br /&gt;    }&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;//-----------------------Code End here----------------------------&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Hope this post will help you&lt;/span&gt;,&lt;br /&gt;Rajesh Singh&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.indianic.com/"&gt;Indianic Infotech Ltd&lt;/a&gt; (India)&lt;br /&gt;Rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-4934783965475012756?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/4934783965475012756/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/c-code-to-delete-all-file-from-folder.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/4934783965475012756'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/4934783965475012756'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/c-code-to-delete-all-file-from-folder.html' title='C# Code to Delete All file from the Folder'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-1741940867137046373</id><published>2009-08-20T17:51:00.001+05:30</published><updated>2009-08-25T12:08:24.268+05:30</updated><title type='text'>Contact Us</title><content type='html'>&lt;!-- Begin myContactForm.com Form HTML --&gt;&lt;br /&gt;&lt;form name="contactForm" method="post" action="http://www.mycontactform.com/sendform/sendform.php"&gt;&lt;br /&gt;&lt;input name="user" type="hidden" id="user" value="rajeshsingh" /&gt;&lt;input name="formid" type="hidden" id="formid" value="243864" /&gt;&lt;input name="subject" type="hidden" id="subject" value="SomeOne Contacted DotNet Climber" /&gt;&lt;br /&gt;&lt;table width="100%" style="border: 0px solid #000000; margin: 0; padding: 0; background-color: #E3E2E0;"&gt;&lt;tr&gt;&lt;td&gt;&lt;br /&gt;&lt;table width="100%" border="0" cellspacing="0" cellpadding="5"&gt;&lt;br /&gt;&lt;tr bgcolor="#E3E2E0"&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;Name&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;&lt;input name="q[1]" type="text" value="" size="20" maxlength="" style="font-family: Arial; font-size: 14px; font-weight: normal; color: #000000; background-color: #FFFFFF; border: 1px solid #000000; vertical-align: middle; padding-left: 4px;" /&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr bgcolor="#E3E2E0"&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt; E-mail Address:&lt;font color="#FF0000"&gt; *&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;input name="email" type="text" id="email" size="20" maxlength="100" style="font-family: Arial; font-size: 14px; font-weight: normal; color: #000000; background-color: #FFFFFF; border: 1px solid #000000; vertical-align: middle; padding-left: 4px;" /&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr bgcolor="#E3E2E0"&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;Phone&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;&lt;input name="q[3]" type="text" value="" size="50" maxlength="" style="font-family: Arial; font-size: 14px; font-weight: normal; color: #000000; background-color: #FFFFFF; border: 1px solid #000000; vertical-align: middle; padding-left: 4px;" /&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr bgcolor="#E3E2E0"&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;Purpose of Contact&lt;font color="#FF0000"&gt; *&lt;/font&gt;&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;&lt;input name="q[4]" type="text" value="" size="50" maxlength="" style="font-family: Arial; font-size: 14px; font-weight: normal; color: #000000; background-color: #FFFFFF; border: 1px solid #000000; vertical-align: middle; padding-left: 4px;" /&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr bgcolor="#E3E2E0"&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;Message&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;font color="#000000" size="2" face="Arial"&gt;&lt;textarea name="q[5]" cols="50" rows="2" style="font-family: Arial; font-size: 14px; font-weight: normal; color: #000000; background-color: #FFFFFF; border: 1px solid #000000; vertical-align: middle; padding-left: 4px;"&gt;&lt;/textarea&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan="2"&gt;&lt;hr size="1" /&gt;&lt;/td&gt;&lt;/tr&gt;&lt;br /&gt;&lt;tr&gt;&lt;td colspan="2"&gt;&lt;input name="submit" type="submit" style="background-color: #CCCCCC; font-family: Arial; font-size: 16px; color: #000000; border-bottom:2px solid #000000; border-right:2px solid #000000; border-top:2px solid #000000; border-left:2px solid #000000" value="Submit" /&gt; &lt;input name="reset" type="reset" style="background-color: #CCCCCC; font-family: Arial; font-size: 16px; color: #000000; border-bottom:2px solid #000000; border-right:2px solid #000000; border-top:2px solid #000000; border-left:2px solid #000000" value="Reset" /&gt; &lt;/td&gt;&lt;/tr&gt;&lt;br /&gt;&lt;tr&gt;&lt;td&gt;&lt;font color="#FF0000" size="1" face="Verdana, Arial, Helvetica, sans-serif"&gt;&lt;b&gt;*&lt;/b&gt;&lt;/font&gt; &lt;font size="1" face="Verdana, Arial, Helvetica, sans-serif"&gt;Required&lt;/font&gt;&lt;/td&gt;&lt;td align="right"&gt;&lt;font size="1" face="Verdana, Arial, Helvetica, sans-serif"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;br /&gt;&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/form&gt;&lt;br /&gt;&lt;!-- End myContactForm.com Form HTML --&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-1741940867137046373?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/1741940867137046373/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/contact-us.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/1741940867137046373'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/1741940867137046373'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/contact-us.html' title='Contact Us'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-574328562462326600</id><published>2009-08-20T16:55:00.000+05:30</published><updated>2009-08-20T17:00:48.338+05:30</updated><title type='text'>Update records in database using Stored Procedure</title><content type='html'>In below code you can find, How to implement update query using Stored Procedure.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID=OBJECT_ID('UpdateProjectDetail'))&lt;br /&gt; DROP  PROCEDURE UpdateProjectDetail&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;CREATE PROCEDURE UpdateProjectDetail&lt;br /&gt;(&lt;br /&gt; @piProjectID  INT, &lt;br /&gt; @piCustomerID INT,&lt;br /&gt; @psProjectTitle VARCHAR(100),&lt;br /&gt; @psProjectDescription VARCHAR(200),&lt;br /&gt; @psProjectCategory INT,&lt;br /&gt; @pdStartDate DATETIME,&lt;br /&gt; @pdEndDate DATETIME,&lt;br /&gt; @psStatus VARCHAR(10),&lt;br /&gt; @piHours  INT,&lt;br /&gt; @piCreatedBy INT&lt;br /&gt;)&lt;br /&gt;AS&lt;br /&gt;BEGIN&lt;br /&gt; UPDATE projects  SET&lt;br /&gt;&lt;br /&gt; CustomerID=@piCustomerID,&lt;br /&gt;&lt;br /&gt; ProjectTitle=@psProjectTitle,&lt;br /&gt; ProjectDescription=@psProjectDescription,&lt;br /&gt; ProjectCategory=@psProjectCategory,&lt;br /&gt; StartDate=@pdStartDate,&lt;br /&gt; EndDate=@pdEndDate,&lt;br /&gt; Status=@psStatus,&lt;br /&gt; Hours=@piHours,&lt;br /&gt; CreatedBy=@piCreatedBy,&lt;br /&gt; CreatedDate=GETDATE()&lt;br /&gt;&lt;br /&gt;  WHERE&lt;br /&gt; ProjectID=@piProjectID&lt;br /&gt;END&lt;br /&gt;GO &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Hope this post will help you&lt;/span&gt;,&lt;br /&gt;Rajesh Singh&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.indianic.com/"&gt;Indianic Infotech Ltd&lt;/a&gt; (India)&lt;br /&gt;Rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-574328562462326600?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/574328562462326600/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/update-records-in-database-using-stored.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/574328562462326600'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/574328562462326600'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/update-records-in-database-using-stored.html' title='Update records in database using Stored Procedure'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2643030478504447675.post-1822245412650874971</id><published>2009-08-20T16:15:00.000+05:30</published><updated>2009-08-20T16:21:55.510+05:30</updated><title type='text'>How to implement "If condition in stored procedure" ?</title><content type='html'>&lt;span style="font-weight:bold;"&gt;You can find in below code, How "if condition" is implemented.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;IF EXISTS (SELECT * FROM SYSOBJECTS WHERE OBJECT_ID=('GetProjectList'))&lt;br /&gt;DROP GetProjectList&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;CREATE PROCEDURE GetProjectList&lt;br /&gt;(&lt;br /&gt; @psStatus VARCHAR(20)&lt;br /&gt;)&lt;br /&gt;AS&lt;br /&gt;BEGIN&lt;br /&gt; IF @psStatus=' '&lt;br /&gt;  BEGIN&lt;br /&gt;  SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT WHERE PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory&lt;br /&gt;  END&lt;br /&gt; ELSE&lt;br /&gt;  BEGIN&lt;br /&gt;   IF @psStatus='Open'&lt;br /&gt;    SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT  Where Status='Open' AND PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory&lt;br /&gt;   ELSE&lt;br /&gt;    SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT  Where Status='Close' AND PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory&lt;br /&gt;  END&lt;br /&gt;END&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Hope this post will help you,&lt;/span&gt;&lt;br /&gt;Rajesh Singh&lt;br /&gt;Asp.Net Developer&lt;br /&gt;&lt;a href="http://www.indianic.com/"&gt;Indianic Infotech Ltd&lt;/a&gt; (India)&lt;br /&gt;Rajesh@indianic.com&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2643030478504447675-1822245412650874971?l=dotnetclimber.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetclimber.blogspot.com/feeds/1822245412650874971/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/how-to-implement-if-condition-in-stored.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/1822245412650874971'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2643030478504447675/posts/default/1822245412650874971'/><link rel='alternate' type='text/html' href='http://dotnetclimber.blogspot.com/2009/08/how-to-implement-if-condition-in-stored.html' title='How to implement &quot;If condition in stored procedure&quot; ?'/><author><name>rajesh Singh</name><uri>http://www.blogger.com/profile/12427818898607173731</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='32' src='http://4.bp.blogspot.com/_0AP8fBxcSdc/Syn6Z365rEI/AAAAAAAAAOQ/ooFvY3OAgPw/S220/single+R.jpg'/></author><thr:total>0</thr:total></entry></feed>
