Adding a column to a GridView at Runtime and DataFormatStrin g

[Eamonn]

Hi

I am running Microsoft Visual Studio 2005 Team Edition Version
8.0.50727.42. I am adding columns to a GridView at runtime. When I add
a BoundField that will contain DateTime data I want to format the date
so I use:
BoundField.Data FormatString = <myDateFormat >

However it just displays the date formatting string in the GridView and
not the formatted date. I tried setting the HtmlEncode value for the
column to both true and false, but it makes no difference. A snippet of
my code is below. Any help would be appreciated.

Thanks

Eamonn

//BoundField
case (int)DSSCaseCol umn.DataControl Fields.BoundFie ld:

BoundField boundField = new BoundField();
boundField.Data Field = column.Database FieldName;
boundField.Head erText = column.HeaderTe xt;
SetFieldWidth(b oundField, column.Percenta geColumnWidth);
if (column.IsDate == true)
{
boundField.Html Encode = true;
boundField.Data FormatString =
Constants.GRIDV IEW_DATE_DISPLA Y_FORMAT.ToStri ng();
}
SelectGridViewC ases.Columns.Ad d(boundField);
break;

[PeterKellner]

On 16 May 2006 05:18:31 -0700, "Eamonn" <ea************ @hotmail.com>
wrote:

Hi

I am running Microsoft Visual Studio 2005 Team Edition Version
8.0.50727.42 . I am adding columns to a GridView at runtime. When I add
a BoundField that will contain DateTime data I want to format the date
so I use:
BoundField.Dat aFormatString = <myDateFormat >

However it just displays the date formatting string in the GridView and
not the formatted date. I tried setting the HtmlEncode value for the
column to both true and false, but it makes no difference. A snippet of
my code is below. Any help would be appreciated.

Thanks

Eamonn

//BoundField
case (int)DSSCaseCol umn.DataControl Fields.BoundFie ld:

BoundField boundField = new BoundField();
boundField.Dat aField = column.Database FieldName;
boundField.Hea derText = column.HeaderTe xt;
SetFieldWidth( boundField, column.Percenta geColumnWidth);
if (column.IsDate == true)
{
boundField.Html Encode = true;
boundField.Data FormatString =
Constants.GRID VIEW_DATE_DISPL AY_FORMAT.ToStr ing();
}
SelectGridView Cases.Columns.A dd(boundField);
break;

You want to set:

boundField.Html Encode = false;

(not true)

Peter Kellner
http://peterkellner.net
Peter Kellner
http://peterkellner.net

[Eamonn]

Thanks Peter. I have tried both true and false. Neither has any effect.

[PeterKellner]

On 16 May 2006 09:00:24 -0700, "Eamonn" <ea************ @hotmail.com>
wrote:

Thanks Peter. I have tried both true and false. Neither has any effect.

Very strange. Here is a small example I put together that works as I
describe. Give it a try and see what happens. (BirthDate is of
course a data column in my data object.

public partial class Default5 : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{

}
protected void Button1_Click(o bject sender, EventArgs e)
{
BoundField boundField = new BoundField();
boundField.Data Field = "BirthDate" ;
boundField.Head erText = "BirthDateHeade r";
boundField.Html Encode = false;
boundField.Data FormatString = "{0:d}";
GridView1.Colum ns.Add(boundFie ld);
}
}
Peter Kellner
http://peterkellner.net

[Eamonn]

Hi Peter

Thanks to your example I spotted the issue. I needed to add the curly
braces { and } to the formatting string along with the ordinal
parameter. The following code now works fine:

BoundField boundField = new BoundField();
boundField.Data Field = column.Database FieldName;
boundField.Head erText = column.HeaderTe xt;
SetFieldWidth(b oundField, column.Percenta geColumnWidth);
if (column.IsDate == true)
{
boundField.Html Encode = false;
boundField.Data FormatString = "{0:" +
Constants.GRIDV IEW_DATE_DISPLA Y_FORMAT.ToStri ng() + "}";
}
SelectGridViewC ases.Columns.Ad d(boundField);
break;