Datagrid-Date Problem

[A kamath]

In my grid view I want to show only date but it is showing date and time. How can I show Date only

[Mazdak]

Check for DataFormatString property in your Columns.

Mazy
"This chancy chancy chancy world."

[A kamath]

Thank you can you tell me how should I give inside the property column. I had given like this{dd/mmm/yyyy} but it is showing eror(input string is not in correct format).

[Sophia Rekhi]

hi, you can use split function, then it will solve. thanks

[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