what are the usage of using store procedure in ASP.NET?

Question

I mean I want to write some queries in ASP.NET so I want to know completely about this subject, please guide me. Thank you

Praveen Dhatrika · Answer

In order to avoid SQL attack, which is similar like hacking database and data, we use SP(Store procedures). SP are like naming your SQL Query and then use the name in your ADO.net code. Which actually talk to the database and finds out the SP and then run the definition declared to that SP(which is set of queries). Please find below links to know more in detail in writing and using store procedures. http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html http://csharp-video-tutorials.blogspot.com/2013/09/part-7-calling-stored-procedure-with.html Also there are many articles in C-Sharp corner, just search by "store procedure" word and it could give you info you required. If you find my post as useful then accept my reply as answer. :)

Joe Wilson · Answer

Thank you sir.

Praveen Dhatrika · Answer

Good Luck :)

Joe Wilson · Answer

Thank you very much for your suggestions, I am in your dept again.

Francis · Answer

Do you have some electronic books about learning SQL SERVER , So if you have please send me a few of them Sure. There are lot of online as well as offline materials available. I mentioned few of them here: Online: blog. sqlauthority .com - A wonderful blog of Pinaldave about all varieties of SQL Server stuffs. SQL Server MSDN Forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver Offline (books) : Beginning Microsoft SQL Server 2008 Programming - By Robert Vieira. This is a nice book to learn SQL Server, which i have read. Hope this helps!

Upendra Pratap Shahi · Answer

Kindly always check version in which you have write your query and that is supportable or not.

Joe Wilson · Answer

Hi, Do you have some electronic books about learning SQL SERVER , So if you have please send me a few of them

Joe Wilson · Answer

I mean while I am writing queries which are somehow advanced I face some gaps which I could't figure out and solve them so I need a few sources (books or websites) in order to fill the gaps and create store procedures with strong queries.

Ranjit Powar · Answer

Give details about error. Post error message.

Joe Wilson · Answer

I have some problem while creating and using stored procedures I mean while I am writing advanced queries in stored procedures so please guide me or even suggest a few websites related to it. Thank you

Jignesh Trivedi · Answer

Hi, There are many advantages of stored procedure.please refer below link http://www.seguetech.com/blog/06/04/Advantage-drawbacks-stored-procedures-processing-data apart of this please refer following link for how can we use stored procedure with asp.net application. http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx hope this will help you.

Ranjit Powar · Answer

There are some advantages of using stored procedures. 1. Stored procedures are not complied every time. When you create SP it is complied and stored in database. So when execution time is decreases. 2. Once you can create SP you can use it number of time. You don't need to write same query again. 3.It is better to avoid Sql Injection attacks.