tag:blogger.com,1999:blog-91372254314415182462024-03-12T16:00:54.240-07:00ManivannanLife is to live, so live it in your own style...Manihttp://www.blogger.com/profile/13450626778725311765noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9137225431441518246.post-22771729172103078832011-06-15T21:25:00.000-07:002011-06-15T21:50:43.626-07:00Know about RSS Reader?<span style="font-family:georgia;font-size:100%;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1xpEuHXrc1zXTZXD9fS_TYRMdVJn5CR1jHxVuFpNtk3fJ1wn15rAr1Y5Hh4QNJPuJ6KKu3id_HyQRYPjyJ1SULf85rm-knge7o4cBBKE0HizdSqxLVRg4_kNEP74LoaN791qda1SDZvY/s1600/RSSTool.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1xpEuHXrc1zXTZXD9fS_TYRMdVJn5CR1jHxVuFpNtk3fJ1wn15rAr1Y5Hh4QNJPuJ6KKu3id_HyQRYPjyJ1SULf85rm-knge7o4cBBKE0HizdSqxLVRg4_kNEP74LoaN791qda1SDZvY/s320/RSSTool.JPG" alt="" id="BLOGGER_PHOTO_ID_5618672098919121618" border="0" /></a><br />RSS (most commonly expanded as Really Simple Syndication) is a family of web feed formats used to publish frequently updated works such as blog entries, news headlines, audio, and video in a standardized format. An RSS document (which is called a "feed", "web feed" or "channel") includes full or summarized text, plus metadata such as publishing dates and authorship.<br /><br />RSS feeds can be read using software called an "RSS reader", "feed reader", or "aggregator", which can be web-based, desktop-based, or mobile-device-based. A standardized XML file format allows the information to be published once and viewed by many different programs. The user subscribes to a feed by entering into the reader the feed's URI or by clicking a feed icon<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAACoUlEQVQokWWR3UtTcRzGf/fbn5GM+bLNuZdzzjRBgt7GCrqqxEpiFw6KiVOZmm5O55wjI5uzEjVFKJGgDIK6qFVEZaFGQdqwubO3s529uLPtnM2zbxfDGvVcfx54XhBC6IxIuNEpIwdU4SF1xIpFbTg1gsfseMxBxMcJekITc+Jfe+t1IgFCCOlEAsp2NGCsC5kkEbMsNlhPD8uT9oa0U5G5qczeVuXcanYG4+7hGU+LrkqINozSQGcdNabNvl1knrvS8+3JMeX/dGEWz09jmyY5ClmwkElCz1yBQ5WyCe793ayn+R+amVRRDgKFrXjELEvc0rFba8W9L8AXD22xwtOOSjrlUFB2DYrYiMrcjLuF87pK+SQAAF888Nr+0LRVHrERKDpK0MPyzMJlPhko+rzcC0vOQ3ALx/nQ57Inv9pRpqN9ssgwgSi7JmlvYJav/u2Q/FVYbS3MNfHkJwAoZemEoynaJwt3S0MWHFEOTdqpYKaa2ceG4vocsPsAAIUc+/Bi1nOsxNAAwLy6H+6WkkZJcBBHsXFN5YKFpVMl6hsA8KlAagJnno0CQCmfCXbJ/Yba4ACG4s7GMl185+J/rBUfnWPnT5SyCQBg1kaoIaxUYAEgOqXf1deQ/RiKuxpzbjW3cqFc4ODnS2ZSlfdOAwDn+xjulua/vwGA5JM7vvbqgFmN4i4NO4NxiyeBywBA4cNsyqFIz14CAD5Dk0bJ/utlANh/vbLTJt7rVaOtnvryO+wDbX5Fn3IoaaucshDJpS56vstvqA1azkbcxoD1/HareP2aDOlEgoynpfKd8oKkUeI31O7qa3zt1Ttt4u1WMWnWaKuECCF0+ohws6c+OopRI3jEioWHsNANdbBfTZpVgV5VoEfpNynWr0u1VQKE0G/UWOeZIaAhXQAAAABJRU5ErkJggg==" alt="" /> in a web browser that initiates the subscription process. The RSS reader checks the user's subscribed feeds regularly for new work, downloads any updates that it finds, and provides a user interface to monitor and read the feeds.<br /><br />By using any one of the RSS reader tool available on web,you can get the latest updates of subscribed feeds on your desktop frequently.<br /><br />To download a free RSS Reader tool by <a href="http://www.rssreader.com/">http://www.rssreader.com/</a><br /><br />This will helps you to get latest updates that you are interested.<br /><br /></span>Manihttp://www.blogger.com/profile/13450626778725311765noreply@blogger.com0tag:blogger.com,1999:blog-9137225431441518246.post-77214502439463655132011-06-15T21:08:00.000-07:002011-06-15T21:13:21.643-07:00DotNet Best PracticesFor frequently asked question in dotnet,<br />http://dotnetguts.blogspot.com/2007/08/frequently-asked-differences-in-net.htmlManihttp://www.blogger.com/profile/13450626778725311765noreply@blogger.com0tag:blogger.com,1999:blog-9137225431441518246.post-46860402262718763062010-01-05T00:19:00.000-08:002010-01-05T00:22:06.193-08:00Abstract Class Implementation in VB.NetPublic MustInherit Class Accounts<br /> Private name As String<br /> Protected balance As Double<br /> Public Sub New(ByVal n As String, ByVal b As Double)<br /> name = n<br /> balance = b<br /> End Sub<br /> Public Overridable Sub credit(ByVal amount As Double)<br /> balance += amount<br /> End Sub<br /> Public Overridable Sub debit(ByVal amount As Double)<br /> balance -= amount<br /> End Sub<br /> Public Overridable Sub display()<br /> MsgBox("Name =" & name & ", Balance =" & balance)<br /> End Sub<br /> Public MustOverride Function calculatebankcharge() As Double<br /><br />End Class<br /><br />Public Class SavingAccounts<br /> Inherits Accounts<br /> Private minbalance As Double<br /> Public Sub New(ByVal n As String, ByVal b As Double, ByVal min As Double)<br /> MyBase.new(n, b)<br /> minbalance = min<br /> End Sub<br /> Public Overrides Sub debit(ByVal amount As Double)<br /> If amount <= Balance Then<br /> MyBase.debit(amount)<br /> End If<br /><br /> End Sub<br /><br /> Public Overrides Sub display()<br /> MyBase.display()<br /> MsgBox("$5 charge if balance goes below $" & minbalance)<br /> End Sub<br /> Public Overrides Function calculatebankcharge() As Double<br /> If Balance < minbalance Then<br /> Return 5.0<br /> Else<br /> Return 0.0<br /> End If<br /><br /> End Function<br />End ClassManihttp://www.blogger.com/profile/13450626778725311765noreply@blogger.com0tag:blogger.com,1999:blog-9137225431441518246.post-5427728897028030622009-12-24T22:59:00.000-08:002009-12-24T23:02:56.084-08:00Convert comma separated string values into table in SQL<p>In Sql server, we cannot manipulate with comma (,) separated string values in the ‘IN’ option of the WHERE clause.</p><br /><p>In this article, Let us see how a solution can be provided for this requirement.</p><br /><p><span id="more-168"></span><strong>Example:</strong></p><br /><p style="text-align: justify;">The below query results in error,</p><br /><p style="text-align: justify;">“Conversion failed when converting the varchar value ‘8, 9, 2, 12, 13, 58, 56, 57, 53, 54, 71, 69, 70, 269′ to data type int”</p><br /><br /><p style="text-align: justify;">For that we need to convert the comma separated values into a table through the given query.</p><br /><pre class="brush:sql">Declare @ids varchar(max)<br />select @ids='8, 9, 2, 12, 13, 58, 56, 57, 53, 54, 71, 69, 70, 269'<br />Select username from tbluser where uid in (@ids)</pre><br /><p style="text-align: justify;">This query has to be modified by replacing all the comma (,) characters into “union all select “ and form an insert query to insert into a temp table and we have to get those values from the temp table.</p><br /><p style="text-align: justify;">I think this procedure will be very much helpful for sql developers,</p><br /><pre class="brush:sql">--/************************************************<br />--Developer :Manivannan.S<br />--purpose:Query used to convert comma (,) separated<br />-- sting values into table<br />--***************************************************/<br />Declare @ids varchar(max)<br />--create a temp table with id column<br />create table #t (id int)<br />select @ids='8,9,2,12,13,58,56,57,53,54,71,69,70,269'<br />select @ids = 'insert #t select ' + replace(@ids, ',', ' union All select ')<br />print @ids<br />--Execute the Query<br />exec(@ids)<br />--select id from #t<br />--Use the temp table in inner of "in" keyword and get the result<br />Select username from tbluser where uid in (select id from #t)<br />--Finally drop the temp table<br />drop table #t</pre>Manihttp://www.blogger.com/profile/13450626778725311765noreply@blogger.com0