Linq using variable as column name in select new statement

Question

I have a LINQ query and as you can see I am trying to use variables as column names.

string first = "someColumnName1";
string sec = "someColumnName2";
string third = "someColumnName3";

var data = (from i in ctx.PlanskaKalkulacijas
            where i.PKid.Value == id
            select new { first = i.NP1, sec = i.NP2, third = i.NP3}
           ).OrderByDescending(m => m.Id)
            .ToList();

this code produce column names in gridview as first, sec and third but I need someColumnName1, someColumnName2, someColumnName3.

Any help ?

Community · Accepted Answer · 2017-05-23 12:16:07Z

3

Either rename columns in the gridview after you insert data or name properties of the anonymous type you create properly.

var data = (from i in ctx.PlanskaKalkulacijas 
            where i.PKid.Value == id 
            select new 
            { 
                someColumnName1 = i.NP1, 
                someColumnName2 = i.NP2, 
                someColumnName3 = i.NP3
            }).OrderByDescending(m => m.Id)
              .ToList();

If you don't know values at compile time, just rename it. To do that, follow this question here on SO.

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jan 10, 2014 at 15:20

Ondrej Janacek

12.6k14 gold badges62 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

RB. Over a year ago

I suspect that the question author does not actually know the column names at compile time. @zire - can you clarify if you know the column names at compile time?

Nezir Over a year ago

Yes RB, column names I am getting from db and those names will be different.

Ondrej Janacek Over a year ago

@zire Ok, than just rename headers.

Nezir Over a year ago

Thanks again Ondrej this works:protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[0].Text = "Date"; } }

Collectives™ on Stack Overflow

Linq using variable as column name in select new statement

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related