after dropdown selection fill the datagrid in mvc?

Prasad Bhagat

10y1.2k.NET

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 javascript,am using simple c# for to fill the dropdown .so please help me to solve these .need to pass dropdown id to fetch the data

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prasad Bhagat10y ago
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 Bhagat10y ago
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 Sajjad10y ago
provide the code what you did and where are you having issue?
Prasad Bhagat10y ago
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 Menoth10y ago
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..!!