Datatable with MSSQL
Datatable with MSSQL
ManojKumar
Posts: 2Questions: 0Answers: 0
Dear friends,
First of all, Very Big Thanks for Allan and team for this great stuff!!!
Iam using this Datatable from my last two projects. No worries yet and It was successfully running so far. But i now need the same thing to work along with MSSQL in my new project. I had built corresponding queries in MSSQL and gave a tryout but the result is that the datatable was not loading (means still processing). I had printed the JSON format response and it seems to be ok. Also, i tried the same sample value with static array instead of server side processing and it also working fine. I couldnt trace the problem and i didnt know where i had made mistake. Following is the JSON format output:
{ "sEcho": 0, "iTotalRecords": 2, "iTotalDisplayRecords": 2, "aaData": [ ["1","1","1","1","Report"],["1","1","1","1","Report"] ] }
Please help to make this work...
Thanks in Advance
ManojKumar B
First of all, Very Big Thanks for Allan and team for this great stuff!!!
Iam using this Datatable from my last two projects. No worries yet and It was successfully running so far. But i now need the same thing to work along with MSSQL in my new project. I had built corresponding queries in MSSQL and gave a tryout but the result is that the datatable was not loading (means still processing). I had printed the JSON format response and it seems to be ok. Also, i tried the same sample value with static array instead of server side processing and it also working fine. I couldnt trace the problem and i didnt know where i had made mistake. Following is the JSON format output:
{ "sEcho": 0, "iTotalRecords": 2, "iTotalDisplayRecords": 2, "aaData": [ ["1","1","1","1","Report"],["1","1","1","1","Report"] ] }
Please help to make this work...
Thanks in Advance
ManojKumar B
This discussion has been closed.
Replies