Know about RSS Reader?

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.

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 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.

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.

To download a free RSS Reader tool by http://www.rssreader.com/

This will helps you to get latest updates that you are interested.

DotNet Best Practices

For frequently asked question in dotnet,
http://dotnetguts.blogspot.com/2007/08/frequently-asked-differences-in-net.html

Abstract Class Implementation in VB.Net

Public MustInherit Class Accounts
Private name As String
Protected balance As Double
Public Sub New(ByVal n As String, ByVal b As Double)
name = n
balance = b
End Sub
Public Overridable Sub credit(ByVal amount As Double)
balance += amount
End Sub
Public Overridable Sub debit(ByVal amount As Double)
balance -= amount
End Sub
Public Overridable Sub display()
MsgBox("Name =" & name & ", Balance =" & balance)
End Sub
Public MustOverride Function calculatebankcharge() As Double

End Class

Public Class SavingAccounts
Inherits Accounts
Private minbalance As Double
Public Sub New(ByVal n As String, ByVal b As Double, ByVal min As Double)
MyBase.new(n, b)
minbalance = min
End Sub
Public Overrides Sub debit(ByVal amount As Double)
If amount <= Balance Then
MyBase.debit(amount)
End If

End Sub

Public Overrides Sub display()
MyBase.display()
MsgBox("$5 charge if balance goes below $" & minbalance)
End Sub
Public Overrides Function calculatebankcharge() As Double
If Balance < minbalance Then
Return 5.0
Else
Return 0.0
End If

End Function
End Class

Convert comma separated string values into table in SQL

In Sql server, we cannot manipulate with comma (,) separated string values in the ‘IN’ option of the WHERE clause.

In this article, Let us see how a solution can be provided for this requirement.

Example:

The below query results in error,

“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”

For that we need to convert the comma separated values into a table through the given query.

Declare @ids varchar(max)
select @ids='8, 9, 2, 12, 13, 58, 56, 57, 53, 54, 71, 69, 70, 269'
Select username from tbluser where uid in (@ids)

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.

I think this procedure will be very much helpful for sql developers,

--/************************************************
--Developer :Manivannan.S
--purpose:Query used to convert comma (,) separated
--            sting values into table
--***************************************************/
Declare @ids varchar(max)
--create a temp table with id column
create table #t (id int)
select @ids='8,9,2,12,13,58,56,57,53,54,71,69,70,269'
select @ids = 'insert #t select ' + replace(@ids, ',', ' union All select ')
print @ids
--Execute the Query
exec(@ids)
--select id from #t
--Use the temp table in inner of "in" keyword and get the result
Select username from tbluser where uid in (select id from #t)
--Finally drop the temp table
drop table #t