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 the methods of XML dataset object?

0 Answers  

What is the purpose of using adodb?

0 Answers  

What is untyped dataset?

0 Answers  

Explain different methods and Properties of DataReader which you have used in your project?

2 Answers  

What is microsoft ado.net?

0 Answers  

What are the Data providers in ADO.Net?

0 Answers  

how to display empty table to datagrid

3 Answers   LG Soft,

Describe briefly an ADO.NET Dataset ?

0 Answers   Siebel,

How to add a javaScript function in a datagrid?

0 Answers   C DAC, CDAC,

What is dataset and datatable in ado.net?

0 Answers  

What are the classes in System.Data.Common Namespace?

0 Answers  

What is the difference between ado.net and oledb?

0 Answers