search in mvc ?

Question

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