Multiple choice technology web technology

Which command does not return any value?

  1. ExecuteDataSet()

  2. ExecuteScalar()

  3. ExecuteReader()

  4. ExecuteNonQuery()
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ExecuteNonQuery is specifically designed for SQL commands that don't return row data - INSERT, UPDATE, DELETE, DDL statements. It returns only the count of affected rows. ExecuteReader returns rows, ExecuteScalar returns a single value, ExecuteDataSet returns a DataSet.

Keep practicing — related questions