C# timestamp datatype

[Mehraj]

HI,

I want to know if there is any datatype in C# that allows return of timestamp? I'm accessing stored proc that expects a timestamp input parameter. Can anyone help me with this?

[opaper]

Can you be more specific with your question? Have you tried the plain DateTime data type?

[aftab1]

A timestamp as in SQL timestamp? For your knowledge "timestamp" is the same as varbinary(8), just except for the automatic update behavior.

The timestamp in SQL Server maps to a Byte[] type in .NET framework. byte[] - i.e. an array of bytes. It is not used as DateTime. If you just need to store date/time information, try to use datetime data type, it maps to a DateTime object in .NET framework. The SQL TimeStamp is fully based on insert / update order on your sql server.

[Raiz]

Refer to following links , see if they helps you:

http://msdn.microsoft.com/en-us/library/ms182776.aspx
http://msdn.microsoft.com/en-us/libr...8VS.71%29.aspx

Hope this will hep.