after dropdown selection fill the datagrid in mvc?

Question

Dear All am new to mvc i have some 2 simple problems . am bind some data to dropdownlist using sql stored procedure.and now i want to bind the data when am selecting the dropdown based on that dropdown value need to bind the datagrid using stored procedure in mvc . am not using jquery and javascriptam using simple c# for to fill the dropdown .so please help me to solve these .need to pass dropdown id to fetch the data

Prasad Bhagat · Answer

Dear all i have one stored procedure for bind the values to dropdown  CREATE PROCEDURE [dbo].[GetDevices] AS BEGIN SELECT DeviceID Name Description CreatedDate FROM dbo.DevicesMaster END this is for bind the device id to my dropdown  and other one CREATE PROCEDURE [dbo].[GetDevicesData] @DeviceId nvarchar(20) @Rcvdate date AS BEGIN SELECT Deviceid RcvDate Voltage1 Voltage2 Voltage3 Voltage4 Voltage5 Voltage6 Voltage7 FROM dbo.TemperatureSensorData WHERE Deviceid = @DeviceId AND Rcvdate = @Rcvdate END this is for search with two parameters  after entering the two values need to press search button  then bind the data to datagrid so please help me how can ii do this in mvc without entity freamework

Prasad Bhagat · Answer

Dear Shajid i have two stored procedurs one is bind the values to dropdowlist second one is for search with two parameters like dropdownlist value and datetime so when am select dropdownlist and entered datetime into textbox then am hitting search button now i want to bind the data into data grid .this is my scenario am purly new to mvc please give me solution

Ehsan Sajjad · Answer

provide the code what you did and where are you having issue?

Prasad Bhagat · Answer

Not Exactly Rajesh am looking for when am selected some value from drop down after clicking button need bind all the related data into web grid using mvc with stored procedures .so please help me .its seems to looks like search

Rajeesh Menoth · Answer

Hi Check the following reference : http://www.c-sharpcorner.com/UploadFile/4d9083/filter-grid-with-cascading-dropdownlist-in-mvc-using-razor/ http://forums.asp.net/t/1791872.aspx?How+to+populate+webgrid+dynamically+from+dropdown+in+MVC3+ http://www.aspdotnet-pools.com/2014/09/bind-dropdownlist-in-mvc-webgrid-and.html The answer is helpful.Then please accept it ..!!