formatting a date inside a datacolumn - please urgent

{D} or {d} should be in the Data Formatting expression. It can be added for a bound column in the property builder. which in HTML looks like
<asp:BoundColumn DataFormatString="{D}"></asp:BoundColumn>

Otherwise it can be done in the Item Data Bound event of the datagrid

Hi There,

What would the syntax be?

c.Controls.Add(New LiteralControl(dataR(dataC.ColumnName)))

Hi bullrout,

have you tried
DateTime.ToString("d")
see here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclasstostringtopic1.asp
Regards!
B..M
mmarinov

Hi Bullrout,
             I dont know how to add a DataColumn at runtime as you have done.

Check if there is an attribute called DataFormatString for DataC.

Regards,
Suraj

Hi
 In grid properties on your column you there is a field Named
DataFormatString and you can make your format as follow :
{0:dd/MM/yyyy HH:mm}
be carefull  mm = minutes and MM = month

Oops surajguptha  I didnt notice that u mentioned DataFormatString in ur reply , sorry.

Regards

If I assume dataC.ColumnName returns the date, then

c.Controls.Add(New LiteralControl(dataR(dataC.ColumnName.ToString("d")))

Hi There,

I tried the code above "c.Controls.Add(New LiteralControl(dataR(dataC.ColumnName.ToString("d")))" with no luck. The database table is a datetime datatype, do I need to explcitly declare the column inside the datatable as this datatype too?

Sean

 dt.Columns.Add("wipdue")

sorry I guess I put the parenthesis in the wrong place. try with the following one more time
c.Controls.Add(New LiteralControl(dataR(dataC.ColumnName)).ToString("d")));

Hi There,

I get the error, public overridable function() as string has no parameters and it's reutrn type cannot be indexed.

Help!

Hmm how about this
c.Controls.Add(New LiteralControl(CType(DateTime, dataR(dataC.ColumnName)).ToString("d")));

still no joy, it complains about not using the datetime as an expression, and the ctype clause make the program not recognise the datacoloumn.

i think ryerras makes a little mistake
try this

c.Controls.Add(New LiteralControl(CType(dataR(dataC.ColumnName), DateTime).ToString("d")));

B..M

Hi All,

The code changes seemed to have got rid of the error but the format of the date does not change.

if I use this c.Controls.Add(New LiteralControl(CType(dataR(dataC.ColumnName), DateTime).ToString("d")));

I still get this:

03/07/2004 12:00:00 AM

if I use this c.Controls.Add(New LiteralControl(Format(Cdate(dataR(dataC.ColumnName)), "dd.MM.yyyy")))

I still get this:

03/07/2004 12:00:00 AM

Any idea why the formatting is not taking effect?

what do you want the date format should be

Hi there,

I just want the date format to be (03/07/2004).

I have tried this and with not luck, it does not make a difference to the format at all.

do one thing, try with different formats like ToString("C") , ToString("F") and ToString("R") , see if the result is the same. Then there must be something wrong somewhere else, not when you are adding the control. Let us know if you are getting the same result

sorry ryerras, my mistake :)

It's working well now, I appreciate the help.

Sean

cool. thats great to hear