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

Posted by Rajeshk under ASP.NET on 1/5/2013 | Points: 10 | Views : 787 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts