Useful bit of code, which I’m kinda putting here so I can access it easily. It will display the date created and last modified dates of stored procedures, which can be useful to see when you last made a code change etc! Anyway: SELECT name, create_date, modify_date FROM sys.objects WHERE type = ‘P’ ORDER BY [...]
Just had this problem, but its actually incredibly easy to solve, so thought i’d post an article on here incase anyone else has this problem. It’s quite simple really and there is a couple of examples below for T-SQL and MySQL. I’ve only used the T-SQL one in SQL Server 2005. SELECT TOP X fieldName [...]
I’ve had the site up a while now and it’s slowly getting indexed within Google for various search terms, which is quite interesting to see, and it is a good way to see what people are searching for to appear at the site! Google Web Master Tools is a free tool from Google that collates [...]
After doing lots of changes to a website, it’s always good to test your links (if you have made any) to see if they cause a 404 error due to a simple typo. The W3C Link Checker is an invaluable tool for this, as it will crawl / trawl / spider through a fair few [...]
Following on from the post about Sorting, another important aspect of .NET GridViews is the functionality of paging. Paging is effectively creating different pages for your set of results, so you aren’t bombarded with 500 results on one long page. To turn paging on, set the below property of the GridView to TRUE. <asp:gridview allowpaging=”true”> [...]
GridViews have a handy option called “Sorting”, which can be set to true or false. Unfortunately, this enables the sorting, but in the default classes there is no code to handle the sort event, so unfortunately you had to add it yourself. It’s not quite as simple as you’d like, as you need to handle [...]
Heres a good piece of code which is useful when you are using the FileUpload control to upload files to your web server, but require it to not overwrite the original, but rename it instead by appending a number onto the end. The below code example is in VB.NET for ASP.NET, this could easily be [...]
Recently I’ve been working with Flash and more specifically, clickTag. A rundown of how clickTag works and what it does; clickTag is used as a variable in your, for example, aspx .NET page, which can be handled by the flash file, as long as it is set to accept this variable. Typically this is used [...]
Interesting problem. I required some Ads to show in an email, but unfortunately Outlook is incredibly anal on what it lets the users see (as many of you probably know). The methods I’ve chosen to show the ads is by using Java Script, then if Java Script is turned off, the tags. I need to [...]