how to show data table from asp.net web form web method server side to client side ( .aspx page)

jimoscarlobo

Default.aspx.cs:
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;
using Newtonsoft.Json;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string GetData()
{
string jstring = string.Empty;
DataTable dt = new DataTable();
dt.Columns.Add("pname");
dt.Columns.Add("loc");
dt.Columns.Add("country");
dt.Columns.Add("fname");
dt.Rows.Add("abcd", "xxx", "ie", "NIKE");
dt.Rows.Add("kbfdgh", "blackrock", "uk", "Didi");
dt.Rows.Add("gtrjht", "malahide", "uk", "OPEN");
dt.Rows.Add("wxznay", "CORK", "ie", "WIN");
return jstring = JsonConvert.SerializeObject(dt);
}

public class firmdet
{
    public string pname { get; set; }
    public string loc { get; set; }
    public string country { get; set; }
    public string fname { get; set; }
}

}

Default.aspx:
$(document).ready(function () {
$('#example').DataTable({
"ajax": {
"url": "Default.aspx/Getdata",
"dataSrc": ""
},
"columns": [
{ "data": "pname" },
{ "data": "loc" },
{ "data": "country" },
{ "data": "fname" },
]
});
});
</script>

ERROR:

DataTables warning: table id=example - Invalid JSON response.for more information about this error please see
https://datatables.net/manual/tech-notes/1
getting valid json

[{
"pname": "abcd",
"loc": "xxx",
"country": "ie",
"fname": "NIKE"
}, {
"pname": "kbfdgh",
"loc": "blackrock",
"country": "uk",
"fname": "Didi"
}, {
"pname": "gtrjht",
"loc": "malahide",
"country": "uk",
"fname": "OPEN"
}, {
"pname": "wxznay",
"loc": "CORK",
"country": "ie",
"fname": "WIN"
}]