Hi José, Perhaps, but I was more hoping to leave it open enough with the direction of options programmatic, not how the data can be queried. I know how to get the data to look how I want, but binding that data to a user-interface is something else. Thus, I was pondering if the NH community had any experience with this type of situation, specifically?
The only idea I have myself is to query the data normally as a set of entity objects in memory. Then transform them programmatically into a DataTable with generated columns as per my earlier description. Then binding the DataTable to a datagrid with event handlers or a costly save operation that extracts the data from the DataTable. (i.e. Loads information into the entities then saves any changes.) It seems like the long way around? I could be wrong though. Thus, my question =) On Oct 2, 10:14 pm, José F. Romaniello <[email protected]> wrote: > You are mixing too much things here. > Nhibernate is not abou UI,but surely you can do something alike. > Your real question should be something like "i want to pivot these XYZ > data on db side, can nhibernate do this pivot query with a hql, > criteria or linq?“ > > The answer is no, you should use a db specific feature, you can use > sqlquery tag. > > 2010/10/2, shousper <[email protected]>: > > > > > > > Hi! > > > I've got a bit of a challenge.. > > Basically, I have sets of integers that are stored by date, by client. > > However, the interface needs to display the information similar to a > > crosstab/pivot query. > > So the user can edit the integer value per client per date easily. > > > Below is a cut down structure to give you the idea of the sets of > > data: > > > Client > > --id > > --name > > > Meals > > --clientID > > --date > > --count > > > So you end up with a date range query for say .. a quarter of the > > year? and you have headers: > > Client, 01/01/2010, 02/01/2010, 03/01/2010, ... etc. > > > And values like: > > Bob, 1, 1, 1 > > > My question is.. > > Is there any simple way of querying the data in this format and > > binding it to a DataGridView in WinForms _with_ updating? > > > I'm using FluentNH, .NET 4, C# if that at all helps. > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Enviado desde mi dispositivo móvil -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
