format data for a column

Thread ID:	Created:	Updated:	Platform:	Replies:
11442	Mar 5,2004 03:46 PM UTC	Mar 5,2004 04:03 PM UTC	WinForms	1

Subscribe to this post

Tags: GridControl

keith

Asked On March 5, 2004 03:46 PM UTC

I want to disply data with a format for a column in a GridDataBoundGrid control. e.g. Telepone or SSN. (206) 123-4567 or 123-45-6789. But these data are in foramt 1234567 or 123456789 in dataset. Can I use a mask on a column to format it? Thanks

Reply | Reply with quote

Administrator [Syncfusion]

Replied On March 5, 2004 04:03 PM UTC

Yes, you shoul dbe able to do this. The excludeliterals setting is what allows teh raw data not to have teh formatting characters.


Dim style3 as GridStyleInfo = Me.Grid.GridBoundColumns("PhoneNumber").StyleInfo
	style3.CellType = "MaskEdit"
        maskedEditStyle3.AllowPrompt = False
        maskedEditStyle3.ClipMode = Syncfusion.Windows.Forms.Tools.ClipModes.ExcludeLiterals
        style3.CultureInfo = New System.Globalization.CultureInfo("en-US")
        maskedEditStyle3.DateSeparator = "-"c
        maskedEditStyle3.Mask = "(999) 999 - 9999"
        style3.MaxLength = 16
        maskedEditStyle3.SpecialCultureValue = Syncfusion.Windows.Forms.Tools.SpecialCultureValues.None
        style3.Text = "(___) ___ - ____"
        maskedEditStyle3.UseLocaleDefault = False
        maskedEditStyle3.UseUserOverride = True

The first may need to be


Dim style3 as GridStyleInfo = Me.Grid.Binder.InternalColumns("PhoneNumber").StyleInfo

if you have not explicitly added GridBoundColumns.

Reply | Reply with quote

CONTACT US

format data for a column

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US