Click here to Skip to main content
15,886,422 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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" }
]


});
});
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900