MVC get data from sql sp and pass parameter from dropdown

Chandan Rajbhar8y ago

If you to bind dropdown from.

like Dropdown State

$("#ldrpState").val(response.data.StateId);

or

$("#ldrpState").val(StateId);

-1

Ramesh Palanivel8y ago

Hi Gauvrav,

Please refer this link.Its very clear to understand.

https://www.youtube.com/watch?v=Z7713GBhi4k

+1

Gaurav Pal8y ago

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 value,i want to count the records from database on button click

0

Ramesh Palanivel8y ago

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/

+1