Hi Kasunmit,
shouldn't the code look more like:
string qu = "select NAME from dbinfo where status <> 'DROPED' order by NAME";
The relational operator for not equal to is "<>", that's how I'd use it.
And if status is a character bases field single quotes around the string literal are in order.
Hope that helps
Cheers
Manfred