• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

Webservice Data

I am trying to publish using webservice along with Navision and there is a doc file stating each step on how attached.

Now my question is below is the code where I am going to parse an xml file using the streamreader object and on processing where exactly is the data going to go, into a Navision database or where...I just need to know the concept

namespace R_and_M_XMLReader
    using Cust;
    using Items;
    using SaleOrd;

    class Program
        public void ReadfromXML()
            if (!Directory.Exists(@"E:\Old_R&M_XML_files"))

            if (Directory.Exists(@"E:\R&M_XML files"))
                Item_Service itm_svc = new Item_Service();
                itm_svc.UseDefaultCredentials = true;
                itm_svc.Url = @"http://absvii.abs.com:7087/DynamicsNAVRnM/WS/R%20&%20%20M/Page/Item";

                DirectoryInfo Item_di = new DirectoryInfo(@"E:\R&M_XML files");
                FileInfo[] Item_files = Item_di.GetFiles(@"*.xml");
                foreach (FileInfo file in Item_files)
                    StreamReader Item_sr = new StreamReader(file.DirectoryName + @"\" + file.Name);
                    XmlDocument ItemXML = new XmlDocument();
                    Item itm;
                    XmlNodeList nodelist = ItemXML.SelectNodes("/Items/item");
                    foreach (XmlNode node in nodelist)
                        string itmnum = String.Empty;
                            itm = new Item();
                            itm.No = node["itemNumber"].InnerText;
                            itmnum = itm.No;
                            itm_svc.Create(ref itm);
                            itm.Item_Category_Code = node["productGroup"].InnerText;
                            itm.Product_Group_Code = node["productGroup2"].InnerText;
                            itm.Description = node["articleDescription"].ChildNodes[1].InnerText.Substring(0,30);
                            itm.Business_Product_Group = node["kernelProductGroup"].InnerText;
                            itm.Units_per_Parcel = decimal.Parse(node["packingUnit"].InnerText);
                            itm.Excise_Prod_Posting_Group = node["customsTariffNumber"].InnerText;
                            itm.Country_Region_of_Origin_Code = node["itemProductionCountry"].InnerText;
                            itm.Net_Weight = decimal.Parse(node["netWeight"].InnerText);
                            itm.Minimum_Order_Quantity = decimal.Parse(node["minimumOrderQuantity"].InnerText);
                            itm.Reordering_Policy = Reordering_Policy.Lot_for_Lot;
                            itm.Large_Description = node["articleDescription"].ChildNodes[1].InnerText;
                            itm_svc.Update(ref itm);
                            Console.WriteLine("Item Created Successfully");
                        catch (Exception ex)

static void Main(string[] args)
            Program pg = new Program();

Open in new window

  • 2
1 Solution
Rahul AgarwalTeam LeaderCommented:
they have items namespace which have properties and probably insert statements to insert/ update date directly to database.
They parse the XML the set the value of item namespace properties.
and after setting properties values they call itm_svc.update command to update data to database.
Moizsaif123Author Commented:
when im running this code and put a break point on this statement, it gives an error on this statement and raises an exeption, I have attached a screenshot showing the error..

itm_svc.Create(ref itm);
Moizsaif123Author Commented:
The Exception detail below....

System.Net.WebException was caught
  Message=The remote name could not be resolved: 'items'
       at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
       at System.Net.HttpWebRequest.GetRequestStream()
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at R_and_M_XMLReader.items.Item_Service.Create(Item& Item) in C:\Users\abs_sali\Documents\Visual Studio 2010\Projects\R and M XMLReader\R and M XMLReader\Web References\items\Reference.cs:line 278
       at R_and_M_XMLReader.Program.ReadfromXML() in C:\Users\abs_sali\Documents\Visual Studio 2010\Projects\R and M XMLReader\R and M XMLReader\Program.cs:line 82
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now