Execute NonQuery..
1.It will not return any data.
2.It is used with insert and update.
3.It returns only the number of rows affected.


Execute Query..
1.Its for command objects.
2.It returns the value given by database through select statement.