Want to hide the time from the date field in GridView in ASP.Net with SQL

[Miaaa Mukherjee]

I m using ASP.NET 2005 with VB,C#.
I m using GridView to display the data.

My problem is with the database field date.
I want to use only the date and the fields are manufacturing date and expiry date of some items.
But,in the gridview it displays the time which is by default same for all the entries which 12:00A.M.

I have used date picker for designing.

What should be the validation for showing only the date and not the time ??
How to hide the time from the gridview.
I m using SQL Server 2005 to store database where i have selected the datatype as date/time.

[kenobewan]

If you are using Visual Studio, then you can apply formatting in the properties of the column. HTH.

[sjesurajan]

hi,

Use the following format values to assign only time in the datagridview

DateTime.Now.ToLongTimeString();

I m using ASP.NET 2005 with VB,C#.
I m using GridView to display the data.

My problem is with the database field date.
I want to use only the date and the fields are manufacturing date and expiry date of some items.
But,in the gridview it displays the time which is by default same for all the entries which 12:00A.M.

I have used date picker for designing.

What should be the validation for showing only the date and not the time ??
How to hide the time from the gridview.
I m using SQL Server 2005 to store database where i have selected the datatype as date/time.

[Miaaa Mukherjee]

hi,

Use the following format values to assign only time in the datagridview

DateTime.Now.ToLongTimeString();

Sorry,i don't got it...how can i format ??

And i want to show only the date not time which i coming in my gridview.Which property should be set for that ??

[bhangu]

Sorry,i don't got it...how can i format ??

And i want to show only the date not time which i coming in my gridview.Which property should be set for that ??

just set DataField="DateCreated" SortExpression="DateCreated" ApplyFormatInEditMode="True" DataFormatString="{0:dd/MM/yy}" HtmlEncode="False" />

in your boundfield and it will work fine