C# NHibernate QueryOver select multiple Properties

Question

In my C# application I use NHibernate to get all rooms from my database table 'room'.

using (ISession pSession = NHibernateHelper.OpenSession())
            {
                IList<Room> roomList = pSession.QueryOver<Room>().
                                                Where(x => x.FloorID == 3).
                                                .List();
            }

The table 'room' and also my Mapping class (Room.cs) contains lets say the following properties:

roomID
hash
date
identifier

I have a DataGridView which should display my table entries from the database: the code is:

 roomDataGridView.DataSource = roomList;

That works fine so far. But now I decide that I dont want to show all the properties from the Room class, I only want to display

roomID
identifier

I tried the following:

roomDataGridView.DataSource = listOfRoomPropertiesForCurrentFloor.Select(x => new {x.Identifier, x.RoomID });

Unfortunately this does not work...nothing gets printed in my DataGridView.

Question: How can I store all properties from the room table in my room model BUT ONLY show TWO of the four properties in the DataGridView?

CR41G14 · Accepted Answer · 2012-12-04 13:43:30Z

2

Make sure your column names are defined in the DataGridView and create the object, basically assign the x.Identifier to the name "Identifier" so it can be picked up and call the ToList() function

roomDataGridView.DataSource = listOfRoomPropertiesForCurrentFloor
                              .Select(x => new {Identifier = x.Identifier, RoomID = x.RoomID }).ToList();

answered Dec 4, 2012 at 13:43

CR41G14

5,6245 gold badges47 silver badges68 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:12:11Z

1

Expecting that DataGridView attribute AutoCreateColumns should be set to true. There are already answers:

c# Hide a property in datagridview with datasource
Is there an Attribute I can use in my class to tell DataGridView not to create a column for it when bound to a List

Extract:

Mark the property which should not be displayed with an attribute [Browsable(false)]

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Dec 4, 2012 at 14:08

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

Collectives™ on Stack Overflow

C# NHibernate QueryOver select multiple Properties

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related