Solved

DataTable in Json format

Posted on 2012-03-09
2
1,419 Views
Last Modified: 2012-03-10
Hello,

I am using Visual Studio 2010, Visual C#, .NET framework 4.0.

I have app in IIS. All my methods looks something like this:


        [OperationContract]
        [WebGet(ResponseFormat = WebMessageFormat.Json)]
        public string Select()
        {            
            return "Hello World";
        }

And the work fine - the only problem is how to return DataTable in Json format?

I've found this topic: http://schotime.net/blog/index.php/2008/07/27/dataset-datatable-to-json/

But, nothings comes back from the server. The dictionary<string, object> is created, but nothing is returned from server.

I need to return DataTable in Json format and the (on the client) convert this back to DataTable and show in DataGrid (Windows forms).


Regards, Frenky
0
Comment
Question by:AntonioRodrigo
2 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 37705022
Frankly, Frenky, I would use a business object, instead of a DataTable.  You can apply a DataContract to the class, and DataMember to the members, and return a list of those objects.
0
 

Author Closing Comment

by:AntonioRodrigo
ID: 37705639
Yes, very good point. And that list of object I can map to DataTable on the client. I've also found one solution by myself: put DataTable into MemoryStream and return MemoryStream.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question