Export to pdf ( Create pdf on fly ) using ASP.net and C#

Consider following code for creating pdf document on fly using ASP.net in C#.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

 Continue reading 

Cursor in MS SQL

Using Cursor in MS SQL Server 2005 or 2008
Consider following code for creating cursor

declare db_cursor CURSOR for
SELECT ItemSLNO FROM P_Return_ItemSLNOTraking where Com_PReturnId_ItemId = @Com_ReceiveId_ItemId
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @ItemSLNO
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SLNO = @SLNO+ ','+ @ItemSLNO
FETCH NEXT FROM db_cursor INTO @ItemSLNO
END
CLOSE db_cursor
DEALLOCATE db_cursor