Yeah, generally the answer is no, you attach no weight. A dry fly floats, thats its definition. You want no weight!
That said, sight-nymph is correct, it isn't a totally uncommon technique to use dry fly patterns and sink them to represent emergers or drowned adults. And in this case you would use shot.