Multiple choice technology web technology

Syntax for creating a SqlDataReader Object

  1. SqlDataReader rdr = cmd.ExecuteReader();

  2. SqlDataReader rdr = ExecuteReader();

  3. SqlDataReader rdr = cmd.Execute();

  4. SqlDataReader rdr = cmd.ExecuteScalar();
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SqlDataReader is created by calling ExecuteReader() on a SqlCommand object. Option A correctly shows this pattern with cmd.ExecuteReader(). Options B, C, and D are incorrect: B omits the command object, C uses Execute() which returns a boolean, D uses ExecuteScalar() which returns a single value, not a reader.

Keep practicing — related questions