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