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

What is the default Timeout for SqlCommand.CommandTimeout property?

0 Answers  

What is XML serialization

0 Answers   Digital GlobalSoft,

Define table relations?

0 Answers  

How to work with disconnected data - the dataset and sqldataadapter?

0 Answers  

How many commands does the oledbcommand takes?what are they?

2 Answers  

Is ado.net dead?

0 Answers  

What are the ado.net objects?

0 Answers  

What are the difference between readonly vs. Const?

0 Answers  

What is difference between executenonquery and executequery?

0 Answers  

How can we check that some changes have been made to dataset since it was loaded?

0 Answers  

Does entity framework use ado.net?

0 Answers  

How to Handle the exceptions in Sqlsrver2000

3 Answers   SQL Star,