Hi,

I'm new to nHibernate and have some questions to use it with .Net Winforms.

In my application I use to query data which works good. But I use some DataGridView controls which do not always display all properties of the loaded class. If I bind the returned IList to the control I see all columns of the table.
Can I filter the column list as I can do it in SQL's Select statement?
If I use there must be a object which contains the specified columns.

I use from datagrid which works so far and hides for example the id column. But is it possible to rename the columns. I have a database column "car" and want to replace it with some translated string. I don't see any way to do this with NHibernate, because I lose the object behind. In Sql I write "Select car as Auto from ...".

When the IList is bound to the control it is not possible to rename the columns any more. How can this be done without copying the IList to a new generated Datatable?


Thanks.

Hi,

i think the solution may go something like this?




But my Poco object has a foreign key. If I add this to a projection I get an NHibernate.AdoException. If I don't add it to the projection I don't get my special instance of the poco object. I just get an array of objects.

Any idea? Thanks.

Afaik, you can not rename the columns, but you can set a new header text anytime you want.

Personally, I woulcn't put the functionality for column naming and display in the data access layer. I can think of some other approches:

- define a template which contains names, display order, visibility, maybe format strings and apply that to the grid. This gives you the possibility to use different languages for naming (if you have to) or store the settings per user

- use attributes on the properties which define the display name and the visibility

Thanks for the reply.

If I understand you right, data binding to a grid makes no sense most times because normally I will not see all columns in the grid with their database column name.
My database is in english, the GUI should be in german. It's a small application so changing the language is not intended in the near future.

Afaik there is no template for columns in datagridview. Just for rows. I can create a datatable with the used columns and bind it to the grid but in this case I have to copy all data in a loop to the datatable. This is a big overhead and in this case I lose the object binding in the grid.

You can set AutoGenerateColumns to false and add the columns yourself (which is what we do and what I meant with column template). You also have to specify the "DataPropertyName" on the column. Then you can bind to that grid as if you use automatic column creation.

That's a working solution.

Thanks for your advice!