nimaaamin
چهارشنبه 14 بهمن 1394, 13:12 عصر
سلام دوستان
من از طریق تابع ajax
یک سری اطلاعات از وب سرویس دریافت میکنم :
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "../webservice/Details.asmx/get_raingaugedatainitial",
data: "{}",
dataType: "json",
success: function (Result) {
$("#ContentPlaceHolder1_list_datainitial tr").remove();
$("#ContentPlaceHolder1_list_datainitial").append("<tr>" +
"<th style=width:30px;>#</th>" +
"<th style=width:50px;>date</th>" +
"<th style=width:50px;>time</th>" +
"<th style=width:50px;>Minute Rain</th>" +
"<th style=width:50px;>Total Rain</th>" +
"<th style=width:50px;>RTUBatVolt</th>" +
"<th style=width:50px;>DBStatus</th>" +
"<th style=width:50px;>HUMData</th>" +
"<th style=width:50px;>DS18B20Data</th>" +
"<th style=width:50px;>TempMax</th>" +
"<th style=width:50px;>TempMin</th>" +
"<th style=width:50px;>HumMax</th>" +
"<th style=width:50px;>HumMin</th>" +
"<th style=width:10px;></th>" +
"</tr>");
$.each(Result.d, function (key, value) {
$("#ContentPlaceHolder1_list_datainitial").append
("<tr>" +
"<td style=width:30px; >" + value.row + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventdate + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventtime + "</td>" +
"<td style=width:80px;>" + value.raingauge_minuterain + "</td>" +
"<td style=width:80px;>" + value.raingauge_totalrain + "</td>" +
"<td style=width:80px;>" + value.raingauge_rtubatvolt + "</td>" +
"<td style=width:80px;>" + value.raingauge_boardtemp + "</td>" +
"<td style=width:80px;>" + value.raingauge_dbstatus + "</td>" +
"<td style=width:80px;>" + value.raingauge_humdata + "</td>" +
"<td style=width:80px;>" + value.raingauge_ds18b20data + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmax + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmin + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummax + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummin + "</td>" +
"<td style=width:10px;><a href=#>حذف</a></td>" +
"</tr>");
});
$("#ContentPlaceHolder1_list_datainitial").tablePagination({});
},
error: function (Result) {
alert("error");
}
});
public List<raingaugedatainitial> get_raingaugedatainitial()
{
SqlConnection connect = objcon.conect();
List<raingaugedatainitial> raingaugedatainitial_list = new List<raingaugedatainitial>();
DataSet ds;
using (SqlCommand cmd = new SqlCommand("SELECT TOP (200)* FROM tbl_raingauge ORDER BY raingauge_eventdateyear,raingauge_eventdatemounth, raingauge_eventdateday,raingauge_eventdatehour,rai ngauge_eventtimeminute,raingauge_eventtimesecond", connect))
{
connect.Open();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
ds = new DataSet();
da.Fill(ds);
connect.Close();
}
}
try
{
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
int k = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
raingaugedatainitial_list.Add(new raingaugedatainitial()
{
row=k.ToString(),
raingauge_eventdate = dr["raingauge_eventdate"].ToString(),
raingauge_eventtime = dr["raingauge_eventtime"].ToString(),
raingauge_minuterain = dr["raingauge_minuterain"].ToString(),
raingauge_totalrain = dr["raingauge_totalrain"].ToString(),
raingauge_boardtemp = dr["raingauge_boardtemp"].ToString(),
raingauge_dbstatus = dr["raingauge_dbstatus"].ToString(),
raingauge_ds18b20data = dr["raingauge_ds18b20data"].ToString(),
raingauge_rtubatvolt = dr["raingauge_rtubatvolt"].ToString(),
raingauge_tempmax = dr["raingauge_tempmax"].ToString(),
raingauge_tempmin = dr["raingauge_tempmin"].ToString(),
raingauge_humdata = dr["raingauge_humdata"].ToString(),
raingauge_hummax = dr["raingauge_hummax"].ToString(),
raingauge_hummin = dr["raingauge_hummin"].ToString()
});
k++;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return raingaugedatainitial_list;
}
مشکلی که دارم اینه که وقتی تعداد سطر های این لیست از 200 میگذره تابع ajax دیگه نمیتونه اطلاعات رو توی تیبل نمایش بده!!!!!!!!!!!!!!!!!!!!!!!!!
لطفا راهنمایم کنید
من از طریق تابع ajax
یک سری اطلاعات از وب سرویس دریافت میکنم :
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "../webservice/Details.asmx/get_raingaugedatainitial",
data: "{}",
dataType: "json",
success: function (Result) {
$("#ContentPlaceHolder1_list_datainitial tr").remove();
$("#ContentPlaceHolder1_list_datainitial").append("<tr>" +
"<th style=width:30px;>#</th>" +
"<th style=width:50px;>date</th>" +
"<th style=width:50px;>time</th>" +
"<th style=width:50px;>Minute Rain</th>" +
"<th style=width:50px;>Total Rain</th>" +
"<th style=width:50px;>RTUBatVolt</th>" +
"<th style=width:50px;>DBStatus</th>" +
"<th style=width:50px;>HUMData</th>" +
"<th style=width:50px;>DS18B20Data</th>" +
"<th style=width:50px;>TempMax</th>" +
"<th style=width:50px;>TempMin</th>" +
"<th style=width:50px;>HumMax</th>" +
"<th style=width:50px;>HumMin</th>" +
"<th style=width:10px;></th>" +
"</tr>");
$.each(Result.d, function (key, value) {
$("#ContentPlaceHolder1_list_datainitial").append
("<tr>" +
"<td style=width:30px; >" + value.row + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventdate + "</td>" +
"<td style=width:80px;>" + value.raingauge_eventtime + "</td>" +
"<td style=width:80px;>" + value.raingauge_minuterain + "</td>" +
"<td style=width:80px;>" + value.raingauge_totalrain + "</td>" +
"<td style=width:80px;>" + value.raingauge_rtubatvolt + "</td>" +
"<td style=width:80px;>" + value.raingauge_boardtemp + "</td>" +
"<td style=width:80px;>" + value.raingauge_dbstatus + "</td>" +
"<td style=width:80px;>" + value.raingauge_humdata + "</td>" +
"<td style=width:80px;>" + value.raingauge_ds18b20data + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmax + "</td>" +
"<td style=width:80px;>" + value.raingauge_tempmin + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummax + "</td>" +
"<td style=width:80px;>" + value.raingauge_hummin + "</td>" +
"<td style=width:10px;><a href=#>حذف</a></td>" +
"</tr>");
});
$("#ContentPlaceHolder1_list_datainitial").tablePagination({});
},
error: function (Result) {
alert("error");
}
});
public List<raingaugedatainitial> get_raingaugedatainitial()
{
SqlConnection connect = objcon.conect();
List<raingaugedatainitial> raingaugedatainitial_list = new List<raingaugedatainitial>();
DataSet ds;
using (SqlCommand cmd = new SqlCommand("SELECT TOP (200)* FROM tbl_raingauge ORDER BY raingauge_eventdateyear,raingauge_eventdatemounth, raingauge_eventdateday,raingauge_eventdatehour,rai ngauge_eventtimeminute,raingauge_eventtimesecond", connect))
{
connect.Open();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
ds = new DataSet();
da.Fill(ds);
connect.Close();
}
}
try
{
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
int k = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
raingaugedatainitial_list.Add(new raingaugedatainitial()
{
row=k.ToString(),
raingauge_eventdate = dr["raingauge_eventdate"].ToString(),
raingauge_eventtime = dr["raingauge_eventtime"].ToString(),
raingauge_minuterain = dr["raingauge_minuterain"].ToString(),
raingauge_totalrain = dr["raingauge_totalrain"].ToString(),
raingauge_boardtemp = dr["raingauge_boardtemp"].ToString(),
raingauge_dbstatus = dr["raingauge_dbstatus"].ToString(),
raingauge_ds18b20data = dr["raingauge_ds18b20data"].ToString(),
raingauge_rtubatvolt = dr["raingauge_rtubatvolt"].ToString(),
raingauge_tempmax = dr["raingauge_tempmax"].ToString(),
raingauge_tempmin = dr["raingauge_tempmin"].ToString(),
raingauge_humdata = dr["raingauge_humdata"].ToString(),
raingauge_hummax = dr["raingauge_hummax"].ToString(),
raingauge_hummin = dr["raingauge_hummin"].ToString()
});
k++;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return raingaugedatainitial_list;
}
مشکلی که دارم اینه که وقتی تعداد سطر های این لیست از 200 میگذره تابع ajax دیگه نمیتونه اطلاعات رو توی تیبل نمایش بده!!!!!!!!!!!!!!!!!!!!!!!!!
لطفا راهنمایم کنید