ExecuteQuery() :
To Execute SELECT Statement
ExecuteNonQuery() :
To Execute Other Than Select Statements (INSERT/UPDATE/DELETE)
ExecuteNonQuery() is one of the most frequently used method in SqlCommand Object and is used for executing statements that do not return result set. ExecuteNonQuery() performs Data Definition tasks as well as Data Manipulation tasks also. The Data Definition tasks like creating Stored Procedures and Views perform by ExecuteNonQuery() . Also Data Manipulation tasks like Insert , Update and Delete perform by ExecuteNonQuery().
difference between as on and as at
What is the difference between Florida and California What is the difference between Florida and California
what's the difference between physician and doctorwhat's the difference between physician and doctor what's the difference between physician and doctor
Difference between paging and what?
difference between enterprise and corporation
difference between enterprise and corporation
The difference between a shogun and a samurai is like the difference between a king and a knight.
just difference
Difference between it and what?
what is the main difference between polyethylene and polyesters what is the main difference between polyethylene and polyesters
The difference between Disneyland and Disneyworld is that Disneyland is in California and Florida is in Disneyworld. This is the difference between Disneyland and Disneyworld.