Loading

Insert either date or time in sql from aspx page

Inżynier Umair

10y873.NET

Hello sir,

my question is i want to update/insert the record into sql database from asp.net c# .Everything working absolutely fine. but now i want to add a coloumn in database so that when a user update its info or a new user insert his record than it will show the time and datetime in sql.also user login & logout time .

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

ali tuncer10y ago
I would keep 2 different columns, CreateDate and ModifyDate..
CreateDate is easy, you can handle it onSQL side, set GetDate() for default value when you create column..
ForModifyDate, you will need to change your update query, you will have to set it like :
Update Products
Set Name = 'Product1', Price=200, ModifyDate= GetDate()
Where ProductId = 34
You could also create a trigger that fires on update to change ModifyDate...