Using a DateTime as a DataKeyField

[Keith Patrick]

I have a DataGrid that uses a DateTime coming back from the DB as its
DataKeyField, since that timestamp is the only unique ID I have for the
records I am displaying. The problem is that the DateTime is being stored
down to the second rather than to the millisecond, which ruins the ID. Is
there some way to tell the grid to store that DateTime with millisecond
precision, or at least store the tick count?

 

[Ken Cox [Microsoft MVP]]

Hi Keith,

Are the milliseconds available in the DateTime? If so you might need to
bind to a custom datetime string to get at them.

I'm thinking of something like this:

<columns>
<asp:templatecolumn>
<itemtemplate>
<asp:label id="Label1" runat="server" text='<%#
format(DataBinder.Eval(Container.DataItem, "DateTime"),"yyyyMMdd:HHmmss%ff")
%>'></asp:label>
</itemtemplate>
</asp:templatecolumn>
</columns>

The ff stuff is discussed here:

http://msdn.microsoft.com/library/d...uide/html/cpconcustomnumericformatstrings.asp

Ken