Why do I get ‘HTTP 500’ error (or ‘(DLL) initialization routine failed’) in my browser?
This is because if you have the /3GB boot switch enabled, the ASP.NET worker process (Aspnet_wp.exe) does not start. For more information see Microsoft Knowledge Base Article – 320353 To create and set the ‘ASPNETENABLE3GB’ environment variable as mentioned in the above article, right click MyComputer ->Properties->Advanced > Environment Variables > System variables > New. Add the variable name in the top text box and the value in the lower textbox.
How To Repair ASP.Net IIS Mapping After You Remove and Reinstall IIS?
To reassociate aspx file extensions with ASP.Net runtime, you’ll have to run the utility aspnet_regiis.exe -i For more information refer to Microsoft Knowledge Base Article – 306005
Why did my request hang after I switch to SQLServer mode
(Right answer?) Refer What kind of objects can I store in Session State?
How to use Parameterized queries in ASP.NET
The following sample is a good example of parameterized queries: How to insert data in database using Textboxes?
When I try to enter null value to DateTime field in database it is saved as 1/1/1900 12:00:00 AM
Refer When I try to enter null value for DataTime in Database I get error message ‘String was not recognized as a valid DateTime’ or ‘Value of type ’System.DBNull’ cannot be converted to ’String’’