Hi,
I was able to get the data from the JSON to datatable using the link here
http://www.aspforums.net/Threads/136177/Read-Complex-Json-and-convert-Json-string-to-DataTable-using-jQuery-Ajax-in-ASPNet/
But the rows do not show up in the page source since we are binding to gridview using jquery.
Here is what page source looks like
<table cellspacing="0" rules="all" border="1" id="gvJsonData1" style="border-collapse:collapse;">
<tr>
<th scope="col">id</th><th scope="col">Billingname</th><th scope="col">Companyname</th><th scope="col">Address</th><th scope="col">Email</th><th scope="col">Mobile</th><th scope="col">value</th><th scope="col">currency</th><th scope="col">status</th>
</tr><tr>
<td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td>
</tr>
</table>
Can u suggest a solution? I need to get the data table to excel and upload it to sqlserver.