StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Phone number format in display member?

Phone number format in display member?

Andria Jensen — Fri, 09 Feb 2007 15:32:22 GMT

I am trying to put a formatted phone number in part of the drop-down's display value, and am having no luck. In the ComboBox's PopulationDataSourceSettings dialog, I can set a display member format string. What would I put in here to make "1234567890" display as "(123) 456-7890"? I know you can use things like {0:c} to display currency or {0:d2} to display a given precision, and so on. I'm just at a loss as to what I can use here to display a phone number. Also, one other thing to consider is international numbers. What if this number is formatted differently for different instances?

RE: Phone number format in display member?

StrataFrame Team — Fri, 09 Feb 2007 15:32:22 GMT

Every control has a DataBindings collection... the first element of which should contain the Binding object that we create and attach to the control. The Binding object itself has a Format event that is raised when the data is being copied into the control. You can handle the Format event and modify the value within the event args and programmatically change the value that is being sent to the control.

You'll also have to bind to the DataBindings.CollectionChanged event so you attach to the Format event of any new binding that is added to the collection. For an example on how to do this, you can check the Infragistics wrapper's UltraDateTimeEditor... I had to handle the Format to get the date to display NULL values properly.

RE: Phone number format in display member?

Andria Jensen — Thu, 08 Feb 2007 13:49:46 GMT

This is actually a DevExpress inherited combo box. Not sure how to do it with this one. I know how you can do this with the grid on the CustomColumnDisplayText, but it's not quite the same with the combo.

RE: Phone number format in display member?

Michael Reese — Thu, 08 Feb 2007 12:27:55 GMT

I believe you can place in the validation event so it would perform the update following entry. By the way, Infragistics has one that will preformat prior to entry and even allow for extensions!

RE: Phone number format in display member?

Andria Jensen — Thu, 08 Feb 2007 11:14:18 GMT

I may be asking a stupid question, but how do you populate a specific part of the display through an event?

RE: Phone number format in display member?

Trent L. Taylor — Thu, 08 Feb 2007 09:28:52 GMT

I would populate that column through an event and then use a RegEx pattern to split the phone number into parts. For example, your pattern and replacement would look something like this:

[codesnippet]Imports System.Text.RegularExpressions

MsgBox(Regex.Replace("1231234567", "(\d{3})(\d{3})(\d{4})", "($1) $2-$3"))[/codesnippet]