Another great team effort from Pace and Corner Edge

Corner Edge and Pace have teamed up again to produce wellbutrinxl.com. Pace has conceptualized the website that is intended to offer information about the WelbutrinXL product line to patients, physicians and healthcare professionals in the United States. The talented creative group at Pace designed and developed content for the site and provided Corner Edge with artwork, documents and content text. Corner Edge’s development team produced animated Flash features for the home page as well as .NET development for the entire site. Pace is a full-service professional advertising agency located in Parsippany New Jersey. Pace and Corner Edge have collaborated on countless initiatives like web based document management tools, CD/DVD presentations, web  sites, banner advertisements and report engines.

Advertisements

Zovirax, Pace and Corner Edge

Pace, a full-service professional advertising agency located in Parsippany New Jersey has teamed up with Corner Edge Solutions to produce zoviraxhcp.com. Pace has conceptualized the website that is intended to offer information about the Zovirax product line to physicians and healthcare professionals in the United States. The talented group at Pace designed and developed content for the site and provided Corner Edge with artwork, documents and content text. Corner Edge’s development team produced an animated interactive Flash navigation feature for the home page as well as .NET development for the entire site. Pace and Corner Edge have collaborated on countless initiatives like web based software tools, CD/DVD presentations, web  sites and banner advertisements.

iWeb Presentations available for iPad mobile Safari TODAY!

Corner Edge Solutions remains on the cutting edge of technology and application development with the beta release of it’s already successful iWeb Presentations platform. The growing popularity of the iPhone and iPod Touch mobile devices as well as the anticipated business market success of Apples iPad has inspired us to make our products available to a wider audience. While still available in it’s original form as a Adobe Flash based web application with a .NET backend to manage users and track data the new mobile version has been completely redeveloped from the ground up to accommodate the iPad. Corner Edge developers have embraced the Apple development environment and is excited to offer this and many more products and service applications for these ground breaking devices. Corner Edge Solutions is committed to providing the very best service on any platform. Contact Corner Edge today for a iWeb Presentations for iPad demonstration.

Concatenating Multiple Data Fields for the DataTextField Property

Many, many times I’ve had the situation where I want to bind a data-set or data-view to a DropDownList, CheckBoxList, or other ListItem-based control, but I need the display text set through the DataTextField property to use multiple data fields from the result set, and not just the 1 field that it is designed to support.

For example, I might have a user’s name separated into 2 distinct data fields: User_Name_First and User_Name_Last, but I want it displayed in the DropDownMenu as “User_Name_Last, User_Name_First”.

Maybe you can relate.  What are the options?

1.  Modify your database query to merge the fields in the SELECT.  This is likely the most efficient solution, but not always the most practical depending on your environment.

2.  Add a new DataColumn to the result set, enumerate through the results, and set the value of the new DataColumn upon each iteration.  Does the job, but not very efficient or elegant.

How about this… go ahead and add a new DataColumn to the result set, but make it an Expression Column.  Example:

oDataSet.Tables(0).Columns.Add(new DataColumn(“MyNewFieldName”, System.Type.GetType(“System.String”), “CurrentField1 + ‘, ‘ + CurrentField2”)

I finally stumbled upon this solution (as simple as it seems) and it is such a relief!  I feel like a goof since it  never occurred to me until now, but its not the first time, and it certainly won’t be the last.  Many online searches yielded several comments on the first 2 options above, but not much else.  Now that I am on this side of the fence, I find it curious as to why there isn’t much discussion on this technique.  Maybe there is a lot of overhead to it?  Not sure, but certainly seems better than iterating through the result set record-by-record.  Seems like a no-brainer to me.