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 various objects in dataset.

0 Answers  

List all the steps in order, to access a database through ado.net?

0 Answers  

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example.

5 Answers   Softcon, Tecra,

What is DataRowCollection?

0 Answers  

What is ado full form?

0 Answers  

How to sort the data in Datatable

2 Answers   NetProphet,

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

0 Answers  

What DataReader class do in ADO.NET ?

0 Answers   NA,

what is Execute NOn Query?

29 Answers   Infosys, Protech, Sars Systems, SwanSoft Technologies,

What is the default Timeout for SqlCommand.CommandTimeout property?

0 Answers  

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,

What are the different methods available under the sqlcommand class to access the data?

0 Answers