Anybody? On Oct 2, 10:58 pm, shousper <[email protected]> wrote: > 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.
