What is Difference between ExecuteNonQuery, ExecuteScalar and ExecuteReader

Question

What is Difference between ExecuteNonQuery, ExecuteScalar and ExecuteReader.

Neha Sharma · Answer

Hi, Refer this link: http://stackoverflow.com/questions/2974154/what-is-the-difference-between-execute-scalar-execute-reader-and-executenonque

Kunal Vaishya · Answer

----------------------- ExecuteNonQuery ----------------------- Use For Command Insert Update Delete and Select Command ----------------------- ExecuteReader ----------------------- Select Command Single and Multiple values "Select * from tablename" And "Select name from tablename" ----------------------- ExecuteScalar. ----------------------- Select Command Single values returns "Select name from tablename"

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 The Command object is represented by two corresponding classes: SqlCommand and OleDbCommand . Command objects are used to execute statements (commands) to a database via a data connection. The Command objects can be used to execute stored procedures on the Database, SQL statements, or return complete tables directly. Command objects provide three methods that are used to execute commands on the database: ExecuteNonQuery. Executes direct SQL commands, such as INSERT, UPDATE or DELETE. ExecuteScalar. Returns a single value from a Database Query. ExecuteReader. Returns a result set by way of a DataReader object. /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:10.0pt;font-family:"Times New Roman","serif";}

What is Difference between ExecuteNonQuery, ExecuteScalar and ExecuteReader

Answers (3)