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,