displaying a date w/o the time trail

[vstud]

Hi,

I'm using the datagrid view to display transactions. (asp .net 2.0),
one of the bound fields is DateTime type, when displayed on the grid view it shows the full field with it's time stamp i.e. 3/3/2008 12:00:00 AM.

my question is how can i strip it down and only show the date part it on the grid.

hope it make sense.

TIA

[dip_developer]

if you are fetching date from database write a query like

select convert(varchar,dateColumnName,101) from tablename

or you can convert the date to short date string like...

Convert.ToDateTime(yourDateVAlue).ToShortDateStrin g()

this will display only the date

[vstud]

thanks for the reply.

I'm not sure when it's not working for me when i use it inside the asp page.
I'm getting an error on the convert or what ever function. for example:

<asp:AccessDataSource ID="AccessDataSourceID" runat="server" DataFile="c:\asp\trx_DB.mdb"

OnSelecting="AccessDataSourceID_Selecting" SelectCommand="SELECT web_trx.order_number, web_trx.order_date, DateValue( web_trx.trx_date), activation_codes.id_code, activation_codes.activation_code FROM (web_trx INNER JOIN activation_codes ON web_trx.activation_code_id = activation_codes.id_code) WHERE (web_trx.order_date BETWEEN ? AND ?) ORDER BY web_trx.order_date">

<SelectParameters>

<asp:FormParameter DefaultValue="01/01/2005" FormField="txtFromDate" Name="Fromdate"

Type="DateTime" Size="30" />

<asp:FormParameter DefaultValue="01/01/2009" FormField="txtToDate" Name="Todate"

Type="DateTime" Size="30" />

</SelectParameters>

</asp:AccessDataSource>


the code snip will return an error, however if i take the function part out, aka,
DateValue( web_trx.trx_date) all is fine.

any idea why? Do i need to write a c# or Vb seperate function to handle it..?

TIA

[CyberSoftHari]

above solution by dip_developer will need c# or Vb seperate function and also refer Problem converting a string into date in vb.net