I think thats less to do with the line and more to do with the person saying it and HOW they say it. Without some sort of charisma or 'delivery' if its a jokey line, youll get nowhere - a place Im familiar with
I dont think Ive ever used a 'line' in my life - 'Would you like a dance?' always worked but thats a question rather than a line and getting a 'No' is no big deal and can of course lead to a conversation. Of course this was when i didn't know what a partner dance looked like

,
Id be more interested in hearing the worst attempts ever

.