Introduction:
Description:
In
previous post I explained ExecuteNonQuery Example and differences between ExecuteNonQuery,
ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteScalar concept with one example in asp.net using C#.net, VB.NET.
ExecuteScalar
Execute
Scalar will return first row first column value i.e. it will return single
value and ignore other values on execution of SQL Query or Stored procedure
using command object. It’s very fast to retrieve single values from database.