Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SelectCommand="SELECT [PKEY], [user] FROM [userlist]
- WHERE LogonName IN (
- SELECT [user]
- FROM [userlist]
- GROUP BY [user]
- HAVING (COUNT([user]) > 1))"
- DeleteCommand="DELETE FROM [userlist] WHERE [PKEY] = @PKEY" >
- if (checkbox.Checked)
- {
- int PKEY = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
- SqlDataSource1.DeleteParameters["PKEY"].DefaultValue = PKEY.ToString();
- SqlDataSource1.Delete();
- }
- SELECT DISTINCT ...
- DELETE FROM [userlist]
- WHERE PKEY NOT IN (
- SELECT MAX(PKEY) pkey
- FROM [userlist]
- GROUP BY [user]
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement