[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

DataTable in Json format

Posted on 2012-03-09
2
Medium Priority
?
1,452 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 2000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

While working on Silverlight and WCF application, I faced one issue where fault exception occurred at WCF operation contract is not getting propagated to Silverlight client. So after searching net I came to know that it was behavior by default for s…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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