how to convert xml to json

Question

0.00/5 (No votes)

See more:

in web method iam returning xml string like

C#

MemoryStream ms = new MemoryStream();
      dsCustomer.WriteXml(ms, XmlWriteMode.IgnoreSchema);
      StreamReader sr = new StreamReader(ms, System.Text.Encoding.UTF8);
      ms.Position = 0;
      String strXml = sr.ReadToEnd();
      sr.Close();
      ms.Close();
      return strXml;

in success method json iam calling like

JavaScript

$.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: 'url',
                    data: "{}",
                    async: false,
                    dataType: "xml",
                    success: function (data) {
                        build_menu(data)
                    },

my returned xml data from webmethod like

XML

<NewDataSet>
  <Table>
    <UserID>17727</UserID>
    <User>test user</User>
    <Ordering />
  </Table>
<Table1>
    <id>21</id>
    <CustomerID>12872</CustomerID>
    <Customer>Actavis Group</Customer>
    <Primarycsrid>16231</Primarycsrid>
    <PrimaryCSR>Kavitha Rani Aryamarati</PrimaryCSR>
    <ImplicitSameBranchAccess>true</ImplicitSameBranchAccess>
    <azGroup>A - C</azGroup>
    <IsLoggedOnUserCustomer>false</IsLoggedOnUserCustomer>
  </Table1>
</NewDataSet>

i want to show my out put as

HTML

{
  "NewDataSet": {
    "Table": [
      {
        "UserID": "17727",
        "User": "test user"
      },],
    "Table1": [
      {
        "id": "21",
        "CustomerID": "12872",
        "Customer": "Actavis Group",
        "Primarycsrid": "16231",
        "PrimaryCSR": "Kavitha Rani Aryamarati",
        "ImplicitSameBranchAccess": "true",
        "azGroup": "A - C",
        "IsLoggedOnUserCustomer": "false"
      },]
  }
}

how toonvert xml to json please help me

Posted 6-Apr-15 0:16am

Member hani

Updated 6-Apr-15 1:59am

v7

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Praveen_Kumar Gupta · Answer 1 · 2015-04-07T01:12:00

Solution 2

Please check below link
you can use nuget package newtonsoft json[^]

and easily convert Any Collection or object to json
as generic collection , data set , data table,
make data table from xml and convert that to json .

JSON[^]

ok

Then you can use
Here dt is DataTable

C#

System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
           Dictionary<string, object> row;
           foreach (DataRow dr in dt.Rows)
           {
               row = new Dictionary<string, object>();
               foreach (DataColumn col in dt.Columns)
               {
                   row.Add(col.ColumnName, dr[col]);
               }
               rows.Add(row);
           }
           return serializer.Serialize(rows);

Use This Method

C#

private StringBuilder DatasetToJson(DataSet ds)
       {
           var sb = new StringBuilder();
           var serializer =
               new JavaScriptSerializer();
           var rows = new List<Dictionary<string, object>>();
           Dictionary<string, object> row;
           foreach (DataTable dt in ds.Tables)
           {
               foreach (DataRow dr in dt.Rows)
               {
                   row = dt.Columns.Cast<DataColumn>().ToDictionary(col => col.ColumnName, col => dr[col]);
                   rows.Add(row);
               }
               sb.Append(serializer.Serialize(rows));
           }
           return sb;
       }

Posted 7-Apr-15 1:12am

Praveen_Kumar Gupta

Updated 8-Apr-15 1:52am

v3

Comments

Member hani 7-Apr-15 7:50am

third party dll will not use in my application so i have to convert through manually in json jquery

[no name] 8-Apr-15 0:47am

Please check now solution is improved,
i add JavaScriptSerializer class functionality to convert a dataTable into searilized string like json

Member hani 8-Apr-15 0:54am

how can i use dataset instead of datatable? along with column names..

[no name] 8-Apr-15 5:00am

Dataset is a collection of Datatables

Dataset[0] => represent table on index 0

so you can use easily.

Member hani 8-Apr-15 7:12am

if i give index then last added table will display but rest of tables are not save in json string

[no name] 8-Apr-15 7:28am

you can add all table one by one

as

foreach(DataTable dt in DataSet.Tables)
{
// activity
}

and add all tables one by one

Member hani 8-Apr-15 7:29am

how to add means i have to add rows? from above dictionary code....

[no name] 8-Apr-15 7:33am

foreach(DataTable dt in DataSet.Tables)
{
foreach(DataRow dr in dt.rows)
{
// activity
}
}

This is your logic , how to you want to iterate

Member hani 8-Apr-15 7:39am

rows.Add(row); after that i have to add table name along with data how to add table name and data at which loop ending? and shall i take another list ? iam confusing in this area.. i understand looping but i struck adding rows and datatable name..

[no name] 8-Apr-15 7:53am

Use modified solution , find function please

[no name] 8-Apr-15 8:06am

use DatasetToJson method that attach with this solution

Member hani 20-Apr-15 1:49am

by using this method how can i differentiate tables i.e., if i want particular tabled data, how can i find that table?

Member hani 20-Apr-15 2:11am

my data returns like:
[{"UserID":1,"User":"xxx","Ordering":"xx"},
{"UserID":2,"User":"xx","Ordering":"xx"},
{"UserID":3,"User":"xxx","Ordering":"xxx"}]
[{"id":13,"CustomerID":9480,"Customer":"1800FLOWER - GLOBALREPORTING","Primarycsrid":"17760","PrimaryCSR":"Minu","ImplicitSameBranchAccess":true,"azGroup":"0 - 9","IsLoggedOnUserCustomer":false}]

[no name] 20-Apr-15 3:22am

you can modify , according to your requirement ,

This is just showing conversion from Dataset to JSON,
it's your logic how to you this data and what manipulations you apply .

Member hani 27-Apr-15 2:37am

var arrCust =[{"Table":[ {"UserID":"1","User":"test","Ordering":""}, {"UserID":"6","User":"Moss","Ordering":"Moss"}, {"UserID":"16","User":"B","Ordering":"B"}, {"UserID":"1","User":"H","Ordering":"H"}]}];
how to access User in arrCust ?
iam trying to access User as arrCust.Table.User but ia unable to find out user value in json variable please help me..

[no name] 28-Apr-15 1:41am

it's totally depend on your logic , with JS you can use jsobject type array,
same you can change json object to any user defined type