Hi,
Below code i am using to get the distinct row of coulmnn batch id
using Hibernate. Here when i am binding with Dropdown, complete row is
coming, i need to bind only Batch id coulmn.
config = new NHibernate.Cfg.Configuration();config.AddAssembly(typeof
(CSTS.Main.CashPosting).Assembly);
factory = config.BuildSessionFactory();
session = factory.OpenSession();
query = session.CreateQuery("FROM CashPosting");
IList<CSTS.Main.CashPosting> Trans = query.List<CSTS.Main.CashPosting>
();
ICriteria criteria = session.CreateCriteria(typeof(CashPosting));
criteria.SetProjection(Projections.Distinct(Projections.ProjectionList
()
.Add(Projections.Alias(Projections.Property("Batch_Id"),
"Batch_Id"))));
criteria.SetResultTransformer(new
NHibernate.Transform.AliasToBeanResultTransformer(typeof
(CashPosting)));
IList batchidList = criteria.List();
ddBatch_id.DataSource = batchidList;
ddBatch_id.DataBind();
How can we get only Batch id from list?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
