Hi,
I am developing MVC 5 application. In that I am using Search functionality. I have 3 text boxes and 2 drop down lists in my form, my requirement is enter the text in these fields and the results will display in Grid view. I am using Stored procedure. Now my question is pass the parameters to stored procedure and pass the parameters to controller and display the search results in gridview.
Thank you.
Loading
Guest UserPosted Aug 20, 2014, 6:31 PM
http://weblogs.asp.net/dwahlin/using-entity-framework-code-first-with-stored-procedures-that-have-output-parameters
http://msdn.microsoft.com/en-us/library/vstudio/bb896274(v=vs.100).aspx
neel kPosted Aug 20, 2014, 2:32 PM
Guest UserPosted Aug 19, 2014, 12:49 PM
var orderId= new SqlParameter("orderid", SqlDbType.Int);
orderId.Value = 1809;
you can execute like this:
neel kPosted Aug 19, 2014, 12:42 PM
Thank you for your replay. I am using Entity Framework.
var lstCust = db.Database.SqlQuery
This is my stored procedure in Controller.
Thank you.
Guest UserPosted Aug 19, 2014, 12:29 PM