update date and time in asp.net

[Ahamed Azeem]

Hi guys, I want to display date and time if I update my website in server(if i insert/update a row in particualar tables) . How to do it in asp.net with sql server database

Ahamed Azeem software Programmer

[raju melveetilpurayil]

Ahamed Azeem wrote:

I want to display date and time if I update my website in server(if i insert/update a row in particualar tables) . How to do it in asp.net with sql server database

better to create a Log table. and display last update from Log Table.

[David Mujica]

If you add a "Modifydate" column to your table, then each time you update a row in the table, set the ModifyDate to the CurrentDate-Time. You can then issue a select max(ModifyDate) on that table to display the latest update date on your web page.

[Rajendra Prasad Panchati]

Hi Ahamed Azeem, Please follow the below db statement. SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'Your DB Name') AND OBJECT_ID=OBJECT_ID('Your Table Name'). It'll show you last modified DateTime for a particular table in a particular DB. U can remove where condition to view all the records from all the DB tables. I think u understand it:thumbsup:..

Rajendra Prasad panchati .Net/Sharepoint Software Engineer. Hyderabad.