send sql server Timestamp from C#

Question

Hello,

Does someone knows how can I send a Timestamp value from C# to my Sql stored procedure which expect to get a timestamp value?

the sp looks like this

create sp1(@TS Timestamp)

--do do something...

go

Answer 1

MySqlCommand command = new MySqlCommand(); command.CommandText =@"sp1";
command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@TS", MySqlType.TimeStamp, 15).Value = DateTime.Now;