result of linq to xml in grid view of ASP.NET

Question

0.00/5 (No votes)

See more:

Hello

I have used linq to xml in ASP.NET like below, I like to have result in grid view in separate (2) columns:

1- author
2- title

but my result is in one column like below (Concatenated) for example like below:

“Don Box Essential .NET”

Best regards.

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        XElement x = XElement.Parse(
@"<books>
<book>
<author>Don Box</author>
<title>Essential .NET</title>
</book>
<book>
<author>Martin Fowler</author>
<title>Patterns of Enterprise Application Architecture</title>
</book>
</books>", LoadOptions.PreserveWhitespace);

        var titles = from book in x.Descendants("book")
                     select book;

        GridView1.DataSource = titles;
        
        GridView1.DataBind();

    }

}

Posted 11-Nov-11 20:18pm

masoud_sedighy

Updated 11-Nov-11 20:30pm

Not Active

v2

Add a Solution

Comments

[no name] 12-Nov-11 2:32am

FORMAT your code snippets when posting. There are instructions and I'm sure you have seen others do it, why do you ignore it?

masoud_sedighy 12-Nov-11 3:39am

sorry i did not about instruction so me just copied and pasted from microsoft word. in future i will take care about that.
also i like to know where i can find the instruction about format.
thanks in advanced.

3 solutions

Solution 1

It might be becaz of mismatch with GridView pattern. It would be easy if you share the data template of GridView1.

Posted 11-Nov-11 21:33pm

Ganesan Senthilvel

Comments

masoud_sedighy 12-Nov-11 8:33am

i just drag grid view1 to my default.aspx and make load page event like below, i do not know what changes i have to do in grid view.
thanks.

<asp:GridView ID="GridView1" runat="server">

Solution 3

Here you are getting a WhereSelectEnumerableIterator which can't be bound to the DatGrid

C#

var titles = from book in x.Descendants("book")
                     select book;

The DataGrid needs an IEnumerable which can be obtained with a ToList

C#

var titles = (from book in x.Descendants(&quot;book&quot;)
                     select book).ToList();

Of course you need the DataGrid to have the correct columns.

Posted 12-Nov-11 10:04am

Not Active

Updated 12-Nov-11 10:06am

v2

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)

Jigar Bagadai · Accepted Answer · 2011-11-11T21:39:00

you can use this...

var titles = from book in x.Descendants("book")
                    select book;

       DataTable _dt = new DataTable();
       _dt.Columns.Add("Title", typeof(string));
       _dt.Columns.Add("Autor", typeof(string));
       foreach (var b in titles)
       {
           DataRow _dr = _dt.NewRow();
           _dr["Title"] = b.Element("title").Value;
           _dr["Autor"] = b.Element("author").Value;
           _dt.Rows.Add(_dr);
       }

       GridView1.DataSource =_dt;

       GridView1.DataBind();