when should we use "executenonquery"

which is the right scenario when i should be using "Executenonquery"?
I am aware of the fact that it will not not return any records but only number of records affected.

thanks
nath

Generally its on UPDATE, INSERT, or DELETE queries.

Yes, when you don't care about what the Procedure does except maybe the # rows affected (like E said, usually on Insert, Update, Del). Quite useful.