Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
[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;
         }

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
Posted
Updated 31-Mar-14 18:21pm
v2

 
Share this answer
 
Comments
[no name] 1-Apr-14 1:51am    
Please help i am not getting ...
Use the following namespace System.Web.Script.Serialization and JavaScript Serializer class
 
Share this answer
 
Comments
[no name] 1-Apr-14 1:51am    
Please help i am not getting ...
[no name] 1-Apr-14 2:55am    
After adding System.Web.Script.Serialization what i need to do ??

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900