Most of the time, we, developers, creates temp tables in our stored procedures in order to store temporary data. We, sometimes, encounter an issue when we run that stored procedure, we got exception that #temp table already exists and user doesn't get what he wants.

After doing some RnD, i found a solution which really helped me a lot. Please use below TSQL statement(MS SQL SERVER) before you create any temp table.

if object_id('tempdb..#TableName) is not null drop table #TableName

then create your #TableName.

It will definitly help out alot in getting rid of displayed exception.

Cannot use a leading .. to exit

Last week, When we moved our application from staging site to production site, we were encountered an interesting exception.


Cannot use a leading .. to exit above the top directory.


Screenshot is attached herewith.





Please note that we are using Master pages in our application and we had included javascripts and CSS files in this master page. After googling through different forums, I found that ../javascript/a.js was causing this error.



Actually, in our staging site, it worked perfectly because ../ was finding parent directory but when that master page moved in parent directory, it didn't had 1 futher parent/top directory. We solved this exception using ~/ sign instead of ../

Hotmail passwords leaked online

for more details, check it out Hotmail passwords leaked online

http://windowslivewire.spaces.live.com/blog/cns!2F7EB29B42641D59!41528.entry?wa=wsignin1.0&sa=363915619

Silverlight 3 Released

Silverlight 3 and associated developer tools have been released. Visit the Get Started page to download all you need to build great Web experiences with Silverlight 3. You can also learn more by watching the new videos, reviewing the QuickStarts, and reading some success stories and what's new in Silverlight 3.

Cross Browser Findings

Here are my recent findings that I want to share with all of you:

1:- if there is nested table in a tag and you want to assign ID to this to make it dynamic HTML control, then I will recommend you to assign ID to table and make it HTML control.

Similarly, if you want to make tag as dynamic HTML control, then I will recommend you to make as HTML control instead of .

Happy coding.

IIS Search Engine Optimization (SEO) Toolkit

The IIS Search Engine Optimization (SEO) Toolkit helps Web developers, hosting providers, and server administrators improve their sites' relevance in search results by recommending how to make them more search engine-friendly. The IIS SEO Toolkit Beta can be installed with the Microsoft Web Platform Installer 2.0 Beta for use with IIS 7.0 and IIS 7.5. For details, visit IIS site

White box Unit testing: Pex - Automated White box Testing for .NET

Developers, If you are interested in doing white box unit testing of your code, than Microsoft has released PEX for you. For more details and tutorials, please visit PEX.

Custom Error handlings

Today, I visited Microsoft's site to view/verify my MCP credentials, which could be acceessed from https://mcp.microsoft.com/authenticate/validatemcp.aspx, when i provided my transcriptID and access code, it exposed error screen which is a bad practice. 

If it is bad practice than what is best practice/solution to avoid this yellow screen. I laughed as Microsoft itself gave solution in ASP.NET to avoid this error screen but didn't use itself. In order to avoid this screen, open your application's web.config file, there is a section named as . By default, it's mode value is "Off" which means that if your application encouter an error, it should display error details to user but safe practice is

Australian IT Salary Survey - How much could you earn in 2009

If your interested to move/immigrate to Australia and before doing it, you want to know what could be your possible salary, than here is link for you

Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'

Today, my team member got new machine where he has only VS 2008 with .Net Framework 3.5 along with all necessary softwares on his machine. We recently have moved our applicatio from .Net framework 2.0 to .Net Framework 3.5, which was, by default, supporting crystal reports 10.2.  By default, .Net framework 3.5 supports 10.5 version but we still using Crystal Reports 10.2 vesion. When he compiled project on his machine, he got following configuration error. 

Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Solution

In order to fix this problem, I recommended him to install crystal reports runtime CRRedist2005_x86.msi  which could be downloaded after googling it otherwise if any of your computer has VS 2005, you can find it at following path.

root\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86.msi