Monthly Archives: October 2011

Restoring SQL Database from Remote Computer

You have backed up your database on your remote server into .bak file. You moved the .bak file to your local system and want to restore the database and it does not work! Well here are some of the things … Continue reading

Posted in Uncategorized | Leave a comment

SQL DISTINCT usage

Note: SQL DISTINCT is available only in MS SQL not MySQL Select Distinct * from table removed duplicates rows not duplicate column. DISTINCT works on rows not column. If you join two tables lets say Doctors                                                             Appointment (Patients) doc_id | … Continue reading

Posted in Uncategorized | Leave a comment

Sort template field in gridView

If you add a template field to your gridview, you will find that the default sort function do not work to sort your gridview based on the template field. It is actually rather easier to implement by adding and event, … Continue reading

Posted in Uncategorized | Leave a comment

FindControl in Master Page

Accessing a control  can be a problem in codebehind in ASP.NET. However you will often need to access the control  because you want to change the text property of a textbox or changing certain value. If the control is directly … Continue reading

Posted in Uncategorized | Leave a comment

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.)

This error usually occurs if data is not fetched from the database after the connection was established but some error occured. Usually redoing the task what you were doing before clears this error.

Posted in Uncategorized | Leave a comment