无法在服务器端脚本中生成json格式的数据 [英] can't generate data in json format in server side scripting

问题描述

我无法将数据检索到数据表中。有人可以帮帮我吗

脚本代码



adp.Fill（数据集）;



LoadData（）

{

str ={;

str + =\sEcho \ ：+sEcho+，;

str + =\iTotalRecords\：+ ds.Tables [0] .Rows.Count.ToString（）+ ，;



str + =\aaData \：[;

bool other = false;

foreach（数据行在ds.Tables [0]。行中）

{

if（other == true）

{

str + =，;

}

// str + =[;

str + =\+ row [EmployeeID]。ToString（）+\，;

str + =\+ row [FirstName ] .ToString（）+\，;

str + =\+ row [LastName]。ToString（）+\，;

str + =\+ row [Department]。ToString（）+\，;

str + =\+ row [Experience]。ToString（）+\，;

str + =\+ row [Salary]。ToString（ ）+\;

str + =];

其他= true;

}

str + =];

str + =};

返回str;

}

}

公共类EmployeeList

{

public int EmployeeID {get;组; } $ / $
公共字符串FirstName {get;组; }

公共字符串LastName {get;组; }

public string Department {get;组; }

public int Experience {get;组; }

public int Salary {get;组; }



}

客户端脚本是



$（文件） .ready（function（）{

$（'＃table_id'）。dataTable（{

sScrollY：200px，

bProcessing：true，

sPaginationType：full_numbers，

sAjaxSource：WebAppDatatablePoc_Default.LoadData（），

aoColumns ：[



{mData：EmployeeID}，/ * mdata-此属性可用于从任何JSON数据源属性读取数据* /

{mData：FirstName}，

{mData：LastName}，

{mData：Department }，

{mData：经验}，

{mData：薪水}

]





}）;

}）;

解决方案

< blockquote>（document）.ready（function（）{

（'＃table_id'）。dataTable（{

sScrollY： 200px，

bProcessing：true，

sPaginationType：full_numbers ，

sAjaxSource：WebAppDatatablePoc_Default.LoadData（），

aoColumns：[



{ mData：EmployeeID}，/ * mdata-此属性可用于从任何JSON数据源属性读取数据* /

{mData：FirstName}，

{mData：LastName}，

{mData：部门}，

{mData：体验}，

{mData：薪水}

]





}）;

}）;

I can't retrieve data into datatable. can someone help me out please
Code behind script

adp.Fill(dataset);

LoadData()
{
str = "{";
str += "\"sEcho\": " + "sEcho" + ",";
str += "\"iTotalRecords\": " + ds.Tables[0].Rows.Count.ToString() + ",";

str += "\"aaData\": [";
bool other = false;
foreach (DataRow row in ds.Tables[0].Rows)
{
if (other == true)
{
str += ",";
}
//str += "[";
str += "\"" + row["EmployeeID"].ToString() + "\",";
str += "\"" + row["FirstName"].ToString() + "\",";
str += "\"" + row["LastName"].ToString() + "\",";
str += "\"" + row["Department"].ToString() + "\",";
str += "\"" + row["Experience"].ToString() + "\",";
str += "\"" + row["Salary"].ToString() + "\"";
str += "]";
other = true;
}
str += "]";
str += "}";
return str;
}
}
public class EmployeeList
{
public int EmployeeID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Department { get; set; }
public int Experience { get; set; }
public int Salary { get; set; }

}
client side script is

$(document).ready(function() {
$('#table_id').dataTable({
"sScrollY": "200px",
"bProcessing": true,
"sPaginationType": "full_numbers",
"sAjaxSource": WebAppDatatablePoc_Default.LoadData(),
"aoColumns": [

{ "mData ": "EmployeeID" }, /* mdata-This property can be used to read data from any JSON data source property*/
{"mData ": "FirstName" },
{ "mData ": "LastName" },
{ "mData ": "Department" },
{ "mData ": "Experience" },
{ "mData ": "Salary" }
]


});
});

解决方案

(document).ready(function() {

('#table_id').dataTable({
"sScrollY": "200px",
"bProcessing": true,
"sPaginationType": "full_numbers",
"sAjaxSource": WebAppDatatablePoc_Default.LoadData(),
"aoColumns": [

{ "mData ": "EmployeeID" }, /* mdata-This property can be used to read data from any JSON data source property*/
{"mData ": "FirstName" },
{ "mData ": "LastName" },
{ "mData ": "Department" },
{ "mData ": "Experience" },
{ "mData ": "Salary" }
]


});
});

这篇关于无法在服务器端脚本中生成json格式的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！