In this example I will show how to use C# in a WebForm to read out a series of pictures from a database table, resize the pictures to a standardized width, and then to save each image as a JPEG to a folder on your local file system. The code assumes that the pictures are coming from your database as JPEG format images, but you can easily adjust the code to dynamically save each image by its type if you have this data stored in your database. (more…)
Justin Cooney
Web Development Tips and Examples
-
SQL Server 2000 is an old database platform now, but it is still fairly widely used. That’s why it’s good to know how to pass a list of parameters to a stored procedure on the SQL Server 2000 database platform. Likewise, the code is forwards compatible and will work with more modern versions of SQL Server such as 2008.
Have a look here if you are looking for a working example of passing XML to a stored procedure using SQL Server 2008. (more…)
-
Find Duplicates in Excel There are some great ways to hunt down duplicate values in the desktop version of MS Excel. Today I will take a look at using the free online SkyDrive version of Excel that is integrated with Outlook.com to find duplicates between two columns. (more…)
Justin Cooney 