Bunch's Blog

One day I'll have a catchy subtitle, one day
posts - 87 , comments - 124 , trackbacks - 0

September 2010 Entries

URL Parameter Cleanup in JavaScript

Using a JavaScript function to show another window from an aspx page is pretty common. Often times you need to pass some variables by appending them to the URL string. And sometimes you don’t know which variables you may or may not need. This example shows one way of passing the variable(s) you need.

Posted On Monday, September 20, 2010 2:20 PM | Comments (1) |

Combining Multiple Values in a Single Field
Here is a simple way to combine values into one field using T-SQL. This method is particularly handy when you don’t know ahead of time how many values will be returned. This simple example would return a student’s name and list of professors (separated by commas). SELECT stu.FullName, (SELECT prof.FullName + ', ' FROM tblProfessors prof INNER JOIN tblStuProf stuprof ON prof.ProfID = stuprof.ProfID WHERE stuprof.StuID = 1234 FOR XML PATH('')) AS Professors from tblStudents stu where stu.StuID = 1234 ......

Posted On Monday, September 20, 2010 10:53 AM | Comments (1) |

Using the AJAX SlideShowExtender with database images

This post goes over how to display images stored in a database using the SlideShowExtender control. The examples use VB.Net (what I have to use at the office) and assumes that you are storing your images in a database, a way to retrieve the images from the database (e.g. stored procedure) and have AJAX setup in your ASP.Net project already. Also the example was based on retrieving images that are photos hence the names of some of the various functions, controls, etc.

Posted On Friday, September 17, 2010 9:51 AM | Comments (7) |

Powered by: