<?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:blogger='http://schemas.google.com/blogger/2008' 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-663572496286393942</id><updated>2024-09-05T04:05:17.919+05:30</updated><category term="StringToPdf"/><title type='text'>Developer&#39;s Help</title><subtitle type='html'>This blog provides free C# controls as well as some tips &amp;amp; tricks to play with code. Feel free to use it any time</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>7</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-6742482263352898706</id><published>2012-11-27T20:06:00.002+05:30</published><updated>2013-04-16T13:53:33.696+05:30</updated><title type='text'>Find Height and Width of image using C#</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
I know, there are some requirements in which we need to find out the image&#39;s height and width.&lt;br /&gt;
Either the&amp;nbsp;image is on server or it&#39;s been uploaded using fileupload control in asp.net using C#.&lt;br /&gt;
&lt;br /&gt;
Following is the example for finding the height and width of image which is being uploaded through FileUpload Control in asp.net.&lt;br /&gt;
My favourite language is C#, so this code is also written in C#.&lt;br /&gt;
Those who love VB, please use a code convertor.&lt;br /&gt;
&lt;br /&gt;
lets say fileUpload control as fiUpload&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;protected&amp;nbsp;void findHieghtWidht_Click(object sender, EventArgs e)&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;{&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style=&quot;color: blue;&quot;&gt;string&lt;/span&gt; uploadImageType = fiUpload.PostedFile.ContentType.ToString().ToLower();&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style=&quot;color: blue;&quot;&gt;stirng&lt;/span&gt; uploadImageName = fiUpload.PostedFile.FileName;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; System.Drawing.&lt;span style=&quot;color: #3d85c6;&quot;&gt;Image&lt;/span&gt; uploadImage = System.Drawing.Image.FromStream(fiUpload.PostedFile.InputStream);&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: blue;&quot;&gt;float&lt;/span&gt; imageWidth = uploadImage.PhysicalDimension.Width;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style=&quot;color: blue;&quot;&gt;float&lt;/span&gt; imageHeight = uploadImage.PhysicalDimension.Height;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Trebuchet MS&amp;quot;, sans-serif;&quot;&gt;}&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Same way you can load the image stored on server, and get the height and width. &lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://gan.doubleclick.net/gan_click?lid=41000613802356309&amp;amp;pubid=21000000000500147&amp;amp;lsrc=17&quot;&gt;&lt;img alt=&quot;344808_CrashPlan 10% Savings - 120x600 animated&quot; border=&quot;0&quot; src=&quot;http://gan.doubleclick.net/gan_impression?lid=41000613802356309&amp;amp;pubid=21000000000500147&amp;amp;lsrc=17&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/6742482263352898706/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2012/11/find-height-and-width-of-image-using-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/6742482263352898706'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/6742482263352898706'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2012/11/find-height-and-width-of-image-using-c.html' title='Find Height and Width of image using C#'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-6616735595941023</id><published>2011-12-22T22:11:00.002+05:30</published><updated>2012-11-26T18:42:33.046+05:30</updated><title type='text'>Failed To Load Viewstate</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Once I encountered the following error&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #c00000;&quot;&gt;Failed to load viewstate.&lt;br /&gt;&lt;br /&gt;The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request.&lt;br /&gt;&lt;br /&gt;For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request&lt;/span&gt; &lt;br /&gt;
&lt;div class=&quot;row&quot; style=&quot;text-align: right; width: 800px;&quot;&gt;
&lt;a class=&quot;replyLink&quot; href=&quot;http://www.eggheadcafe.com/forumpostsubmission.aspx?topicid=17&amp;amp;forumpostid=10399926&quot;&gt;&lt;br /&gt;&lt;/a&gt;&lt;/div&gt;
I searched a lot on google and finally i found one solution.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Here is the reason why the error happens:&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b style=&quot;background-color: #f3f3f3; color: #666666; font-weight: normal;&quot;&gt;If a control is added dynamically to a placeholder say (&lt;b&gt;UserControl1&lt;/b&gt;.ascx) and the control&#39;s viewstate is enabled ,thenafter on the next postback a different control is added say (&lt;/b&gt;&lt;b style=&quot;background-color: #f3f3f3; color: #666666; font-weight: normal;&quot;&gt;&lt;b&gt;UserControl2&lt;/b&gt;.ascx&lt;/b&gt;&lt;b style=&quot;background-color: #f3f3f3; color: #666666; font-weight: normal;&quot;&gt;) to the placeholder.&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;when asp.net try to load the viewstate of the control contained at the placeholder it&#39;s expecting the previous control &amp;nbsp;u added :(&lt;/span&gt;&lt;b style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;UserControl1.ascx&lt;/b&gt;&lt;span style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;) but it will encounter another control instead &amp;nbsp;(&lt;/span&gt;&lt;b style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;&lt;/b&gt;&lt;b style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;UserControl2&lt;/b&gt;&lt;span style=&quot;background-color: #f3f3f3; color: #666666;&quot;&gt;.ascx) in the place of the first control SO IT WILL FAIL.&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;&lt;br style=&quot;background-color: #f3f3f3; color: #666666;&quot; /&gt;&lt;span style=&quot;background-color: #f3f3f3; color: #666666; font-weight: normal;&quot;&gt;Viewstate of the control tree in the placeholder child controls is saved by index not by key so even if we give our ascx control as a key before adding it to the placeholder we will get the same error&lt;/span&gt;.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Solution:&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Just disable viewstate of the usercontrol.&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: #666666;&quot;&gt;&amp;lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeBehind=&quot; abc.aspx.cs&quot; Inherits=&quot;#####&quot;&lt;span style=&quot;background-color: blue;&quot;&gt;&lt;span style=&quot;background-color: #f3f3f3;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;background-color: lime;&quot;&gt;EnableViewState=&quot;false&quot;&lt;/span&gt;&lt;/span&gt;%&amp;gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://gan.doubleclick.net/gan_click?lid=41000000035722933&amp;amp;pubid=21000000000500147&amp;amp;lsrc=17&quot;&gt;20% OFF + FREE Set-up on select items! Online Exclusive for New Customers Only.&lt;/a&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/6616735595941023/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2011/12/failed-to-load-viewstate.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/6616735595941023'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/6616735595941023'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2011/12/failed-to-load-viewstate.html' title='Failed To Load Viewstate'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-1010332112779335318</id><published>2011-10-01T01:31:00.000+05:30</published><updated>2012-03-14T19:29:58.147+05:30</updated><title type='text'>Maintain tabs in SpryTabbedPanels</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
This post helps you to maintain the tab index of spry tabpanal at every post back event&lt;br /&gt;
&lt;br /&gt;
I have done small changes in SpryTabbedPanels.js for this post back purpose&lt;br /&gt;
&lt;br /&gt;
You can download the upgraded version of SpryTabbedPanels.js at&lt;br /&gt;
&lt;iframe frameborder=&quot;0&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;https://skydrive.live.com/embedicon.aspx/.Public/SpryTabbedPanels.js?cid=2ceff5c7731af2b5&amp;amp;sc=documents&quot; style=&quot;background-color: #fcfcfc; height: 115px; padding: 0pt; width: 98px;&quot; title=&quot;Preview&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;br /&gt;
To use this script follow the steps&lt;br /&gt;
&lt;br /&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhORhX1B9eZTm8vU5Ena1bLxww1SCHc-dF90AeSyxKKrHLtHSHbzoLIFSgT9h8cEXgnRlTqVsjc_IAVvZMM6KKsVuRWZW-86j6NPSs29cCPA6tueclPu8Zci_gPHDw3DbMyRctXkYkFLc0/s1600/2.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;443&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhORhX1B9eZTm8vU5Ena1bLxww1SCHc-dF90AeSyxKKrHLtHSHbzoLIFSgT9h8cEXgnRlTqVsjc_IAVvZMM6KKsVuRWZW-86j6NPSs29cCPA6tueclPu8Zci_gPHDw3DbMyRctXkYkFLc0/s640/2.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Steps to be followed to implement spreyTabbedpanels&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span id=&quot;goog_2012288246&quot;&gt;&lt;/span&gt;&lt;span id=&quot;goog_2012288247&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;a href=&quot;http://gan.doubleclick.net/gan_click?lid=41000613802252754&amp;amp;pubid=21000000000500147&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;Save on Snacks and Party Favorite Foods&lt;/span&gt;&lt;/a&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/1010332112779335318/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2011/10/maintain-tabs-in-sprytabbedpanels.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/1010332112779335318'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/1010332112779335318'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2011/10/maintain-tabs-in-sprytabbedpanels.html' title='Maintain tabs in SpryTabbedPanels'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhORhX1B9eZTm8vU5Ena1bLxww1SCHc-dF90AeSyxKKrHLtHSHbzoLIFSgT9h8cEXgnRlTqVsjc_IAVvZMM6KKsVuRWZW-86j6NPSs29cCPA6tueclPu8Zci_gPHDw3DbMyRctXkYkFLc0/s72-c/2.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-124075341985202057</id><published>2011-02-11T02:34:00.000+05:30</published><updated>2018-12-08T15:58:18.643+05:30</updated><title type='text'>Delete file which is already in use using C#.net</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Sometime scenario arises where we need to delete a file using C#.&lt;br /&gt;
But sometime an error is thrown like &quot;File is already in use. Not able to delete&quot;&lt;br /&gt;
&lt;br /&gt;
Here is the solution to delete that file&lt;br /&gt;
&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;if(File.Exists(FullFileName))&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;{&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; GC.Collect();&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; GC.WaitForPendingFinalizers();&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;FileInfo f = new FileInfo(FullFileName);&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; f.Delete();&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: #f4cccc;&quot;&gt;}&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;script async src=&quot;//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
     (adsbygoogle = window.adsbygoogle || []).push({
          google_ad_client: &quot;ca-pub-5127434386525611&quot;,
          enable_page_level_ads: true
     });
&lt;/script&gt;</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/124075341985202057/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2011/02/delete-file-which-is-already-in-use.html#comment-form' title='6 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/124075341985202057'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/124075341985202057'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2011/02/delete-file-which-is-already-in-use.html' title='Delete file which is already in use using C#.net'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>6</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-4599407760220880152</id><published>2011-01-05T19:10:00.000+05:30</published><updated>2013-01-02T20:14:10.718+05:30</updated><title type='text'>Days gap between two dates in ORACLE</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
To find out days gap between two dates excluding business holidays in oracle use following query.&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;background-color: white; color: #45818e;&quot;&gt;
&lt;b&gt;SELECT count(dt) FROM&lt;br /&gt;(SELECT TO_DATE(StartDate) + level - 1 dt FROM dual CONNECT BY level &amp;lt;=(TO_DATE(EndDate)-TO_DATE(StartDate)))&lt;br /&gt;where to_char (dt,&#39;D&#39;)&amp;lt;&amp;gt;1 &lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;color: white;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
Below written query is the example of it.&lt;br /&gt;
&lt;br /&gt;
This query returns days count between 30-nov-2010 and 12-dec-2010 excluding Sundays&lt;br /&gt;
(1 for sunday,2 for monday and so on......)&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;b&gt;SELECT count(dt) FROM&lt;br /&gt;(SELECT TO_DATE(&#39;30-nov-2010&#39;) + level - 1 dt FROM dual CONNECT BY level &amp;lt;=(TO_DATE(&#39;12-Dec-2010&#39;)-TO_DATE(&#39;30-nov-2010&#39;)))&lt;br /&gt;where to_char (dt,&#39;D&#39;)&amp;lt;&amp;gt;1&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;span style=&quot;color: black;&quot;&gt;To find out&lt;/span&gt; dates between two dates use following query&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;background-color: white; color: #45818e;&quot;&gt;
&lt;b&gt;SELECT to_char(dt,&#39;dd/MM/yyyy&#39;) as date FROM&lt;br /&gt;(SELECT TO_DATE(StartDate) + level - 1 dt FROM dual CONNECT BY level &amp;lt;=(TO_DATE(EndDate)-TO_DATE(StartDate)))&lt;br /&gt;where to_char (dt,&#39;D&#39;)&amp;lt;&amp;gt;1 &lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;color: #351c75;&quot;&gt;
&lt;b&gt;Happy coding.&lt;/b&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/4599407760220880152/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2011/01/days-gap-between-to-dates-in-oracle.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4599407760220880152'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4599407760220880152'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2011/01/days-gap-between-to-dates-in-oracle.html' title='Days gap between two dates in ORACLE'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-4812944561189754187</id><published>2010-03-12T14:23:00.000+05:30</published><updated>2010-03-12T14:23:51.705+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="StringToPdf"/><title type='text'>String To Pdf Converter</title><content type='html'>This dll helps you to convert your string format data into pdf file &lt;br /&gt;
follow the steps to implement it.&lt;br /&gt;
The Pdf will be available from &lt;a href=&quot;http://www.box.net/CSharpControls&quot;&gt;http://www.box.net/CSharpControls&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
download StringToPdf.dll to your computer&lt;br /&gt;
1. Do right-click on your Application REFERENCES folder available in Solution Explorer(As shown in the below figure)&lt;br /&gt;
&lt;a href=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot; mce_href=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;alignleft size-full wp-image-15&quot; mce_src=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot; src=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot; title=&quot;reference&quot; /&gt;&lt;/a&gt; &lt;br /&gt;
2. Click on Add Reference and the following window will be opened.&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO0LCpqCYDTrCQTQM6ATRHhU8bNtFy-NbIL54Y2_FDTp6KmsuiCDvoB24QvKzhiFMDElfRAZmZ2Q8rTP6kb8BFys5u4u6OFWZWev9CQJnpKZ3QtPSz_IZf1DHRIpaaFMddKecUDBGv8mo/s1600-h/untitled.jpg&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5445015715174701298&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO0LCpqCYDTrCQTQM6ATRHhU8bNtFy-NbIL54Y2_FDTp6KmsuiCDvoB24QvKzhiFMDElfRAZmZ2Q8rTP6kb8BFys5u4u6OFWZWev9CQJnpKZ3QtPSz_IZf1DHRIpaaFMddKecUDBGv8mo/s320/untitled.jpg&quot; style=&quot;cursor: pointer; float: left; height: 274px; margin: 0pt 10px 10px 0pt; width: 320px;&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot; mce_href=&quot;http://sharpcontrols.files.wordpress.com/2010/03/reference.jpg&quot;&gt;&lt;br /&gt;
&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
3. go on the 4th tab and   locate your downloaded stringToPdf.dll and click ok. (here my .dll&#39;s location is Desktop)&lt;br /&gt;
4. Now make an object of the class PDFWRITER&lt;br /&gt;
here is the example&lt;br /&gt;
&lt;span style=&quot;color: #00cccc;&quot;&gt;string&lt;/span&gt; text = &lt;span style=&quot;color: red;&quot;&gt;&quot;&lt;/span&gt;&lt;span mce_color=&quot;#ff0000&quot; style=&quot;color: red;&quot;&gt;Markand&#39;s Pdf.dll Testing&lt;/span&gt;&lt;span style=&quot;color: red;&quot;&gt;&quot;&lt;/span&gt;;&lt;br /&gt;
&lt;span mce_color=&quot;#ccffff&quot;&gt;&lt;span mce_color=&quot;#42b8bc&quot; style=&quot;color: #00cccc;&quot;&gt;PdfWriter&lt;/span&gt; &lt;/span&gt;p = new &lt;span mce_color=&quot;#42b8bc&quot; style=&quot;color: #00cccc;&quot;&gt;PdfWriter&lt;/span&gt;();&lt;br /&gt;
p.write(text);&lt;br /&gt;
this will write the content of &quot;text&quot; into .pdf file&lt;br /&gt;
You can find your .pdf file at&lt;span mce_color=&quot;#008080&quot;&gt; &lt;/span&gt;&lt;span mce_color=&quot;#99cc00&quot; style=&quot;color: #ff6600;&quot;&gt;&lt;span mce_color=&quot;#008080&quot;&gt;&lt;span mce_color=&quot;#800080&quot;&gt;C:\Temp\&lt;/span&gt; &lt;/span&gt; &lt;/span&gt;&lt;br /&gt;
That&#39;s All.&lt;br /&gt;
Enjoy Converting from string to PDF</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/4812944561189754187/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2010/03/string-to-pdf-converter_12.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4812944561189754187'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4812944561189754187'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2010/03/string-to-pdf-converter_12.html' title='String To Pdf Converter'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO0LCpqCYDTrCQTQM6ATRHhU8bNtFy-NbIL54Y2_FDTp6KmsuiCDvoB24QvKzhiFMDElfRAZmZ2Q8rTP6kb8BFys5u4u6OFWZWev9CQJnpKZ3QtPSz_IZf1DHRIpaaFMddKecUDBGv8mo/s72-c/untitled.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-663572496286393942.post-4632467977544244558</id><published>2010-02-06T11:14:00.001+05:30</published><updated>2010-05-12T12:56:41.933+05:30</updated><title type='text'>PhotoChanger.dll</title><content type='html'>&lt;script src=&quot;http://www.assoc-amazon.com/s/link-enhancer?tag=knowaboutcomp-20&amp;amp;o=1&quot; type=&quot;text/javascript&quot;&gt;
&lt;/script&gt; &lt;br /&gt;
&lt;br /&gt;
PhotoChanger.dll is used to change the photo for every specified time  interval.&lt;br /&gt;
This control  takes the path of the Image Folder and show all images one by one.&lt;br /&gt;
&lt;br /&gt;
dll will be available from   &lt;a href=&quot;http://depositfiles.com/files/ir3oojbta&quot;&gt;http://depositfiles.com/files/ir3oojbta&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
follow the steps to add control to your toolbox of C#&lt;br /&gt;
&lt;br /&gt;
1. Right click on toolbox. and select &quot;Choose Items&quot; from the context menu.&lt;br /&gt;
2. Select &quot;Browse&quot; from the opened dialog box.&lt;br /&gt;
3. select the .dll stored in your computer and click ok.&lt;br /&gt;
4. Now see in the toolbox your control is ready to use.&lt;br /&gt;
&lt;br /&gt;
5.now drag control to your window application&lt;br /&gt;
&lt;br /&gt;
6.select control&#39;s property.&lt;br /&gt;
&lt;br /&gt;
7.give Folder path in property named &quot;ImageFolder&quot;&lt;br /&gt;
8. Give Time Interval (time to reload next photo) in property named &quot;Interval&quot; in milliseconds&lt;br /&gt;
&lt;br /&gt;
Thats all.</content><link rel='replies' type='application/atom+xml' href='http://markand-bhatt.blogspot.com/feeds/4632467977544244558/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://markand-bhatt.blogspot.com/2010/02/photchangerdll.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4632467977544244558'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/663572496286393942/posts/default/4632467977544244558'/><link rel='alternate' type='text/html' href='http://markand-bhatt.blogspot.com/2010/02/photchangerdll.html' title='PhotoChanger.dll'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/12356784029537041246</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry></feed>