Build a XMLstring using selected listitems

Question

4.50/5 (2 votes)

See more:

Hi ,
I have a checkboxlist with 38 listitems,table columns are "PerfCounter" "ID"
The way iam retrieving from the database is:

C#

DataTextField="PerfCounter"
DataValueField="ID"

I placed a lable in the form & if you select any listbox it will displays the corresponding value and the code behind is:

C#

protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)
{
    Label1.Text = string.Empty;

    foreach (ListItem listitem in CheckBoxList1.Items)
    {
        if (listitem.Selected)
            Label1.Text += listitem.Value + "<br />";
    }
}

Till now it is working fine.
Issue:I just want to build a string with the selected listitems like

XML

<Root><PC ID="1"/><PC ID="6"/><PC ID="12"/><PC ID="28"/></Root>

so that i can use that string as a parametr to my storedprocedure to design reports. Ex:

EXEC [Report].[usp_GetPermonCounterData] @ServerID = 543, @xmlDocument = '<Root><PC ID="1"/><PC ID="6"/><PC ID="12"/><PC ID="28"/></Root>'

Posted 5-Jun-12 3:55am

myansweris

Updated 5-Jun-12 5:20am

v4

Add a Solution

3 solutions

Solution 3

Use xlinq:

C#

var x = new XElement("Root",
    new XElement("PC", new XAttribute("ID", "1")),
    new XElement("PC", new XAttribute("ID", "6")),
    new XElement("PC", new XAttribute("ID", "12")),
    new XElement("PC", new XAttribute("ID", "28")));
//or
x.Add(new XElement("PC", new XAttribute("ID", "36")));
Console.WriteLine(x.ToString());

Posted 5-Jun-12 7:45am

Clifford Nelson

Comments

VJ Reddy 5-Jun-12 19:47pm

The OP wants to build the XML string from the selected items of CheckBoxList.
Here the literal values are used in building the XML string.
Even if only literal values are required by OP then there is no need of XElement as OP does not want to manipulate with XElement. Finally only string is required in which case
"<root><PC ID="1"/><PC ID="6"/><PC ID="12"/><PC ID="28"/>" will do.
Hence I have not voted.
How it is useful for the above question, can you please elaborate.

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)

**Zoltán Zörgő** · Accepted Answer · 2012-06-05T04:16:00

Solution 1

If you need to handle xml as string you could use something like this:

C#

protected string GetAsXMLString(CheckBoxList itemsource)
{
    StringBuilder sb = new StringBuilder("<root>");

    foreach (ListItem listitem in itemsource.Items)
    {
        if (listitem.Selected)
            sb.Append(String.Format("<PC ID=""{0}""/>", listitem.Value));
    }
    sb.Append("</root>")
    return sb.ToString();
}

Posted 5-Jun-12 4:16am

Zoltán Zörgő

Updated 5-Jun-12 4:28am

v4

Comments

myansweris 5-Jun-12 10:26am

Thankyou...

Zoltán Zörgő 5-Jun-12 10:27am

You are welcome...

Sandeep Mewara 5-Jun-12 10:31am

my 5!

VJ Reddy 5-Jun-12 11:27am

Good answer. 5!

Shahin Khorshidnia 5-Jun-12 12:46pm

Perfect + FiVe

Maciej Los 5-Jun-12 14:44pm

Good answer, my 5!

Zoltán Zörgő 5-Jun-12 14:46pm

Thank you all.

VJ Reddy · Accepted Answer · 2012-06-05T05:26:00

Solution 2

The Solution 1 given by Zoltán Zörgő is good.

If you want to use LINQ then the following query can be used to get parameter as an XML string

C#

string paramValue = CheckBoxList1.Items.OfType<ListItem>().Where (li =>
    li.Selected).Aggregate ("<Root>",(string agg, ListItem li) =>
    agg += string.Format(@"<PC ID=""{0}""/>",li.Value)) + "</Root>";

//Sample paramValue
//<Root><PC ID="1"/><PC ID="6"/></Root>

Posted 5-Jun-12 5:26am

VJ Reddy

Updated 5-Jun-12 7:04am

v4

Comments

Shahin Khorshidnia 5-Jun-12 12:48pm

Good Complementary My +1 (joking) a flawless FIVE :D

VJ Reddy 5-Jun-12 12:59pm

Thank you very much, Shahin :D

sjelen 5-Jun-12 13:03pm

Oh, the endless possibilities of LINQ extensions :) +5

VJ Reddy 5-Jun-12 13:04pm

Thank you, sjelen :)

Maciej Los 5-Jun-12 14:44pm

Good answer, my 5!

VJ Reddy 5-Jun-12 19:38pm

Thank you, losmac :)

Zoltán Zörgő 5-Jun-12 14:47pm

I also thanked about linq, but I gived up :) +5

VJ Reddy 5-Jun-12 19:41pm

Thank you, Zoltán :)

VJ Reddy 5-Jun-12 19:48pm

To the down voted member
Can you please give the reason for down voting and mention the improvement required, so that it is useful for me, OP and others who may visit this page.
Thank you :)