when should we use "executenonquery"

[bnathvbdotnet]

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

[Edneeis]

Generally its on UPDATE, INSERT, or DELETE queries.

[VBCrazyCoder]

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.