Tech Juice

ASP.NET Page Lifecycle... confusing??? I dont think so...

2012-01-31T19:59:00.000+05:30

Ever faced the question about ASP.NET page life cycle in interview... pretty easy... but if MasterPage comes in... it makes it slight difficult... isn't it??? and what if the controls are present on the page.. and few on MasterPage... things are getting tough... isn't it...

To make the thinks easier just go through the chronological order of the events that are followed from pre-init to unload...

Following is the order of events of an ASP.NET page when using master page... read on...

Page PreInit
MasterPageControl Init
PageControl Init
MasterPage Init
Page Init
Page ViewStateLoad
MasterPage ViewStateLoad
Page PreLoad
Page Load
MasterPage Load
MasterPageControl Load
PageControl Load
PageControl Event
MasterPage BubbleEvent
Page BubbleEvent
PageLoad Complete
Page Prerender
MasterPage PreRender
MasterPageControl PreRender
PageControl PreRender
Page PreRenderComplete
MasterPage ControlStateSave
Page ControlStateSave
Page ViewStateSave
MasterPage ViewStateSave
Page SaveState
MasterPageControl Unload
PageControl Unload
MasterPage Unload
Page Unload

Comma separated values from Stored Procedure

2011-03-22T13:03:00.000+05:30

You might have stuck in a position where you need all or certain values of a particular column as comma separated string in your application. What do you do in that case?

Well, the generic approach for this is return the DataTable and iterate its column while adding comma after each value and forming a string or

we can read the result in a DataReader and keep reading it till next while following the above mentioned approach.

If the database server performance is not a major issue for you and if you prefer to write less code, in that case...

Here is a quick solution to perform the same at the database level...

Use the following query to get the values in a comma separated string...

SELECT SUBSTRING(
(SELECT ',' + <Column Name>
FROM <Table Name>
FOR XML PATH('')),2,200000) AS <Column Name to be displayed in result>

I hope it is helpful to you in some or the other cases.

Continued - Create all basic stored procedures for any table

2011-03-18T14:29:00.000+05:30

In addition to my previous post of creating stored procedures for given table...

Here is the query that make use of previously created SP "MyTool" and create stored procedures for all user created tables in the current database...

So you don't need to execute my tool again and again for all the tables...

DECLARE @Count INT
DECLARE @spName VARCHAR(100)
DECLARE @COUNTER INT
SET @COUNTER = 0
SET @Count = 1

SELECT @COUNTER = count(name) FROM sys.tables WHERE name != 'sysdiagrams'
WHILE (@Count<=@COUNTER)
BEGIN
SELECT @spName = SpName FROM
(
SELECT row_number() OVER (ORDER BY name) "RowId", name "SpName" FROM sys.tables WHERE name != 'sysdiagrams'
) "A" WHERE RowId = @Count
EXEC MyTool @spName
SET @Count = @Count + 1
END

Please provide your valuable feedback as it will help me to get better and help others better...

Create all basic stored procedures for any table

2011-03-18T13:13:00.001+05:30

Here is the another quick solution to the SQL server database users for creating all basic stored procedures for any given table...

Thanks to Kailash Paliwal, Ashish Chitranshi and Abhishek Mishra(my friends and the webteam) to search and make this functioning.

So read on and enjoy the database using database...

USE [dbName]
GO
/****** Object: StoredProcedure [dbo].[MyTool] Script Date: 02/25/2011 05:53:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[MyTool]
@tblName Varchar(50)
AS
BEGIN

--CREATE TABLE #tmp_Structure
--(
--IsIdentity VARCHAR(MAX),
--[Table] VARCHAR(MAX),
--colId VARCHAR(MAX),
--ColumnName VARCHAR(MAX),
--ColumnVariable VARCHAR(MAX),
--DataType VARCHAR(MAX),
--ColumnParameter VARCHAR(MAX)
--)

Declare @dbName Varchar(50)
Declare @insertSPName Varchar(50), @updateSPName Varchar(50), @deleteSPName Varchar(50), @searchSPName Varchar(50), @getSPName Varchar(50);
Declare @tablColumnParameters Varchar(max);
Declare @tableColumns Varchar(max)
Declare @tableColumnVariables Varchar(max);
Declare @tablColumnParametersUpdate Varchar(max);
Declare @tablColumnParametersSearch Varchar(max);
Declare @tableCols Varchar(max);
Declare @tableColsSearch Varchar(max);
Declare @space Varchar(50);
Declare @maxspace Varchar(500);
Declare @spaceHalf Varchar(50) ;
Declare @colName Varchar(100) ;
Declare @colVariable Varchar(100) ;
Declare @colParameter Varchar(100) ;
Declare @colIdentity bit ;
Declare @strSpText Varchar(max);
Declare @updCols Varchar(max);
Declare @delParamCols Varchar(max);
Declare @whereCols Varchar(max);
Declare @whereSearchCols Varchar(max);
DECLARE @lengthOfColumnToCountSpaces Varchar(50)
Set @tblName = SubString(@tblName,CharIndex('.',@tblName)+1, Len(@tblName))

Set @insertSPName = '[dbo].[Insert' + Replace(@tblName,'_','') +']' ;
Set @updateSPName = '[dbo].[Update' + Replace(@tblName,'_','') +']' ;
Set @deleteSPName = '[dbo].[Delete' + Replace(@tblName,'_','') +']' ;
Set @searchSPName = '[dbo].[Search' + Replace(@tblName,'_','') +']' ;
Set @getSPName = '[dbo].[Get' + Replace(@tblName,'_','') +']' ;

SET @lengthOfColumnToCountSpaces = 0
Set @space = REPLICATE(' ', 4) ;
Set @spaceHalf = REPLICATE(' ', 2) ;
Set @tablColumnParameters = '' ;
Set @tableColumns = '' ;
Set @tableColumnVariables = '' ;
Set @strSPText = '' ;
Set @tableCols = '' ;
Set @tableColsSearch = '' ;
Set @updCols = '' ;
Set @delParamCols = '' ;
Set @whereCols = '' ;
set @whereSearchCols = '';
Set @tablColumnParametersUpdate = '' ;
Set @tablColumnParametersSearch = '' ;
SET NOCOUNT ON

/*
To get the length of max cloumn
*/
SELECT @lengthOfColumnToCountSpaces = max(COUNT) FROM
(
SELECT LEN(syscolumns.name) "Count",syscolumns.name FROM sysobjects sysobjects , syscolumns , systypes
WHERE sysobjects.id = syscolumns.id
and syscolumns.xusertype = systypes.xusertype
and sysobjects.xtype = 'u'
and sysobjects.name = @tblName
and systypes.xusertype not in (189)
) "a"
PRINT @lengthOfColumnToCountSpaces
/*
To get the length of max cloumn
*/
SET @lengthOfColumnToCountSpaces = ISNULL(@lengthOfColumnToCountSpaces,0)
set @maxspace = REPLICATE(' ', @lengthOfColumnToCountSpaces) ;
-- Get all columns & data types for a table
--INSERT INTO #tmp_Structure
SELECT distinct
COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'IsIdentity') as 'IsIdentity',
sysobjects.name as 'Table',
syscolumns.colid ,
'[' + syscolumns.name + ']' as 'ColumnName',
'@'+syscolumns.name as 'ColumnVariable',
upper(systypes.name) +
Case When systypes.xusertype in (165,167,175,231,239 ) Then '(' + REPLACE(Convert(varchar(10),syscolumns.prec),'-1','max') +')' Else '' end as 'DataType' ,
--'@'+syscolumns.name + REPLICATE(' ',((convert(INT,@lengthOfColumnToCountSpaces) + convert(INT,'25')))) + UPPER(systypes.name) +
'@'+syscolumns.name + REPLICATE(' ',((convert(INT,@lengthOfColumnToCountSpaces) + convert(INT,'15')) - convert(INT,len(syscolumns.name)))) + UPPER(systypes.name) +
--'@'+syscolumns.name + REPLICATE(' ',(convert(INT,@lengthOfColumnToCountSpaces) + convert(INT,@spaceHalf))) + UPPER(systypes.name) +
Case When systypes.xusertype in (165,167,175,231,239 ) Then '(' + REPLACE(Convert(varchar(10),syscolumns.prec),'-1','max') +')' Else '' end as 'ColumnParameter'
Into #tmp_Structure
From sysobjects , syscolumns , systypes
Where sysobjects.id = syscolumns.id
and syscolumns.xusertype = systypes.xusertype
and sysobjects.xtype = 'u'
and sysobjects.name = @tblName
and systypes.xusertype not in (189)
Order by syscolumns.colid
SELECT * FROM #tmp_Structure

-- Get all Primary KEY columns & data types for a table
SELECT t.name as 'Table',
c.colid ,
'[' + c.name + ']' as 'ColumnName',
'@'+c.name as 'ColumnVariable',
systypes.name +
Case When systypes.xusertype in (165,167,175,231,239 ) Then '(' + Convert(varchar(10),c.length) +')' Else '' end as 'DataType' ,
'@'+c.name + ' ' + systypes.name +
Case When systypes.xusertype in (165,167,175,231,239 ) Then '(' + Convert(varchar(10),c.length) +')' Else '' end as 'ColumnParameter'
Into #tmp_PK_Structure
FROM sysindexes i, sysobjects t, sysindexkeys k, syscolumns c, systypes
WHERE i.id = t.id AND
i.indid = k.indid AND i.id = k.ID And
c.id = t.id AND c.colid = k.colid AND
i.indid BETWEEN 1 And 254 AND
c.xusertype = systypes.xusertype AND
(i.status & 2048) = 2048 AND t.id = OBJECT_ID(@tblName)

/* Read the table structure and populate variables*/
Declare SpText_Cursor Cursor For
Select ColumnName, ColumnVariable, ColumnParameter, IsIdentity
From #tmp_Structure

Open SpText_Cursor

Fetch Next From SpText_Cursor Into @colName, @colVariable, @colParameter, @colIdentity
While @@FETCH_STATUS = 0
Begin
If (@colIdentity=0)
Begin
Set @tablColumnParameters = @tablColumnParameters + @colParameter + CHAR(13) + @space + ',' ;
Set @tableCols = @tableCols + @colName + ',' ;
Set @tableColumns = @tableColumns + @colName + CHAR(13) + @space + @space + ',' ;
Set @tableColumnVariables = @tableColumnVariables + @colVariable + CHAR(13) + @space + @space + ',' ;
Set @updCols = @updCols + @colName + ' = ' + @colVariable + CHAR(13) + @space + @space + ',' ;
End

Set @tableColsSearch = @tableColsSearch + @colName + CHAR(13) + @space + @space + ',' ;

Set @tablColumnParametersUpdate = @tablColumnParametersUpdate + @colParameter + CHAR(13) + @space + ',' ;
Set @tablColumnParametersSearch = @tablColumnParametersSearch + @colParameter + '= NULL' + CHAR(13) + @space +',';
--Set @tablColumnParametersSearch = @tablColumnParametersSearch + @colParameter + '= NULL,' + CHAR(13) + @space;
Fetch Next From SpText_Cursor Into @colName, @colVariable, @colParameter , @colIdentity
End

Close SpText_Cursor
Deallocate SpText_Cursor

/* Read the Primary Keys from the table and populate variables*/
Declare SpPKText_Cursor Cursor For
Select ColumnName, ColumnVariable, ColumnParameter
From #tmp_PK_Structure

Open SpPKText_Cursor
Fetch Next From SpPKText_Cursor Into @colName, @colVariable, @colParameter
While @@FETCH_STATUS = 0
Begin
Set @delParamCols = @delParamCols + @colParameter + CHAR(13) + @space + ',' ;
Set @whereCols = @whereCols + @colName + ' = ' + @colVariable + ' AND ' ;
Fetch Next From SpPKText_Cursor Into @colName, @colVariable, @colParameter
End
Close SpPKText_Cursor
Deallocate SpPKText_Cursor

/* Read the table structure and get all columns to search data*/
Declare SpText_Cursor Cursor For
Select ColumnName, ColumnVariable
From #tmp_Structure
Open SpText_Cursor
Fetch Next From SpText_Cursor Into @colName, @colVariable
While @@FETCH_STATUS = 0
Begin
Set @whereSearchCols = @whereSearchCols + '(' + @colVariable + ' IS NULL OR ' + @colName + ' = ' + @colVariable + ')' + ' AND ' + CHAR(13) + @space + @space + @spaceHalf;
Fetch Next From SpText_Cursor Into @colName, @colVariable
End
Close SpText_Cursor
Deallocate SpText_Cursor
-- Stored procedure scripts starts here
If (LEN(@tablColumnParameters)>0)
Begin
Set @tablColumnParameters = LEFT(@tablColumnParameters,LEN(@tablColumnParameters)-1) ;
Set @tablColumnParametersUpdate = LEFT(@tablColumnParametersUpdate,LEN(@tablColumnParametersUpdate)-1) ;
Set @tablColumnParametersSearch = LEFT(@tablColumnParametersSearch,LEN(@tablColumnParametersSearch)-1) ;
Set @tableColumnVariables = LEFT(@tableColumnVariables,LEN(@tableColumnVariables)-1) ;
Set @tableColumns = LEFT(@tableColumns,LEN(@tableColumns)-1) ;
Set @tableCols = LEFT(@tableCols,LEN(@tableCols)-1) ;
Set @tableColsSearch = LEFT(@tableColsSearch,LEN(@tableColsSearch)-1) ;
Set @updCols = LEFT(@updCols,LEN(@updCols)-1) ;

If (LEN(@whereCols)>0)
Begin
Set @whereSearchCols = 'WHERE ' + LEFT(@whereSearchCols,LEN(@whereSearchCols)-6) ;
Set @whereCols = 'WHERE ' + LEFT(@whereCols,LEN(@whereCols)-4) ;
Set @delParamCols = LEFT(@delParamCols,LEN(@delParamCols)-1) ;
End
ELSE
BEGIN
Set @whereSearchCols = 'WHERE ' + LEFT(@whereSearchCols,LEN(@whereSearchCols)-6) ;
END

/* Create INSERT stored procedure for the table if it does not exist */
IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(@insertSPName) AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
Begin
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + '/*-- ============================================='
Set @strSPText = @strSPText + CHAR(13) + '-- Author : dbo'
Set @strSPText = @strSPText + CHAR(13) + '-- Create date : ' + Convert(varchar(20),Getdate())
Set @strSPText = @strSPText + CHAR(13) + '-- Description : Insert Procedure for ' + @tblName
Set @strSPText = @strSPText + CHAR(13) + '-- Exec ' + @insertSPName + ' ' + @tableCols
Set @strSPText = @strSPText + CHAR(13) + '-- ============================================= */'
Set @strSPText = @strSPText + CHAR(13) + 'CREATE PROCEDURE ' + @insertSPName
Set @strSPText = @strSPText + CHAR(13) + @space + ' ' + @tablColumnParameters
Set @strSPText = @strSPText + CHAR(13) + 'AS'
Set @strSPText = @strSPText + CHAR(13) + 'BEGIN'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + @space + 'INSERT INTO [dbo].['+@tblName +']'
Set @strSPText = @strSPText + CHAR(13) + @space + '( '
Set @strSPText = @strSPText + CHAR(13) + @space + @space + ' ' + @tableColumns
Set @strSPText = @strSPText + CHAR(13) + @space + ')'
Set @strSPText = @strSPText + CHAR(13) + @space + 'VALUES'
Set @strSPText = @strSPText + CHAR(13) + @space + '('
Set @strSPText = @strSPText + CHAR(13) + @space + @space + ' ' + @tableColumnVariables
Set @strSPText = @strSPText + CHAR(13) + @space + ')'
Set @strSPText = @strSPText + CHAR(13) + 'END'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
-- Print @strSPText ;

Exec(@strSPText);

if (@@ERROR=0)
Print 'Procedure ' + @insertSPName + ' Created Successfully '

End
Else
Begin
Print 'Sorry!! ' + @insertSPName + ' Already exists in the database. '
End

/* Create UPDATE stored procedure for the table if it does not exist */
IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(@updateSPName) AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
Begin
Set @strSPText = ''
Set @strSPText = @strSPText + CHAR(13) + '/*-- ============================================='
Set @strSPText = @strSPText + CHAR(13) + '-- Author : dbo'
Set @strSPText = @strSPText + CHAR(13) + '-- Create date : ' + Convert(varchar(20),Getdate())
Set @strSPText = @strSPText + CHAR(13) + '-- Description : Update Procedure for ' + @tblName
Set @strSPText = @strSPText + CHAR(13) + '-- Exec ' + @updateSPName + ' ' + @tableCols
Set @strSPText = @strSPText + CHAR(13) + '-- ============================================= */'
Set @strSPText = @strSPText + CHAR(13) + 'CREATE PROCEDURE ' + @updateSPName
Set @strSPText = @strSPText + CHAR(13) + @space + ' ' + @tablColumnParametersUpdate
Set @strSPText = @strSPText + CHAR(13) + 'AS'
Set @strSPText = @strSPText + CHAR(13) + 'BEGIN'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + @space + 'UPDATE [dbo].['+@tblName +']'
Set @strSPText = @strSPText + CHAR(13) + @space + 'SET '
Set @strSPText = @strSPText + CHAR(13) + @space + @space + ' ' + @updCols
Set @strSPText = @strSPText + CHAR(13) + @space + @whereCols
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + 'END'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
-- Print @strSPText ;
Exec(@strSPText);

if (@@ERROR=0)
Print 'Procedure ' + @updateSPName + ' Created Successfully '
End
Else
Begin
Print 'Sorry!! ' + @updateSPName + ' Already exists in the database. '
End
/* Create DELETE stored procedure for the table if it does not exist */
IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(@deleteSPName) AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
Begin
Set @strSPText = ''
Set @strSPText = @strSPText + CHAR(13) + '/*-- ============================================='
Set @strSPText = @strSPText + CHAR(13) + '-- Author : dbo'
Set @strSPText = @strSPText + CHAR(13) + '-- Create date : ' + Convert(varchar(20),Getdate())
Set @strSPText = @strSPText + CHAR(13) + '-- Description : Delete Procedure for ' + @tblName
Set @strSPText = @strSPText + CHAR(13) + '-- Exec ' + @deleteSPName + ' ' + @delParamCols
Set @strSPText = @strSPText + CHAR(13) + '-- ============================================= */'
Set @strSPText = @strSPText + CHAR(13) + 'CREATE PROCEDURE ' + @deleteSPName
Set @strSPText = @strSPText + CHAR(13) + @space + ' ' + @delParamCols
Set @strSPText = @strSPText + CHAR(13) + 'AS'
Set @strSPText = @strSPText + CHAR(13) + 'BEGIN'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + @space + 'DELETE FROM [dbo].['+@tblName +']'
Set @strSPText = @strSPText + CHAR(13) + @space + @whereCols
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + 'END'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
-- Print @strSPText ;
Exec(@strSPText);

if (@@ERROR=0)
Print 'Procedure ' + @deleteSPName + ' Created Successfully '
End
Else
Begin
Print 'Sorry!! ' + @deleteSPName + ' Already exists in the database. '
END
/* Create Search stored procedure for the table if it does not exist */
IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(@searchSPName) AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
Begin
Set @strSPText = ''
Set @strSPText = @strSPText + CHAR(13) + '/*-- ============================================='
Set @strSPText = @strSPText + CHAR(13) + '-- Author : dbo'
Set @strSPText = @strSPText + CHAR(13) + '-- Create date : ' + Convert(varchar(20),Getdate())
Set @strSPText = @strSPText + CHAR(13) + '-- Description : Search Procedure for ' + @tblName
Set @strSPText = @strSPText + CHAR(13) + '-- Exec ' + @searchSPName + ' ' + @tableCols
Set @strSPText = @strSPText + CHAR(13) + '-- ============================================= */'
Set @strSPText = @strSPText + CHAR(13) + 'CREATE PROCEDURE ' + @searchSPName
Set @strSPText = @strSPText + CHAR(13) + @space + ' ' + @tablColumnParametersSearch
Set @strSPText = @strSPText + CHAR(13) + 'AS'
Set @strSPText = @strSPText + CHAR(13) + 'BEGIN'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + @space + 'SELECT '+@tableColsSearch+' FROM [dbo].['+@tblName +']'
Set @strSPText = @strSPText + CHAR(13) + @space + @whereSearchCols
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + 'END'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
--Print @strSPText ;
Exec(@strSPText);

if (@@ERROR=0)
Print 'Procedure ' + @searchSPName + ' Created Successfully '
End
Else
Begin
Print 'Sorry!! ' + @searchSPName + ' Already exists in the database. '
End

/* Create Get stored procedure for the table if it does not exist */
IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(@getSPName) AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
Begin
Set @strSPText = ''
Set @strSPText = @strSPText + CHAR(13) + '/*-- ============================================='
Set @strSPText = @strSPText + CHAR(13) + '-- Author : dbo'
Set @strSPText = @strSPText + CHAR(13) + '-- Create date : ' + Convert(varchar(20),Getdate())
Set @strSPText = @strSPText + CHAR(13) + '-- Description : Search Procedure for ' + @tblName
Set @strSPText = @strSPText + CHAR(13) + '-- Exec ' + @getSPName + ' ' + @tableCols
Set @strSPText = @strSPText + CHAR(13) + '-- ============================================= */'
Set @strSPText = @strSPText + CHAR(13) + 'CREATE PROCEDURE ' + @getSPName
--Set @strSPText = @strSPText + CHAR(13) + @space + ' ' + @tablColumnParametersSearch
Set @strSPText = @strSPText + CHAR(13) + 'AS'
Set @strSPText = @strSPText + CHAR(13) + 'BEGIN'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + @space + 'SELECT '+@tableColsSearch+' FROM [dbo].['+@tblName +']'
--Set @strSPText = @strSPText + CHAR(13) + @space + @whereSearchCols
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + 'END'
Set @strSPText = @strSPText + CHAR(13) + ''
Set @strSPText = @strSPText + CHAR(13) + ''
--Print @strSPText ;
Exec(@strSPText);

if (@@ERROR=0)
Print 'Procedure ' + @getSPName + ' Created Successfully '
End
Else
Begin
Print 'Sorry!! ' + @getSPName + ' Already exists in the database. '
End

End
Drop table #tmp_Structure
Drop table #tmp_PK_Structure
END

An Ideal Log4Net configuration file

2011-03-17T17:46:00.006+05:30

Well after receiving my first assignment on new job, I researched a lot on Google for Log4Net implementation and after 2 days of hair pulling I came up with this...

An idle configuration file to write to different log files for different types/levels of messages... check out and contact if require any clarification...

Just in your code behind use the following line, to implement the logging...

ILog ln = LogManager.GetLogger("<Logger Name from configuration>");
ln.Error(<message>, <exception>);

And use the following as the configuration settings for Log4Net... (Either put it in Web.Config or in a separate XML file)

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
  </configSections>
  <!-- Log4Net configuration settings -->
  <log4net debug="true">
    <appender type="log4net.Appender.RollingFileAppender" name="DebugAppender">
      <file value="DebugLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
      <filter type="log4net.Filter.LevelMatchFilter">
        <levelToMatch value="DEBUG" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>

    <appender type="log4net.Appender.RollingFileAppender" name="WarnAppender">
      <file value="WarnLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
      <filter type="log4net.Filter.LevelMatchFilter">
        <levelToMatch value="WARN" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>

    <appender type="log4net.Appender.RollingFileAppender" name="ErrorAppender">
      <file value="ErrorLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
      <filter type="log4net.Filter.LevelMatchFilter">
        <levelToMatch value="ERROR" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>

    <appender type="log4net.Appender.RollingFileAppender" name="FatalAppender">
      <file value="FatalLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
      <filter type="log4net.Filter.LevelMatchFilter">
        <levelToMatch value="FATAL" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>

    <appender type="log4net.Appender.RollingFileAppender" name="InfoAppender">
      <file value="InfoLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
      <filter type="log4net.Filter.LevelMatchFilter">
        <levelToMatch value="INFO" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>

    <appender type="log4net.Appender.RollingFileAppender" name="GenericAppender">
      <file value="ALLLog.xml" />
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="10"/>
      <maximumFileSize value="20KB"/>
      <staticLogFileName value="true"/>
      <lossy value="false" />
      <!--<layout type="log4net.Layout.PatternLayout">
        <conversionpattern value="%d [%t] %-5p %c - %m%n" />
      </layout>-->
      <layout type="log4net.Layout.XmlLayout">
        <param name="Prefix" value="log4net" />
      </layout>
    </appender>

    <logger name="DebugLogger">
      <level value="DEBUG" />
      <appender-ref ref="DebugAppender" />
    </logger>

    <logger name="WarnLogger">
      <level value="WARN" />
      <param value="WARN" name="Threshold" />

      <appender-ref ref="WarnAppender" />
    </logger>

    <logger name="ErrorLogger">
      <level value="ERROR" />
      <param value="ERROR" name="Threshold" />

      <appender-ref ref="ErrorAppender" />
    </logger>

    <logger name="FatalLogger">
      <level value="FATAL" />
      <param value="FATAL" name="Threshold" />

      <appender-ref ref="FatalAppender" />
    </logger>

    <logger name="InfoLogger">
      <level value="INFO" />
      <param value="INFO" name="Threshold" />
     
      <appender-ref ref="InfoAppender" />
    </logger>

  </log4net>
  <!-- Log4Net configuration settings ends -->

</configuration>

Always set the "applicationName" property when configuring ASP.NET 2.0 Membership and other Providers

2011-01-18T13:01:00.000+05:30

Thanks to Scott for creating a nice blog. I'm sharing the same:

After getting stuck and lots of hair pulling to setup the membership provider, I figured out that the problem arising during logins and role setup on live server was because of "Application Name" entry in web.config file.

Here it is to help you folks out of the trouble...

Scenario:

You develop an ASP.NET 2.0 application locally using the new ASP.NET 2.0 Membership, Roles or Profile features. You create several new users and everything works fine.

You then copy the application to a remote server (or even another directory on your local server) and run the application. For some reason it appears that you are able to connect to your membership database just fine – but when you try to login it doesn’t let you. It doesn’t throw a connection error, but rather when you attempt to login you get an error message that says something like: “Login attempt unsuccessful, please try again.”

Cause:

The reason this usually happens is because a membership (or roles or profile) provider has been added in the application’s web.config file – but without an applicationName attribute being specified (assume below that the applicationName in bold was missing):

<add name="AspNetSqlMembershipProvider"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="LocalSqlServer"

enablePasswordRetrieval="false"

enablePasswordReset="true"

requiresQuestionAndAnswer="true"

requiresUniqueEmail="false"

passwordFormat="Hashed"

maxInvalidPasswordAttempts="5"

minRequiredPasswordLength="7"

minRequiredNonalphanumericCharacters="1"

passwordAttemptWindow="10"

passwordStrengthRegularExpression=""

applicationName="/"

</providers>

</membership>

When no applicationName attribute is configured, ASP.NET uses the application vroot path within the web-server to automatically calculate the applicationName to use when adding data to an ASP.NET Application Service database. To see this in action, you can open up your ASPNETDB database, and look within the aspnet_Applications table:

This table stores a unique ApplicationID for each applicationName. Because I didn’t specify an “applicationName” attribute when I registered users within my application, it calculated the application name as /website8 (which happened to be the name my dev machine was using at the time).

Users created with the membership API will then be associated with this ApplicationID and in turn the applicationName. You can see this by opening up the aspnet_Users table:

This works fine when the application continues to run in the “/WebSite8” application virtual path. But if it is copied to another location or server with a different virtual path (for example: “/app1” or more commonly just "/"), then when the Membership APIs are used they will not “see” the users already in our database – since they will lookup membership data using a different application name and filter the users in the application_Users table accordingly. That is why you’ll get a “Login attempt unsuccessful, please try again.” message when you try to login.

How to Solve This

The easiest way to solve this is to open up the aspnet_Users and aspnet_Applications tables within the ASPNETDB database and figure out what application name was used when creating the users and other data during development (look in the aspnet_Application table to work this out).

You can then go back to your web.config file, and add an “applicationName” attribute to your provider declaration with that application name value. For example, note how the applicationName value below is now the same as the one in the aspnet_Application table:

<add name="AspNetSqlMembershipProvider"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="LocalSqlServer"

enablePasswordRetrieval="false"

enablePasswordReset="true"

requiresQuestionAndAnswer="true"

requiresUniqueEmail="false"

passwordFormat="Hashed"

maxInvalidPasswordAttempts="5"

minRequiredPasswordLength="7"

minRequiredNonalphanumericCharacters="1"

passwordAttemptWindow="10"

passwordStrengthRegularExpression=""

applicationName="/website8"

</providers>

</membership>

When the applicationName is set like above, the Membership API will always use that application name when connecting to the ASP.NET application service database. That means it will work regardless of where the application is deployed or what path is used.

You should also then make sure that you do this for any Roles, Profile, WebPartPersonalization or other providers you configure.

Your application will then work fine.

How to Prevent This in the First Place

The best way to prevent this from ever happening is to always specify the “applicationName” attribute when declaring your providers. One good default value to use is “/” – which is the root application name. This is the value specified for the default provider that ships with ASP.NET 2.0 (which by default stores the application service data within the ASPNETDB.MDF file under /app_data), and is why if you don’t override the provider settings it will work if you copy an app to another machine.

P.S. In case it isn’t obvious, the reason why the applicationName setting even exists in the first place is so that you can map multiple applications and sites to the same database.

P.P.S. In hindsight, we should have defaulted the provider collection to have a value of "/" for applicationName if it wasn't specified.

Courtesy: Scott at ScottGu (http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx)

Character counter with limit facility

2010-11-23T15:06:00.015+05:30

Ever stuck with requirement to count the characters in a textbox in real time. Here is the simplest solution... Just use this JavaScript and you are done...

Step 1: Put the following script in head section of your page (htm, asp, aspx, php....)

var count = "250";

var len = "0";

function limiter() {

var tex = document.form1.txtmailmsg.value;

len = tex.length;

if (len > count) {

tex = tex.substring(0, count);

document.form1.txtmailmsg.value = tex;

document.getElementById("limit").innerHTML = len;

return false;

}

document.getElementById("limit").innerHTML = len;

}

</script>

Step 2: Create a textbox or input - type text or textarea or what ever you may call it.

Step 3: Call the function on "onKeyUp" event of the desired textbox.

<asp:textbox id="txtmailmsg" onkeyup="limiter()" runat="server" textmode="MultiLine"></asp:textbox>

Step 4: Put the following script at the desired place to display the counter

document.write("<label id=limit>" + len + "</label>");

</script>

And you are done with the counter/limiter for your textbox.

Note: The reason to create label using JavaScript is to display the default number of character even for the first time as soon as page loads. If you don't need this, just put a simple label with id="limit"

Found it useful, please provide your comments...

Image resizer in .NET, works for web as well windows apps

2010-09-17T14:52:00.006+05:30

Hi all,

Welcome to my next post, have you ever came across the problem of resizing an image to a different size and your code of .Net is resulting in blurry or low quality images. I can bet that if you are in image related website design or development, you must have come across this problem or if not must be finding a way to do it efficiently, because I faced lots of problem while working on my project "http://www.movietadka.com", and collected the following information after searching on Google for whole day.

Well here is the solution...

First we need to have 3 functions, named:

Function 1: Contains logic for maintaining aspect ratio and quality of image...

resizeImage(Image imgToResize, int newWidth, int newHeight)

Parameters are as follows:

imgToResize: The original image which needs to be resized

newWidth: The desired width for the resultant image

newHeight: The desired height for the resultant image

The Function will look like this:

public static Image resizeImage(Image imgToResize, int newWidth, int newHeight)
{
int sourceWidth = imgToResize.Width;
int sourceHeight = imgToResize.Height;

float nPercent = 0;
float nPercentW = 0;
float nPercentH = 0;

nPercentW = ((float)width / (float)sourceWidth);
nPercentH = ((float)height / (float)sourceHeight);

if (nPercentH < nPercentW)
nPercent = nPercentH;
else
nPercent = nPercentW;

int destWidth = (int)(sourceWidth * nPercent);
int destHeight = (int)(sourceHeight * nPercent);

Bitmap b = new Bitmap(destWidth, destHeight);
Graphics g = Graphics.FromImage((Image)b);
g.InterpolationMode = InterpolationMode.HighQualityBicubic;

g.DrawImage(imgToResize, 0, 0, destWidth, destHeight);
g.Dispose();

return (Image)b;
}

Function 2: Contains logic for saving the image with desired quality at given path

saveJpeg(string path, Image resultImage, long quality)

Parameters are as follows:

path: Location to save the new image to

resultImage: resized image to be saved at path defined above

quality: a long value varying form 0 to 100, depicting the compression ration for image

"Lesser the value, lesser the compression, resulting in higher the quality and higher physical file size and similarly opposite for higher value."

The function will look like this:

void saveJpeg(string path, Image resultImage, long quality)
{
// Encoder parameter for image quality
EncoderParameter qualityParam = new EncoderParameter (System.Drawing.Imaging.Encoder.Quality, quality);

// Jpeg image codec
ImageCodecInfo jpegCodec = this.getEncoderInfo("image/jpeg");

if (jpegCodec == null)
return;

EncoderParameters encoderParams = new EncoderParameters(1);
encoderParams.Param[0] = qualityParam;

resultImage.Save(path, jpegCodec, encoderParams);
}

Function 3: Contains logic for finding the EncoderInformation of required image type (here we are using jpeg)

Parameter as follows:

mimeType: The type image type for which the Codec Information is to be found ("image/jpeg" is used in our example)

getEncoderInfo(string mimeType)

ImageCodecInfo getEncoderInfo(string mimeType)
{
// Get image codecs for all image formats
ImageCodecInfo[] codecs = ImageCodecInfo.GetImageEncoders();

// Find the correct image codec
for (int i = 0; i < codecs.Length; i++)
if (codecs[i].MimeType == mimeType)
return codecs[i];
return null;
}

To use just call resizeImage function with all parameters and it just works...

Now just go ahead and resize the images in desired sizes and quality.

This is Shashank Sharma, signing off for now. Will be back soon with some more cooked solutions...

Enjoy life

2010-08-05T16:36:00.002+05:30

174 Run Commands For Windows XP

Below is the list of run commands for Windows XP OS, some of them may work in older or newer versions of windows, and few of them may require the associated application to be installed on your computer. Just go to run dialog box and type the command listed below.

All commands listed below are in alphabetical order

Program	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat ( if installed )	acrobat
Adobe Distiller ( if installed )	acrodist
Adobe ImageReady ( if installed )	imageready
Adobe Photoshop ( if installed )	photoshop
Automatic Updates	wuaucpl.cpl

Basic Media Player	mplay32
Bluetooth Transfer Wizard	fsquirt

Calculator	calc
Ccleaner ( if installed )	ccleaner
C: Drive	c:
Certificate Manager	cdrtmgr.msc
Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Command Prompt	cmd
Command Prompt	command
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Compare Files	comp
Control Panel	control
Create a shared folder Wizard	shrpubw
Date and Time Properties	timedate.cpl
DDE Shares	ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel ( if installed )	directx.cpl
Direct X Troubleshooter	dxdiag
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Partition Manager	diskmgmt.msc
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected )	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	verifier
Ethereal ( if installed )	ethereal
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	migwiz
File Signature Verification Tool	sigverif
Findfast	findfast.cpl
Firefox	firefox
Folders Properties	control folders
Fonts	fonts
Fonts Folder	fonts
Free Cell Card Game	freecell
Game Controllers	joy.cpl
Group Policy Editor ( xp pro )	gpedit.msc
Hearts Card Game	mshearts
Help and Support	helpctr
Hyperterminal	hypertrm
Hotline Client	hotlineclient
Iexpress Wizard	iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwonn1
Internet Properties	inetcpl.cpl
Internet Setup Wizard	inetwiz
IP Configuration (Display Connection Configuration)	ipconfig /all
IP Configuration (Display DNS Cache Contents)	ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents)	ipconfig /flushdns
IP Configuration (Release All Connections)	ipconfig /release
IP Configuration (Renew All Connections)	ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)	ipconfig /registerdns
IP Configuration (Display DHCP Class ID)	ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)	ipconfig /setclassid
Java Control Panel ( if installed )	jpicpl32.cpl
Java Control Panel ( if installed )	javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out of Windows	logoff
Malicious Software Removal Tool	mrt
Microsoft Access ( if installed )	access.cpl
Microsoft Chat	winchat
Microsoft Excel ( if installed )	excel
Microsoft Diskpart	diskpart
Microsoft Frontpage ( if installed )	frontpg
Microsoft Movie Maker	moviemk
Microsoft Management Console	mmc
Microsoft Narrator	narrator
Microsoft Paint	mspaint
Microsoft Powerpoint	powerpnt
Microsoft Word ( if installed )	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
MS-Dos Editor	edit
MS-Dos FTP	ftp
Nero ( if installed )	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager ( if installed )	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter ( if installed )	ac3filter.cpl
Outlook Express	msimn
Paint	pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Characters Editor	eudcedit
Quicktime ( if installed )	quicktime.cpl
Quicktime Player ( if installed )	quicktimeplayer
Real Player ( if installed )	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Remote Desktop	mstsc
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy ( xp pro )	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
Security Center	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Sharing Session	rtcshare
Shuts Down Windows	shutdown
Sounds Recorder	sndrec32
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	clicongf
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility ( Scan Immediately )	sfc /scannow
System File Checker Utility ( Scan Once At Next Boot )	sfc /scanonce
System File Checker Utility ( Scan On Every Boot )	sfc /scanboot
System File Checker Utility ( Return to Default Settings)	sfc /revert
System File Checker Utility ( Purge File Cache )	sfc /purgecache
System File Checker Utility ( Set Cache Size to Size x )	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI ( if installed )	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Volume Serial Number for C:	label
Volume Control	sndvol32
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility ( if installed )	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Installer Details	msiexec
Windows Magnifier	magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msnsgs
Windows Picture Import Wizard (Need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Script host settings	wscript
Widnows Update Launches	wupdmgr
Windows Version ( shows your windows version )	winver
Windows XP Tour Wizard	tourstart
Wordpad	write
Zoom Utility	igfxzoom

I hope this proves to be useful for you all.

Animated loader image creator

2010-07-27T14:35:00.000+05:30

Hi all,
I was searching on Google to display some "loader" to show some background activity and at that time I found this.

So if you ever have...

Problem in creating animated loader images?

Not any more, just follow this link and you are done with this...

http://www.ajaxload.info/

I found this while searching on Google for my project and I end up having the images that either don't fit into required size or doesn't match with the color theme of my work... But this has the option to select and define the color of animated loader image as well as the background and images are of various designs and sizes...

Enjoy