maintaining old data

[sheemap]

hiiiiiiii to all how we can maintain old data in gridgiew after updating the the particular....... any one can tell. Thanks in advance

rizvan sivally

[uspatel]

I Used Update Command as for this

Update tblJobs set [Status]=Status+ ' * ' + @Status +' ' +Cast(getdate() as varchar(50))+'
',Remarks=Remarks+ ' * ' + @Remarks + ''+Cast(getdate() as varchar(50))+ '
'where Id=@Id"

see Remarks=Remarks+ ' * ' + @Remarks this update Remarks Column and your previous data remains same.