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 are advantages of microsoft-provided data provider classes in ado.net?

0 Answers  

Give an example of a .net application which connects to microsoft access database using ado.net classes.

0 Answers  

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers  

How do you merge two datasets into the third dataset in a simple manner?

3 Answers   IBM,

Is datareader faster than datatable?

0 Answers  

What is the difference between data reader and data adapter?

0 Answers  

Difference between sqlcommand and sqlcommandbuilder?

0 Answers  

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

Is it possible to edit data in Repeater control?

0 Answers  

Which is faster entity framework or ado.net?

0 Answers  

what is a dataview?why is it used for?

4 Answers   Choice Solutions,

How to create data relations?

0 Answers