Must declare the scalar variable for "roleid"

See more:

C#

ASP.NET

This roleid is calling from the database table having fields RoleID, RoleName, ModifiedBY, ModifiedDate

In which all the fields are calling but getting error in the line RoleID in update statement asp.net project. I will share you the code please help me

What I have tried:

// Getting RowIndex of GridView
//GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
int index = row.RowIndex;
Guid roleId = (Guid)(gvRoleListDispaly.DataKeys[index].Value);

con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
con.Open();

// Command Statement
SqlCommand cmd1 = new SqlCommand("select RoleID from Security_Roles where RoleID=@RoleID", con);

// RoleID
cmd1.Parameters.Add("@RoleID", SqlDbType.UniqueIdentifier);
cmd1.Parameters["@RoleID"].Value = new Guid(roleId.ToString());

sdr = cmd1.ExecuteReader();            

while (sdr.Read())
{
    if (sdr["RoleID"].ToString() == roleId.ToString())
    {
        sdr.Close();
        // Update Command
        using (cmd = new SqlCommand("UPDATE Security_Roles SET RoleName=@RoleName, RoleID=@RoleID, ModifiedBy=@ModifiedBy, ModifiedOn=@ModifiedOn where RoleID=@RoleID", con))
        {
            // RoleName
            cmd.Parameters.Add("@RoleName", SqlDbType.VarChar, 50);
            cmd.Parameters["@RoleName"].Value = roleName;

            // RoleID
            cmd1.Parameters.Add("@RoleID", SqlDbType.UniqueIdentifier);
            cmd1.Parameters["@RoleID"].Value = new Guid(roleId.ToString());

            // ModifiedBy
            // If the value of UserID is Null then ModifiedBy value will be Null
            // Otherwise ModifiedBy field value will be User who creates it.
            string modifiedBy = userID == Guid.Empty ? null : userID.ToString();
            cmd.Parameters.Add("@ModifiedBy", SqlDbType.UniqueIdentifier);
            cmd.Parameters["@ModifiedBy"].Value = new Guid(modifiedBy.ToString());

            // ModifiedOn
            cmd.Parameters.Add("@ModifiedOn", SqlDbType.DateTime);
            cmd.Parameters["@ModifiedOn"].Value = date;

            cmd.ExecuteNonQuery();
        }
    }
}

Getting error at cmd.ExecuteNonQuery();