Oct 23

Internet Explorer file uploads with ASP.NET

By Marc
No Comments
Programming, Rant, Snippet, Web Design

Popularity: 62%

So you’d think that uploading a file using the standard FileUpload control would be easy. Well there is a small problem. Using the following code you would expect ‘filename’ to contain just the filename of the file uploaded.

String filename;
filename = FileUpload1.PostedFile.FileName;

Read more

Oct 11

Paging in MS SQL 2005

By Marc
No Comments
Programming, Snippet

Popularity: 59%

Paging results from an SQL query can sometimes be quite difficult. MySQL has for a long time supported ‘LIMIT x,y’ to aid this, however with Microsoft SQL it has always been a bit more difficult. With MS SQL 2005 thing are a little easier. Try the snippet below, based on the AdventureWorks sample database included with SQL 2005.
Read more