Script(s)

what I learn is what u c

Planning to Host WordPress Blog

leave a comment »

Written by gchandra

December 5, 2008 at 12:04 am

Posted in Web Coding

Tagged with ,

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

leave a comment »

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…)

Written by gchandra

May 1, 2008 at 8:52 pm

Posted in Asp.Net, Web Coding

Tagged with

How to Preserve Fileupload value in Asp.net ?

leave a comment »

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…

 

Written by gchandra

May 1, 2008 at 7:35 pm

Moved to own domain www.gchandra.com/scripts

leave a comment »

I have moved my blog here.. 

 www.gchandra.com/scripts

See you there

Written by gchandra

March 1, 2008 at 1:32 am

Posted in Web Coding

Disable .xml file generation when building Asp.Net application

leave a comment »

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.

Compile Options

Written by gchandra

February 22, 2008 at 9:19 pm

Posted in Web Coding

Tagged with , , , ,

Disable .pdb file generation in Release Mode

with 3 comments

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

Compile Options

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

No PDB

Written by gchandra

February 22, 2008 at 9:15 pm

SQL Server 2005 : Access Tables / Entities across Servers.

leave a comment »

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)

Linked Servers List

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

1-general.jpg

2-security.jpg

 3-securityoptions.jpg

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) 



kick it on DotNetKicks.com

Written by gchandra

February 18, 2008 at 3:31 pm

Follow

Get every new post delivered to your Inbox.