By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,912 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,912 IT Pros & Developers. It's quick & easy.

Using SQL TimeStamps in datagrid

P: n/a
im not too sure how i should be storing the SQL2000 timestamps

basically i return a dataset which is used to populate an editable grid.
this dataset contains the timestamp. how should i be storing the timestamps
for each grid row? is it possible to hold them in the grid in someway? or do
i need to look at other means

ive only used Oracle Timestamps before and they where just decimal
timestamps which made it easy!! could just store them in the grid in a
hidden column.

any help would be greatly appreciated

Cheers,
Craig
Nov 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You could use a boundcolumn and change its visiblity to false through
the Visible property. However, why do you really need to store it as a
hidden value?

----
- Wilco Bauwer
Blog & Custom Controls @ http://wilcoding.xs4all.nl

Nov 19 '05 #2

P: n/a
i need to hold/use it for concurrency.

if i do hold it in a boundcolumn then how do i get it out? my other columns
are template columns and i can just find the values using
CType(e.Item.FindControl("lblAttendanceHeaderID"), Label).Text

"Wilco Bauwer" <wi****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
You could use a boundcolumn and change its visiblity to false through
the Visible property. However, why do you really need to store it as a
hidden value?

----
- Wilco Bauwer
Blog & Custom Controls @ http://wilcoding.xs4all.nl

Nov 19 '05 #3

P: n/a
Almost the same thing. Just inspect what's inside e.Item.Cells. There
should be a cell which either directly contains the datetime value, or
a literal or something which holds it.

----
- Wilco Bauwer
Blog & Custom Controls @ http://wilcoding.xs4all.nl

Nov 19 '05 #4

P: n/a
sqlserver timestamps are binary data (actually a bigendin 8 byte integer).
load it into a byte array, which you can base64 encode and store in a
hidden field.

-- bruce (sqlwork.com)

"Craig G" <craig.gamble@y_arrasoftware.com> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...
| im not too sure how i should be storing the SQL2000 timestamps
|
| basically i return a dataset which is used to populate an editable grid.
| this dataset contains the timestamp. how should i be storing the
timestamps
| for each grid row? is it possible to hold them in the grid in someway? or
do
| i need to look at other means
|
| ive only used Oracle Timestamps before and they where just decimal
| timestamps which made it easy!! could just store them in the grid in a
| hidden column.
|
| any help would be greatly appreciated
|
| Cheers,
| Craig
|
|
Nov 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.