Answer / thirushakar

Scalar will return only one value.
(ie we can read or write only one data at the time)

Answer / versha

When we want any aggreagate answer then we use execute
scaler examples like avg,sum etc
this return one row and one column

Answer / anjeswar

It Returns Single Scalar value as a result

Answer / muthu kumar

when we want to retrieve data that has single value then we
can prefer to execute scalar.

Answer / prabhat saxena

execute scalar return a object type value, by defalut it
will return first row of fst column value, mostly we used
it with aggregate function like sum(),max(),min(),avg()....

Answer / tonny

Executes the query, and returns the first column of the
first row in the result set returned by the query.
Additional columns or rows are ignored.

Answer / yograj pandey

Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a database. This requires less code than using the ExecuteReader method, and then performing the operations that you need to generate the single value using the data returned by a SqlDataReader.

A typical ExecuteScalar query can be formatted as in the following C# example:

cmd.CommandText = "SELECT COUNT(*) FROM dbo.region";
Int32 count = (Int32) cmd.ExecuteScalar();

Answer / usha

This method is used to execute commands that return single
value rather than resultset.

Answer / adsd

scalar will returns single value.scalar eg like avg,sum etc
it vl return oly one column as output

Answer / vivek kumar

execute scalar method return only one value that means you
can use this with max, min, sum function

Explain the difference between data reader and data set?

0 Answers  

Which method is used by command class to execute SQL statements that return single value?

0 Answers  

What does sqldatareader return?

0 Answers  

How to perform sorting on a table in ADO.NET?

0 Answers   Petranics Solutions,

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

Is entity framework better than ado.net?

0 Answers  

What is defaultview in datatable?

0 Answers  

Explain the role of data provider in ado.net?

0 Answers  

What are the data providers used in ado.net

0 Answers  

Differentiate between Dataset and Recordset.

2 Answers  

What is the difference between sqldatareader and sqldataadapter?

0 Answers  

Some important instruction regarding ADO.NET connection string ?

0 Answers   NA,