December 9, 2009 - Tech Insight !

Outlook 2007

Setting up HTML signature in Outlook 2007

kiranDecember 9, 2009January 1, 2020

Step 1: Go to windows explorer and navigate to the below given path: C:\Documents and Settings\Administrator\Application Data\Microsoft\Signatures Step 2: Place signature files in the above mentioned folder. And make sure...

SQL server 2005

Writing recursive queries in SQL server 2005 using Common table expression (CTE)

kiranDecember 9, 2009January 1, 2020

with cte (empID,manID,depth,hierarchy) as ( select e.employeeID,e.managerID ,1 , cast(e.employeeID as nvarchar(max))as hierarchy from humanresources.Employee as e where managerID is null union all select emp.employeeID,emp.managerID ,depth+1 , hierarchy + '/'...

Storing and Retrieving image in SQL server 2005 & asp.net using large value data type & HTTP handler

kiranDecember 9, 2009January 1, 2020

ASPX page : <form id="form1" runat="server"> <div style="padding: 200px;"> <asp:Image ID="imagebox" runat="server" ImageUrl="~/sql-image-store/image-handler.ashx" /> </div> </form> Handler code: image-handler.ashx <%@ WebHandler Language="C#" Class="image_handler" %> using System; using System.Web; using System.IO;...

Excel SQL server 2005

Import Excel data into SQL Server 2005 table using distributed queries

kiranDecember 9, 2009January 1, 2020

/*SQL server configuration settings */ exec sp_configure sp_configure 'show advanced options', 1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries', 1 reconfigure /*Excel import into sql table using distributed query*/ select...

.Net 2.0 asp.net C#.net XML

Developing custom AD rotator control with multiple Image Mapping using C#.net & XML

kiranDecember 9, 2009January 1, 2020

We are all familiar with AD rotator control asp.net provides to show rotating/random ads on every page refresh. But I found a limitation of this control while I needed to...