| Author: Satyanarayan SushilKumar Bajoria 05 Jul 2008 | Member Level: Diamond Points : 1 |
Hi,
Very good information on Execute non-query and Execute scalar.
We use Execute scalar method frequently for authentication purpose.
Thanks for sharing your knowledge.
Keep posting such useful information on .net.
Thanks and Regards
S.S.Bajoria
|
| Author: Afsar 05 Jul 2008 | Member Level: Bronze Points : 2 |
* We use Execute NonQuery to perform DML(Data Manipulation Language)operations,which return how many row get affected.
* We use execute Scalare to retrive data that has single value like counting how many row in a table.
We can also use Execute Scalar to retrive 0th Row, Oth Column Data from a table.
|
| Author: Arun Nair 05 Jul 2008 | Member Level: Bronze Points : 0 |
Clear information.
Thanks a lot...
|
| Author: sathiya 07 Jul 2008 | Member Level: Silver Points : 1 |
we are using Execute scalar for Aggregate functions like SUM(),COUNT(),AVG(),MAX(),MIN() which returns integer values
|