Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. SelectCommand="SELECT [PKEY], [user] FROM [userlist]
  2. WHERE LogonName IN (
  3. SELECT [user]
  4. FROM [userlist]
  5. GROUP BY [user]
  6. HAVING (COUNT([user]) > 1))"
  7. DeleteCommand="DELETE FROM [userlist] WHERE [PKEY] = @PKEY" >
  8.  
  9. if (checkbox.Checked)
  10. {
  11. int PKEY = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
  12. SqlDataSource1.DeleteParameters["PKEY"].DefaultValue = PKEY.ToString();
  13. SqlDataSource1.Delete();
  14. }
  15.  
  16. SELECT DISTINCT ...
  17.  
  18. DELETE FROM [userlist]
  19. WHERE PKEY NOT IN (
  20. SELECT MAX(PKEY) pkey
  21. FROM [userlist]
  22. GROUP BY [user]
  23. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement