First code migration

Question

Hello there,

is there any tutorial that has been done to show me how to call stored procedure in sql server management studio using first migration code (visual C#). I really appreciate any help. it would be awesome if it is a video demo.

Thank you very much

Answer 1

It's call using ADO.NET.

https://msdn.microsoft.com/en-us/library/h43ks021%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

http://www.csharp-station.com/Tutorial/AdoDotNet/Lesson07

You can look for a video by using Bing or Google.

Answer 2

Thank you very much

Answer 3

Hi Montadar,

You should refer below useful articles and threads,

Insert and retrieve data through stored procedure

Calling Stored procedures in ADO.NET

How to execute a stored procedure within C# program

Call a stored procedure with parameter in c#

---

Thanks, If my reply is helpful please mark as answer or vote as helpful.