Hi all,
I'm trying to implement a 'user manager' where only a supeUser has access too.
Within the below dataGrid, if a user selects delete. An update qry is run but this doesn't have any effect. As you can see I am trying to set active to 1 and isLockedout = 1:
UPDATE aspnet_Membership SET Active = 1, IsLockedOut = 1 WHERE (UserId = @UserId)">
Nothing happens, however if I run this query through visual web developers, Query Builder. I get the results I expect.
I don't want to delete the user for audit trail purposes but I do want to deactivate their access.
I'd really appreciate any advice to what I'm doing wrong here
Here's the gridView:
< ...
Go to the complete details ...