I want to inactivate a row such that it is not deleted from the table but it is not visible when i click the search button,plz give me the code and query
Before any of us can really help with that, I think we need to know a lot more about how you are accessing your database, how you are searching, and so on. And what version of VB are you using?
Just as a general concept, though, you could "logically delete" a record by setting some flag on it which is skipped in your query. In other words, let us assume you had a Boolean field called
SortOfDeleted. Any SQL query that you build could include
AND [SortOfDeleted] = False. That way, as soon as you set that field to
True, the record will no longer show up in your queries.