MVC get data from sql sp and pass parameter from dropdown

Question

Hi I am new in MVC and i want to know that how we get data from sql sp to grid and passing parameters of sqlsp from dropdownlist selected value.

Ramesh Palanivel · Answer

Hi Gauvrav Please refer this link.Its very clear to understand. https://www.youtube.com/watch?v=Z7713GBhi4k

Ramesh Palanivel · Answer

Hi Gaurav In MVC you don't want to write stored procedure to get date. Use Entity Framework(ORM). It will very easy way to get data. Please use the below URL's for your reference. http://www.entityframeworktutorial.net/code-first/entity-framework-code-first.aspx http://www.tutorialsteacher.com/mvc/asp.net-mvc-tutorials http://www.c-sharpcorner.com/UploadFile/8c19e8/building-web-application-using-entity-framework-database-fir/

Gaurav Pal · Answer

Can u please provide me any video tutorial. My requiement is to get distinct data from database table to Dropdownlist and on the basis of this dropdownlist selected valuei want to count the records from database on button click

Chandan Rajbhar · Answer

If you to bind dropdown from. like Dropdown State $(#ldrpState).val(response.data.StateId); or $(#ldrpState).val(StateId);