Which is the best method to get the single value from Database?

Posted by Lakhangarg on 8/25/2009 | Category: Sql Server Interview questions | Views: 20605

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Select from following answers:

ExecuteDataSet()
ExecuteScalar()
ExecuteReader()
ExecuteNonQuery() With Output parameters
All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Unique Key is smilar to Priamary Key,except it

Next > : Which method is used to Get a value indicating whe ...

Comments or Responses

Posted by: Raja on: 8/25/2009

Either the question or the answer is wrong.

The question is "Which is the best method to get the single record from Database?"

ExecuteScalar() method of ADO.NET Command eg. SqlCommand object is used to get the first row and first column data from the SELECT statement.

It doesn't give the single record, but it gives the single value.

Please correct the question.

Thanks

More Interview Questions by Lakhangarg

Latest Interview Questions