Sometimes a basic function like MSSQL Format Date Function can not work as you do not have permission to create a function or you simply need something quick. To get day of week from DateTime column and order it by the proper day of week order. This is rather easy to update for those that…
Reference: http://stackoverflow.com/questions/4872364/clearing-all-fields-in-an-asp-net-form
There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows.
Reference: http://stackoverflow.com/questions/2781654/ftpwebrequest-download-file
While this query has more than what may be needed this will help you to get data based on one unique column.
Preferred Method: Project Menu -> Properties -> Application -> Check Box: Make Single Instance Application Non-Preferred Method: This code will look in your task manager for the same name of your application, if it exists it will prevent another copy of it from running.