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
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
Francis SusaimichaelPosted Jan 19, 2016, 4:47 AM
Prasad BhagatPosted Jan 19, 2016, 2:40 AM
Nishant MittalPosted Jan 18, 2016, 11:00 PM