Bhupesh/baba Site

http://sites.google.com/site/bhupeshrawatsite/Home
http://sites.google.com/site/meetashwanianand/

Building a Database Driven Hierarchical Menu using ASP.NET 2.0

http://aspalliance.com/articleViewer.aspx?aId=822&pId=-1

new-features-of-visual-studio-2008

http://msdotnetsupport.blogspot.com/2007/11/22-new-features-of-visual-studio-2008.html

Compressing files using GZIP

http://www.codeproject.com/KB/aspnet/httpcompression.aspx

IIS 6 Compression - quickest and effective way to do it for ASP.NET compression

http://msmvps.com/blogs/omar/archive/2006/08/10/iis-6-compression-quickest-and-effective-way-to-do-it-for-asp-net-compression.aspx

Change Display Order After Deleting Record

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
--usp_Admin_DisplayOrder_DeleteUpdateDisplayOrder '56','','Tbl_Article','ArticleID'
--usp_Admin_DisplayOrder_DeleteUpdateDisplayOrder '','5,6','Tbl_Article','ArticleID'
--select * from tbl_Article
ALTER PROC [dbo].[usp_Admin_DisplayOrder_DeleteUpdateDisplayOrder]
@XmlStr VARCHAR(4000),@StrIDs varchar(4000),@Tablename varchar(100),@FieldName varchar(100)
as
Declare @XmlRecord INT
DECLARE @RetVal INT
SET @RetVal = -1

CREATE TABLE #Temp
(
RowID BIGINT IDENTITY(1,1),
ID BIGINT
)
CREATE TABLE #TempDisplayOrder (
DisplayOrder INT )

IF(@XmlStr <> '')
BEGIN
Exec sp_xml_preparedocument @XmlRecord OUTPUT, @XmlStr
Insert InTo #Temp(ID)
Select ID
From OpenXML (@XmlRecord, '/ROOT/DeleteLine', 2)
WITH (ID VARCHAR(10)) b
--SELECT * FROM #Temp
END
ELSE
BEGIN
Insert InTo #Temp(ID)
Select ID From SplitIDs(@StrIDs)
--SELECT * FROM #Temp
END


DECLARE @varMaxCount BIGINT

DECLARE @varCurrentCount BIGINT

DECLARE @varDisplayOrder INT
DECLARE @ID INT
DECLARE @strSql varchar(5000),@strSqlNew varchar(5000),@strSqlNew1 varchar(5000)

SET @varCurrentCount =1
SET @varDisplayOrder=0
SET @ID=0
SET @strSql=''
SET @strSqlNew=''
SET @strSqlNew1=''

SELECT @varMaxCount =max(RowID) FROM #Temp

WHILE (@varCurrentCount <=@varMaxCount)

BEGIN
SET @strSql=''
SET @strSqlNew=''
SET @strSqlNew1=''

SELECT @ID=ID FROM #Temp WHERE RowID=@varCurrentCount
SET @strSql = @strSql + ' SELECT DisplayOrder FROM '+@TableName+' WHERE '+@FieldName+'='+cast(@ID as varchar(100))

INSERT INTO #TempDisplayOrder(DisplayOrder)
EXEC(@strSql)
SELECT @varDisplayOrder=DisplayOrder FROM #TempDisplayOrder

SET @strSqlNew =@strSqlNew+' Update '+ @TableName +' Set DisplayOrder=DisplayOrder - 1 WHERE DisplayOrder > '+cast(@varDisplayOrder as Varchar(100))
SET @strSqlNew1 =@strSqlNew1+' DELETE FROM '+ @TableName +' WHERE '+@FieldName+'='+cast(@ID as varchar(100))
--print @strSqlNew
--print @strSqlNew1
EXEC(@strSqlNew)
EXEC(@strSqlNew1)
DELETE FROM #TempDisplayOrder
SET @varCurrentCount = @varCurrentCount + 1

END

On Key Press

function onkeyPress(e)
{
var key = window.event ? e.keyCode : e.which;
if (key == 13) StartClick(); e.cancelBubble = true; e.returnValue = false; return false;
}
USE
onkeypress="return onkeyPress(event);"

Mix Solutions

http://www.eggheadcafe.com/forumtree.aspx?userID=36927da0-bf19-483d-8843-403528a4e018