how to get updated record from database to c# application

Question

Hi I am developing c# application with sql notification and sqldependency. if particular record is updated in database table in sql serverI want to get that record details in c# application but now i am getting all records popup if one record is updated Please help me . Thanks and regards N.Ramachandran

Venkatesan Kalingaraju · Answer

try sqlDataadapter with update method. it will return a single row affected value

Bikesh Srivastava · Answer

Hi Actually in that case you need to add one more column in table modifieddate and save updated date time and get data from table according date sorting..

Dilip Gupta · Answer

Use After Update trigger in Stored Procedure

Kranthi Vardhan Kolluru · Answer

put an additional field to the table 'Status' if data Inserted status '0' if update status '1'. then get the record of that perticular status '1' into C# (frontend or do your action i.e. display caluclate etc.. ) when your action complete then set record status to '0'