Datagrid-Date Problem

[varshavmane]

U can do this in query it self, use this: SELECT Convert(nvarchar(11), Ur Date , 13) AS DateOnly From Table. Hope this helps u....

[Sathesh Sakthivel]

A kamath wrote:

I had given like this{dd/mmm/yyyy} but it is showing eror(input string is not in correct format).

give it as {dd/mm/yyyy} then it will not show Error.

Regards, Satips.

[sra22]

hi, You can set DataFormatString="{0:d}" to your column in datagrid hope it will work

[A kamath]

It is not working

[Sathesh Sakthivel]

Paste your code here we will check it out.

Regards, Satips.

[A kamath]

[Sathesh Sakthivel]

:sigh:

Regards, Satips.

[A kamath]

[Sathesh Sakthivel]

In the BoundField event of the DataGrid, Place you code to convert the format. private void dg_BoundField(object, e) { e.Items[3].Value = ((System.DateTime) e.Items[3]).ToString("dd/MM/yyyy", System.Globalization.DateTimeFormatInfo.InvariantI nfo) } Try with this code this will solve your problem. It will display only date.

Regards, Satips.

[A kamath]

Thanks

[Sathesh Sakthivel]

Welcome.

Regards, Satips.

[Chetan Ranpariya]

Hi, Better you check for the proper formatstring on the google.

Thanks and Regards, Chetan Ranpariya