Monthly Archives: November 2012

ASP.NET Graphs (Charts)

ASP.NET Graphs called Charts is seperate set of controls available for Visual Studio 2008. They can be downloaded here If an application uses these charts which were developed in Visual Studio 2008, you must install these addon on the PC … Continue reading

Posted in Software Development | Leave a comment

Regular Expresson for SQL keyword with spaces

You drag the column node in SQL Management studio so you have access to individual columns. You delete some field and keep other and want to pull data from the table.The proble is some field name contain spaces such as … Continue reading

Posted in Software Development | Leave a comment

Calling asp.net control from C# constructor

If you try to call an ASP.NET control from the constructor in C# page, you will get a null exception. This is because the control really did not get initialized at this point or the value was not yet assigned … Continue reading

Posted in Software Development | Leave a comment

Optimize your SQL Query using temporary table

If you are using JOIN which considerably slows your query or report, you may create a temporary table inside your stored procedure. Use this temporary table which contains filter data to use in the report. This will make the query … Continue reading

Posted in SQL Server 2008 | Leave a comment

Quran Translation Errors

There are verses in Quran that are translate wrong. Check this verse The translation of this verse is made as Sahih International And if you fear that you will not deal justly with the orphan girls, then marry those that … Continue reading

Posted in Uncategorized | Leave a comment

How to optimize SQL Join for peformance (speed)

I was working on Joining three table which took 3min 4 sec to execute. Unacceptably slow. There was no way I could make it faster because the logic was straight forward. Then I though one of the column that I … Continue reading

Posted in Software Development | Leave a comment

Entity Framework Tutorial

This about link is a great tutorial about Entity Framework. Basically there are a number of ways to access data from the database in an Application. ADO.NET LinQ Entity Framework ADO.NET Allows you to access data directly through SQL Server … Continue reading

Posted in Software Development | Leave a comment