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

How is it possible to get 2 tables of data at a time by using data reader?

0 Answers  

What is the difference between ADO and ADO.Net?

0 Answers  

Can I use One Data Set for More than one Data Adapter?

6 Answers  

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

How to creating a SqlCommand Object?

0 Answers   Arigo Infotech,

What is ado oledb and odbc?

0 Answers  

Write steps of retrieving data using ado.net ?

3 Answers   Keane India Ltd,

What is the difference between Datareader and Dataset?

0 Answers  

How to pass multiple tables in datasets simultaneously?

0 Answers  

Define table relations?

0 Answers  

What are the difference between readonly vs. Const?

0 Answers  

What is an ado connection?

0 Answers