Oct 23
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
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