Hi,
I have some problem about command object properties, that is ExcecuteScaler, EcxecuteReader and ExecuteNonQuerry method. I have not cleared the difference b/w them. When and where which of these property is used in the application. Plz explanin these objects clearly.
Thanks

well.. u really should read about those in the MSDN, that can give u much more information that what I will :) but anyway.. it's as simple as this.
Excute Scaler: returns only one value.. such as count(), Max(), Min().. etc (first row, first column)
ExecuteNonQuerry: for Insert/update/delete etc.. commands and it returns an int which represents the number of rows effected.
EcxecuteReader: returns a set o rows (one at a time) which are read only and u can view them one at a time.

:) hope i can help :)

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

Thanks to help,
Actually i have already read this topics in msdn, but there is bulk of explnation, that i could not understand. Now my concept is much clear about these properties.
Thanks