Er. alokpandey's Blog

My new blog…

Posted in Uncategorized by Alok Kumar Pandey on June 13, 2014

My new blog

Dear All,

Please visit my new blog, for the new posts please visit www.alokpandey.com.np

One day workshop on SageFrame

Posted in ASP.NET (C# & VB) by Alok Kumar Pandey on February 16, 2013

Second AspNetCommnunity Meet Up

Posted in ASP.NET (C# & VB) by Alok Kumar Pandey on November 22, 2012

Dear All,

We are pleased to announce that second AspNetCommunity meet up, where we will bring together IT professionals (.NET developers and others) & 3rd parties like business personnel who use .NET based products, for interaction and sharing innovative ideas to grow community. In this meet up we will not only be about sharing your ideas – we will also provide opportunities for you to interact with and have our questions answered by the very people who work on .NET technologies day-in
and day-out, and who can help us plan the features and architecture to support your business goals too.

Please make your valuable presence at the event and share your ideas with us. You can find the event details as under:

Date: 24th November, 2012
Day : Saturday
Time: 2 PM onwards
Venue: Community Hall – BrainDigit IT Solutions Pvt Ltd, Gyaneswor

AspNetCommunity members who have registered online will be sent invitation newsletters via emails. For more queries you can contact our community.

Please don’t forget to send us confirmation email if you are attending the event.

Contact Email: event@aspnetcommunity.org

AspxCommerce 1.1

Posted in ASP.NET (C# & VB), HTML and XHTML by Alok Kumar Pandey on June 5, 2012

AspxCommerce 1.1

AspxCommerce is an Asp.Net  based complete open source e-Commerce solution built on top of SageFrame, which enables you to maximize the success of your online business. AspxCommerce is a complete package for both new or existing merchants who need to design, configure, customize, manage and open their online storefronts.

For new features just Click On

To Download Just Click On

For New Free Templates

http://fashionhouse.aspxcommerce.com/

http://electronics.aspxcommerce.com/

http://flowershop.aspxcommerce.com/

http://jewellerystore.aspxcommerce.com/

http://mobilestore.aspxcommerce.com/

 

Get Started SageFrame

Posted in ASP.NET (C# & VB), C#, HTML and XHTML, J-Query by Alok Kumar Pandey on April 25, 2012

On using SageFrame for your web development, you can, not only gain benefits of a CMS that is easy to use, but also an ability to create your own custom applications. Similarly, you can use applications and modules developed by other users. SageFrame’s plug and play modular architecture enables you to plug a desired module into your system and acquire the required feature instantly.

More

Explore awesome features with SageFrame 2.0

Posted in Uncategorized by Alok Kumar Pandey on April 3, 2012

SageFrame strives to give you the best CMS experience in the web. We hope you had an awesome experience with SageFrame 1.0, but with SageFrame 2.0 we promise you even more – enhanced features, flexibility, ease of use and lots more. SageFrame 2.0 is stunningly awesome – explore more.

Features
• Easy single click installation
• Dynamic content management
• Robust site security
• Plug and play modules
• Inline editing support
• Inbuilt module packaging and publishing support
• Localization Support
• Multi-portal Support

SageFrame 2.0 available to use
http://sageframe.com/
For demo just visit
http://demo.sageframe.com/
For Downloads
http://sageframe.codeplex.com/

Tagged with:

How to choose and set up payment options in AspxCommerce

Posted in ASP.NET (C# & VB) by Alok Kumar Pandey on February 2, 2012

How to choose and set up payment options in AspxCommerce .Net eCommerce software

Difference between Function (UDF) and Stored Procedure on MSSQL

Posted in ASP.NET (C# & VB), MSSQL by Alok Kumar Pandey on January 21, 2012

Difference between Function (UDF) and Stored Procedure on MSSQL

Functions

1- Can be used with Select statement
2- Not returning output parameter but returns Table variables
3- You can join UDF
4- Can not be used to change server configuration
5- Can not be used with XML FOR clause
6- Can not have transaction within function
7- Can be used in Select list
8- Versioning (grouped) Not Allowed
9- Schema Binding Allowed
10- GETDATE() or other non-deterministic functions Not Allowed
11- SET OPTION Allowed
12- Temp Object Not supported

Stored Procedure

1- Have to use EXEC or EXECUTE
2- Return output parameter
3- Can create table but won’t return Table Variables but possible in MSSQL 2008/2008 R2
4- You can not join SP
5- Can be used to change server configuration
6- Can be used with XML FOR Clause
7- Can have transaction within SP
8- You can not use in SELECT list
9- Compiled, can remember execution plan
10- Schema Binding Not Allowed
11- GETDATE() or other non-deterministic functions Allowed
12- SET OPTION Not Allowed
13- Temp Object Accessible – You can use the temp tables inside the procedure

Reference

Social.msdn.microsoft.com

How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2

Posted in ASP.NET (C# & VB), C#, MSSQL by Alok Kumar Pandey on January 21, 2012

How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2

Script

DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
SELECT @SQL = ‘DROP PROCEDURE [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Procedure: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP VIEW [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped View: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP FUNCTION [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Function: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)

WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[‘ + RTRIM(@name) +’] DROP CONSTRAINT [‘ + RTRIM(@constraint) +’]’
EXEC (@SQL)
PRINT ‘Dropped FK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)
END
GO

/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)

WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[‘ + RTRIM(@name) +’] DROP CONSTRAINT [‘ + RTRIM(@constraint)+’]’
EXEC (@SQL)
PRINT ‘Dropped PK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)
END
GO

/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP TABLE [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Table: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

Reference

http://stackoverflow.com

The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5

Posted in ASP.NET (C# & VB) by Alok Kumar Pandey on January 21, 2012

The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5

You are trying to jump start an existing ASP.NET site on a new IIS 7.5 server under Windows 7/7.5 or under Windows 2008 R2, and you are getting this error message: The problem is in IIS 7.5 DefaultAppPool settings.

Windows 2008 Server with IIS 7.0/7.5 runs DefaultAppPool using Network Service user:

Windows 7.0/7.5 and Windows 2008 Server R2 with IIS 7.5 run the same pool under a different user – ApplicationPoolIdentity:

All you need to do is to change that setting on your machine.

Use IIS Admin – Application Pools.
1- Right mouse click on DefaultAppPool row,
2- Select Advanced Settings,
3- A first setting under Process Model group is Identity,
4- Select it and using a drop down list change Built-in account from ApplicationPoolIdentity to NetworkService.

Now check your application log in, it will work

Hope this will work

Follow

Get every new post delivered to your Inbox.

Join 206 other followers