Download 100% FREE Office Document APIs for .NET
DotNetFunda.com
Online: 1219
Home > Forums > ASP.NET >

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

Posted by Rajeshk under ASP.NET on 1/5/2013 | Points: 10 | Views : 812 | Status : [Member] | Replies : 2
Write New Post | Search Forums | AnsweredResolved 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

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

Latest Posts