displaying nested anonymous type

Question

0.00/5 (No votes)

See more:

I would be grateful if you could help me to solve the problem. Im trying to display a nested anonymous type in a GridView control. But the GridView control displaying only OrderID and OrderDate fields (i.e. it doesn't display nested type).
I'm using the following code:

C#

protected void btn2_Click(object sender, EventArgs e)
                   {
                      var query = (from o in ctx2.Orders 
                                      select new 
                                      {o.OrderID, o.OrderDate,
                                         nest_anon = new {          
                                             o.Customer,
                                             o.ShipAddress,
                                              o.Status }});
 tb2.Text = (query as ObjectQuery).ToTraceString(); 
 gv2.DataSource=query;
 gv2.DataBind();

What should i fix in my code to display anonymous and nested anonymous type in my GridView? Thank you in advance.

Posted 30-Nov-11 7:54am

Mich_90

Updated 1-Dec-11 15:17pm

Eduard Lu

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 30-Nov-11 13:56pm

It's more or less clear except "display a type". What do you mean by that? Type name, fully-qualified type name, some reflected type meta-data, or perhaps some representation of the instance of the type (ToString? :-)? What's the purpose? What's your goal?
--SA

[no name] 1-Dec-11 21:17pm

EDIT: added "code" tag

2 solutions

Solution 1

I'm not really sure what you're trying to do, have you tried:

C#

gv2.DataSource = query.ToList();

Posted 30-Nov-11 15:16pm

Michael Dela Cuesta

Updated 30-Nov-11 15:18pm

v2

Comments

Mich_90 1-Dec-11 12:15pm

Yes Michael i tried to do this: gv2.DataSource = query.ToList();

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)

Michael Dela Cuesta · Accepted Answer · 2011-12-01T15:14:00

ok, now I get what you mean.

All you have to do is set the AutoGenerateColumns property of the gridview to false. Then apply a column templates. You need to edit your aspx on this one.

ASP.NET

<asp:GridView ID="grdMain" runat="server" AutoGenerateColumns="False">
  <columns>
    <asp:BoundField DataField="OrderID" HeaderText="OrderID" />
    <asp:BoundField DataField="OrderDate" HeaderText="OrderDate" />
    <asp:BoundField DataField="nest_anon" HeaderText="Nested Type" />
  </columns>
</asp:GridView>