Dataset to desired format XML in webservice

Question

0.00/5 (No votes)

See more:

Hi,

I'm new to web service development, Currently we have web service that will return the stock of item from stores. We have 30 stores and it will return 30 times the result as dataset for a single item. The current format is as follows

stocklevel diffgr:id="StockLevel562" msdata:roworder="561" xmlns:msdata="#unknown" xmlns:diffgr="#unknown"

recordid 4672 /recordid

barcode 5606578926114 /barcode

stocklevel 2 /stocklevel

storecode StoreA /storecode

lastupdated 2013-02-04T10:07:36+00:00 /lastupdated

/stocklevel
Now i need to modify the function, so that it should return the stock from all 30 stores in a single call, so format needed is just like below:

HTML

stocklevel
            barcode 5606578926114 /barcode
stocklevel storecode=""StoreA"" lastupdated=""2013-02-04T10:07:36+00:00"" 2 /stocklevel
stocklevel storecode=""StoreB"" lastupdated=""2013-02-04T10:07:36+00:00"" 10 /stocklevel
stocklevel storecode=""StoreC"" lastupdated=""2013-02-04T10:07:36+00:00"" 6 /stocklevel

…etc…

/stocklevel

I don't know whether it can be achieved by formatting the dataset or XML. So any help would be great...

Thanks in Advance....

Anish

Posted 3-May-13 4:18am

Anish612

Updated 3-May-13 5:00am

v5

Add a Solution

Comments

CHill60 3-May-13 10:24am

You will need to post the code that produces the dataset

Kenneth Haugland 3-May-13 10:32am

Dont Dataset have a ToXML function?

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)

SARAVANAKUMAR.M · Answer 1 · 2013-09-05T21:27:00

Hi Anish,

Try the below code which may be helpful for u . :)

C#

string XMLName = FilePath + "Code_Proj.xml";
            using (FileStream fs = new FileStream(XMLName, FileMode.OpenOrCreate, FileAccess.Write))
            {
                using (StreamWriter sw = new StreamWriter(fs))
                {
                    sw.Write("<?xml version='1.0' encoding='UTF-8'?> \n" +
                             "<stocklevel>\n ");

                    DataView dv = new DataView(ds.Tables[0]);
                    System.Data.DataTable dt = dv.ToTable(true, "Barcode");

                    foreach (DataRow drv in dt.Rows)
                    {
                        string Barcode = drv["Barcode"].ToString();

                        DataRow[] drs = ds.Tables[0].Select("Barcode = '" + Barcode + "'");
                        sw.Write("<barcode>" + Barcode + "\n");
                        sw.Write("</barcode>\n");
                        foreach (DataRow drData in drs)
                        {
                            string Storecode = drData["storecode"].ToString();
                            string LastUpdatedDate = drData["lastupdated"].ToString();
                            string Level = drData["stocklevel"].ToString();
                            sw.Write("<stocklevel storecode='" + Storecode + "' lastupdated='" + LastUpdatedDate + "' " + Level + " /> \n");
                        }
                    }
                    sw.Write("</stocklevel>\n");
                    fs.Flush();
                }
            }

            GC.Collect();