can we give more than one execute method to comanad object?

Posted by Rajeshk under ASP.NET on 1/5/2013 | Points: 10 | Views : 769 | Status : [Member] | Replies : 2
hi all,
generelly when we work with ado.net to execute query we have to give execution method (executquery,nonexecutequery,executescalar) i had a doubt in this that is can we give more than one execute method to command object? replay plz

Thanks&Regards
rajeshkommireddy@gmail.com



Responses

Posted by: Shubham on: 1/7/2013 [Member] Starter | Points: 25

Up
0
Down
Hi!!!! rajeshk

good question!!!!!

More than one Command object can use the connection from the same Connection object. Executing commands can generate zero, one, or multiple recordsets. For example, executing a data definition language query does not generate a recordset. Executing one SELECT statement can generate a recordset, and executing a batch of SELECT statements or a stored procedure can generate more than one recordset.

Thanks&Regards:-
Shubham Choudhary
Software Engineer
www.facebook.com/shubham.kunar

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajeshk on: 1/7/2013 [Member] Starter | Points: 25

Up
0
Down
Thank you for the replay shubaham...
so you are sayinig that we can give more than one execution method to command object right? thank you. once i will work on this

Thanks&Regards
rajeshkommireddy@gmail.com

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response