BINDING STORED PROC. INPUT/OUTPUT TO A FORM

Question

I have a stored procedure for an SQL Server database. I'm attempting to build an interface but am having difficulty creating a form to execute the stored procedure. Specifically, I am not sure how to allow the users input value to be read and then used to execute the stored procedure. I understand how to do this in the vb environment (output window), but I want the stored procedure to receive input, execute, and display output all within a single form. Thanks.

Mahesh Chand · Answer

There is no direct UI control available for this. You need to create a Form with UI where user can enter the parameter values then you need to construct a Command object with Parameters and then execute the stored procedure using Command methods. See ADO.NET section of C# Corner and search for SqlCommand and SqlParameter. OK here are some samples: http://www.c-sharpcorner.com/Code/2003/Jan/InsOutsinCS.asp http://www.c-sharpcorner.com/Code/2003/Jan/UseSPwithDP.asp