How Can I Show Just Date In A BoundColumn (Date Format In SQL Server 2008 Not DateTime) In My Grid

[Majid Darab]

hi my dear friends :
i have a grid with some boundColumn in it...
One Of My BoundColumn IS in Date Format In sql server 2008 (Not DateTime) and i want my rad grid show just date (without time) In this column Like In sql server 2008...
how can i do this ?
we just have system.datetime for this column not system.date or somethin like this ...

[Shinu]

Hello Majid,

Set the DataFormatstring property of the GridBoundColumn as shown below in order to show Date part only.

ASPX:

<telerik:GridBoundColumn DataField="DOB" DataFormatString="{0:d}" HeaderText="DOB BoundColumn" SortExpression="DOB" UniqueName="DOB"
    DataType="System.DateTime">
</telerik:GridBoundColumn>

-Shinu.

[Majid Darab]

really appreciate it