MVC 5 Search Functionality

Question

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.

Sumit Jolly · Answer

pls refer these 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 k · Answer

Can you please send some links.

Sumit Jolly · Answer

you can pass parameter like: var orderId= new SqlParameter(orderid SqlDbType.Int); orderId.Value = 1809; you can execute like this: string command = EXEC sp_GetPendingCustomers @orderid; context.ExecuteStoreCommand(command @orderId);

neel k · Answer

Hi Thank you for your replay. I am using Entity Framework. var lstCust = db.Database.SqlQuery (sp_GetPendingCustomers); This is my stored procedure in Controller. Thank you.

Sumit Jolly · Answer

which database framework are you using for interaction with DB e.g. Entity Framework etc