Planning to Host WordPress Blog

Read this article..

http://www.gchandra.com/scripts/?p=172

Handling multiple configuration settings (Development, Staging, Production) gracefully.

In Asp.net 2.0 multiple connectionStrings & appSettings can be handled very easily using the attribute “configSource”

create a new xml file devAppSettings.config under a new folder myConfigsettings

(continue reading…)

How to Preserve Fileupload value in Asp.net ?

If you form has Fileupload control along with other controls like dropdownlist, calendar.. you will be facing standard problem of Fileupload control losing value when other controls are selected.

Click here to read the article in full…

 

Moved to own domain www.gchandra.com/scripts

I have moved my blog here.. 

 www.gchandra.com/scripts

See you there

Disable .xml file generation when building Asp.Net application

Visual Studio 2005 – Compile Options

.XML files are used to create Documentation.

If you need to disable them, then

Project Properties > Compile and Uncheck Generate XML Documentation file option.

Disable .pdb file generation in Release Mode

Visual Studio 2005 – Compile Options

In Visual Studio 2005, .pdb file gets generated in Debug mode and Release mode.

In debug mode it loads the entire symbol table, in Release mode it loads the key symbols.

In Release mode, the generated .pdb can be deleted very well deleted. (Because framework does not uses it)

To disable .pdb generation in Release mode, goto

Project Properties > Compile Tab > Advanced Compile Options

Goto Generate Debug Info (dropdown list) and select None.

SQL Server 2005 : Access Tables / Entities across Servers.

Accessing objects (tables..) across servers (SQL Server) is very simple.

Step 1: Create a link between two servers

Goto Query Window

EXEC sp_addlinkedserver
   'PRODSVR',
   N'SQL Server'
GO

‘PRODSVR’  is the name of the Server.Execute it.

Step 2: Setup Permission between Servers.In Management StudioGotoServer Object >> Linked Servers >>

PRODSVR (See Image)

Right Click on PRODSVR goto Properties and make changes as given below.

 

Step 3: To access the tables in other server

Use the following  hirearchy

PRODSVR.dbname.dbo.tablename

To access Person.Address table from AdventureWorks database

Select * From PRODSVR.AdventureWorks.Person.Address

Advantages :


1. Update Production server with data from development server. (SSIS is alternate way)


2. Allow users to access production database without multiple logins. (windows authentication or SQL authentication)