从网格的基础上删除行.

问题描述

我正在使用delete sql查询从数据库中删除特定用户的角色.但是问题是，如果用户具有多个角色.而不是从数据库中删除特定用户的所有角色.我可以基于选择删除行吗?
我应该用什么方法做到这一点.

i am using delete sql query to delete role of a particular user form the database.. but the problem is that.. if user has more than one role. than its erasing all the role of a particular user from the database. can i delete row on selection bases?
what approach i should use to do that.. ??

protected void _rowdeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
        Label lbldeletename = (Label)row.FindControl("lblusername");

        MAconn.Open();
        SqlCommand cmd = new SqlCommand("DELETE FROM Roles WHERE UserId = (SELECT u.UserId FROM Users u WHERE u.UserName = @UserName", MAconn);
        cmd.Parameters.AddWithValue("@UserName", lbldeletename.Text);
        cmd.ExecuteNonQuery();
        MAconn.Close();
        bind();

    }

推荐答案

SqlCommand cmd = new SqlCommand("DELETE FROM Roles WHERE RoleId =@RoleId AND UserId = (SELECT u.UserId FROM Users u WHERE u.UserName = @UserName", MAconn);

这篇关于从网格的基础上删除行.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！