如何在RoleProvider类中实现AddUsersToRoles方法？

public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
    // 实现逻辑
}

public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
    // 获取数据库连接
    SqlConnection connection = new SqlConnection("your_connection_string");
    SqlCommand command = connection.CreateCommand();

    try
    {
        connection.Open();

        // 遍历每个用户名
        foreach (string username in usernames)
        {
            // 遍历每个角色名
            foreach (string roleName in roleNames)
            {
                // 将用户添加到角色中的逻辑
                // 例如，执行SQL语句将用户和角色的关联信息插入到数据库中
                command.CommandText = "INSERT INTO UserRoles (Username, RoleName) VALUES (@Username, @RoleName)";
                command.Parameters.AddWithValue("@Username", username);
                command.Parameters.AddWithValue("@RoleName", roleName);
                command.ExecuteNonQuery();
            }
        }
    }
    catch (Exception ex)
    {
        // 处理异常
    }
    finally
    {
        connection.Close();
    }
}