Thursday, February 24, 2011

Handling Stored Procedure with C# and SQL Server

See, stored procedure in DB means storing small database handlers into DB directly. This ensures two things, 1. Make the retrieval/insertion/any db operation faster; 2. security of SQL.

At this stage we do not want to write any SQL inline (means not within C# Code). Now the question is how to write stored procs in SQL Server? How to call the proc from within your code?

Saturday, February 19, 2011

Reading RSS Feed from C# Code

Recently I am getting a request from students and my corporate clients to read RSS feeds from different sites. Yes. To serve recent client's requirement this is extreamly important. So, planned and finally writing this blog for you.

Reading RSS feed is very easy with C#. You basically need to use System.XML namespace to read the feeds.

Just browse the following link and download the code.....AND THEN???????

Ctrl + C AND Ctrl + V.....Hah.

1. http://www.codeproject.com/KB/cs/ReadForSpeed.aspx (A typical C# Desktop Application)

2. http://www.computorcompanion.com/LPMArticle.asp?ID=194 (If you do not have a clear idea about XML, RSS etc.)

Please keep on visiting this blog..... I am going to put some more interesting links very shortly....