我将如何将Xml数据转换为Json [英] How Shall I Convert Xml Data To Json

问题描述

[WebMethod]
     public string InitBPMobile(string strStaffCode)
     {

         string strXML = "";

         strXML += "<bp>" + Environment.NewLine;

         #region Classes
         string strClassQuery = "";

         string strUserQuery = "SELECT * FROM usersmaster WHERE userCode IN (SELECT userCode FROM staff WHERE staffCode ='{0}' )";
         strUserQuery = string.Format(strUserQuery, strStaffCode);
         DataTable dtUser = _dalObj.getSqlQuery(strUserQuery);

         string _userName = "", _userPwd = "";

         if (dtUser.Rows.Count > 0)
         {
             _userName = dtUser.Rows[0]["username"].ToString();
             _userPwd = dtUser.Rows[0]["password"].ToString();

         }


         strClassQuery = "SELECT DISTINCT ClassCode, (SELECT ClassName FROM classmaster innr WHERE innr.ClassCode = v.ClassCode) ClassName FROM v_staffclass v WHERE staffCode = '{0}' ORDER BY ClassCode";
         strClassQuery = string.Format(strClassQuery, strStaffCode);
         string strClasses = "";
         DataTable dtClass = _dalObj.getSqlQuery(strClassQuery);
         if (dtClass.Rows.Count > 0)
         {
             strXML += "<username>" + _userName + "</username><password>" + _userPwd + "</password>" + Environment.NewLine;
             strXML += "<classes>" + Environment.NewLine;
             foreach (DataRow dr in dtClass.Rows)
             {
                 if (strClasses == "")
                     strClasses = "'" + dr["ClassCode"].ToString() + "'";
                 else
                     strClasses += ",'" + dr["ClassCode"].ToString() + "'";

                 strXML += "<class>" + Environment.NewLine;
                 strXML += "<classcode>" + dr["ClassCode"].ToString() + "</classcode>" + Environment.NewLine;
                 strXML += "<classname>" + dr["ClassName"].ToString() + "</classname>" + Environment.NewLine;
                 strXML += "</class>" + Environment.NewLine;
             }
             strXML += "</classes>" + Environment.NewLine;
         }
         else
         {
             strXML += "<result>Invalid Staff Code</result>" + Environment.NewLine;
             strXML += "</bp>" + Environment.NewLine;
             return strXML;
         }

来自此代码的
我在strXML中获取XML数据，这是一个现在使用此字符串的字符串我需要将xml转换为JSON请help

from this code i am getting XML data in strXML which is a string now using this string i need to convert xml to JSON please help

推荐答案

参考：如何在c＃中将字符串xml转换为json [ ^ ]

使用以下命名空间System.Web.Script.Serialization和JavaScript Serializer类

Use the following namespace System.Web.Script.Serialization and JavaScript Serializer class

使用此链接可以提供帮助

http://matijabozicevic.com/blog/csharp-net-development/csharp-s erialize-object-to-json-format-using-javascriptserialization [ ^ ]

Use this link it can help
http://matijabozicevic.com/blog/csharp-net-development/csharp-serialize-object-to-json-format-using-javascriptserialization[^]

这篇关于我将如何将Xml数据转换为Json的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！