Changing the datatype of a Column in Sql server

Want to change the datatype of a field from Varchar to integer in T-SQL? The syntax for MS SQL is: ALTER TABLE table ALTER COLUMN column_name new_data_type Ex. ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20)

Exception Details: System.Security.SecurityException: Requested registry access is not allowed in ASP.NET

Exception Details: System.Security.SecurityException: Requested registry access is not allowed in ASP.NET


Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.


Solution - provide Full Trust to the application user account.
It may require you to go through application domain and check the user account under which the application is running may be your registry settings where your applications is searching.

Server.Transfer

Server.Transfer
Expects a virtual path i.e. cross server posting not allowed
Mscorlib.dll error i.e. Thread was being aborted exception when not set
Mscorlib.dll error i.e. Thread was being aborted exception when set to false
Mscorlib.dll error i.e. Thread was being aborted exception when set to true
URL Changes

Urchha also know as Orchha

Urchha also know as Orchha lies on the bank of river Betwa. Urchha is 15 km. from Jhansi in Uttar Pradesh . The town is know for its historic impotance.

Resource File

What is Resource File?

* A resource file is a XML file that contains the strings that we want to

a. Translate into different languages.

b. Can be updated dynamically so that user themselves can modify values in resource files once the application is deployed on the server without re-compiling the entire application itself.

* The resource file contains key / value pairs.
* Each pair is an individual resource.
* Key names are not case sensitive.

An Efficient Method of String Concatenation in C#

An Efficient Method of String Concatenation
A good way to concatenate strings in a loop or when performing multiple concatenations, is to use the StringBuilder class:

String s = "a"
s+="b"; //this is slow

StringBuilder sb = new StringBuilder();
sb.Append("a");
sb.Append("b");

ASP.NET 2.0 and 1.1 diffrences

One of major intoduction of pardifrences is the intoduction of partial classes. Class defination is split into two or more partial clasees, all parts are combined when the application is compiled.

This situation is quite uesful when we are having large team.

However there are certain restrictions to this.