Author: callan1 | Posted on: 9/11/2009 1:24:52 AM | Views : 1107

 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 ...