date time field show only time 1

[dinster]

Hi all i have access database connected to myp aspx webpage. I used dreamweaver. When i store the time through an aspx form. It saves it in access database table field. I set the field to show short time field.

How ever when i retrieve the record through my aspx form it shows the date and time?

PARAMETER

<Parameter Name="@TimeAdded" Value='<%# IIf((Request.Form("TimeAdded") <> Nothing), Request.Form("TimeAdded"), "") %>' Type="Date" />

textbox

<asp:textbox ID="TimeAdded" Text='<%# DataSet1.FieldValue("TimeAdded", Container) %>' TextMode="SingleLine" Columns="20" runat="server" />

i just want it to show short time i.e 22:54?

many thanks

 

[ca8msm]

Try one of these:

<%# DataSet1.FieldValue("TimeAdded", Container)[!].ToString("hh:mm")[/!] %>

<%# [!]String.Format([/!]DataSet1.FieldValue("TimeAdded", Container)[!], {0:t})[/!] %>

<%# [!]String.Format([/!]DataSet1.FieldValue("TimeAdded", Container)[!], {"hh:mm"})[/!] %>

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ca8msm]

dinster, did this help solve your problem?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]