Dear All,
i want to refresh a function that get the data from database ,
but to get the data from database i want to pass two string values ,
when i pass two values and hit get then data will appier .but after 30 sec i want to refresh the get function without blinking and updating the two input values ..
am posting my code bellow .please have a look on it geiv me some solutiion
function fnGetDeviceData() {
var ddlDevice =$("#ddlDevice").val();//"NHMSES0001";//
var datepicker = $("#ddlYear").val() + "-" + $("#ddlMonth").val() + "-" + $("#ddlDate").val();// $("#datepicker").val();
$.ajax({
type: "POST",
url: "Reports.aspx/GetDevicesReport",
data: "{'DeviceId' : " + JSON.stringify(ddlDevice) + ",'Date' : " + JSON.stringify(datepicker) + "}",
contentType: "application/json; charset=utf-8",
datatype: "jsondata",
success: function (ResultSet) {
if ((ResultSet.d != null) && (ResultSet.d != "undefined")) {
if (ResultSet.d.ResultStatus.StatusInd == -1) {
var getDevice = ResultSet.d.lstReportsDetails;
PopulateProducts(getDevice);
}
else {
//LoadDropDown();
alert(ResultSet.d.ResultStatus.StatusMsg);
}
}
},
});
}
function PopulateProducts(getDevice) {
$("#tblReport").html("");
var strHeaderRow = "";
var strtr = "";
strHeaderRow = ""; ";
// strHeaderRow += "Device Id ";
strHeaderRow += "Time ";
// strHeaderRow += "Time ";
// strHeaderRow += "Voltage1 ";
// strHeaderRow += "Voltage2 ";
// strHeaderRow += "Voltage3 ";
// strHeaderRow += "Voltage4 ";
// strHeaderRow += "Voltage5 ";
// strHeaderRow += "Voltage6 ";
// strHeaderRow += "Voltage7 ";
strHeaderRow += "Temp1 ";
strHeaderRow += "Temp2 ";
strHeaderRow += "Temp3 ";
strHeaderRow += "Temp4 ";
// strHeaderRow += "Temp5 ";
// strHeaderRow += "Temp6 ";
// strHeaderRow += "Temp7 ";
strHeaderRow += "Avg ";
strHeaderRow += "
$("#tblReport").append(strHeaderRow);
if (getDevice.length > 0) {
for (var i = 0; i < getDevice.length; i++) {
strtr = "";
strtr += ""; ";
// if (getDevice[i].Deviceid != "")
// strtr += "" + $.trim(getDevice[i].Deviceid) + " ";
// else
// strtr += " ";
if ($.trim(getDevice[i].Time) != "")
strtr += "" + $.trim(getDevice[i].Time) + " ";
else
strtr += " ";
// if ($.trim(getDevice[i].Time) != "")
// strtr += "" + $.trim(getDevice[i].Time) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage1) != "")
// strtr += "" + $.trim(getDevice[i].Voltage1) + " ";
// else
// strtr += " ";
//
// if ($.trim(getDevice[i].Voltage2) != "")
// strtr += "" + $.trim(getDevice[i].Voltage2) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage3) != "")
// strtr += "" + $.trim(getDevice[i].Voltage3) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage4) != "")
// strtr += "" + $.trim(getDevice[i].Voltage4) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage5) != "")
// strtr += "" + $.trim(getDevice[i].Voltage5) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage6) != "")
// strtr += "" + $.trim(getDevice[i].Voltage6) + " ";
// else
// strtr += " ";
// if ($.trim(getDevice[i].Voltage7) != "")
// strtr += "" + $.trim(getDevice[i].Voltage7) + " ";
// else
// strtr += " ";
if ($.trim(getDevice[i].Temp1) != "")
strtr += "" + $.trim(getDevice[i].Temp1) + " ";
else
strtr += " ";
if ($.trim(getDevice[i].Temp2) != "")
strtr += "" + $.trim(getDevice[i].Temp2) + " ";
else
strtr += " ";
if ($.trim(getDevice[i].Temp3) != "")
strtr += "" + $.trim(getDevice[i].Temp3) + " ";
else
strtr += " ";
if ($.trim(getDevice[i].Temp4) != "")
strtr += "" + $.trim(getDevice[i].Temp4) + " ";
else
strtr += " ";
// if ($.trim(getDevice[i].Temp5) != "")
// strtr += "" + $.trim(getDevice[i].Temp5) + " ";
// else
// strtr += " ";
//
// if ($.trim(getDevice[i].Temp6) != "")
// strtr += "" + $.trim(getDevice[i].Temp6) + " ";
// else
// strtr += " ";
//
// if ($.trim(getDevice[i].Temp7) != "")
// strtr += "" + $.trim(getDevice[i].Temp7) + " ";
// else
// strtr += " ";
if ($.trim(getDevice[i].Avg) != "")
strtr += "" + $.trim(getDevice[i].Avg) + " ";
else
strtr += " ";
strtr += "
$('#tblReport').append(strtr);
}
//$('#ddlDevice').empty();
//LoadDropDown();
$("#datepicker").datepicker();
}
// else {
// strtr = "";
Francis SusaimichaelPosted Jun 1, 2016, 2:55 PM
myVar = setInterval(getDataFromDB, 30000);
}
function getDataFromDB() {
}