How is stored procedure different from functions? Function cannot affect the state of the database which means we cannot perform CRUD operation on the database. Stored Procedure can affect the state of the database by using CRUD operations. Store Procedure can return zero or n values whereas Function can return only one value. Store Procedure can have input, output parameters for it whereas functions can have only input parameters. Function can be called from Stored Procedure whereas Stored Procedure cannot be called from Function How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? ADO.NET provides the SqlCommand object, which provides the functionality of executing stored procedures. In the command type we need to provide the command type as stored procedure as shown in the below code snippet. SqlCommand objCommand = new SqlCommand("sp_Insert", objConnection ; objCommand.CommandType = CommandType.StoredProcedure; objCommand.ExecuteNonQuery(); See following video on dataset is a disconnected while datareader is connected: – Click and see here for more ADO.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.


This article is related to

Uncategorized,(Information technology) IT interview questions with answers,ADO.NET basics,Ado.Net Interview Questions,ADO.NET training,Csharp interview questions,How to learn ADO.NET,optimistic locking,pessimistic locking,programming interview questions,step by step ADO.NET