Hi All
I want to fetch values in various controls placed on the form through one query only.
Right now i am able to fetch values in grid through nhibernate through this code


//************************************
string query = "From Customer c where c.CompanyId like '" + companyId + "'";


ISession session = null;

try
{
session = LogInForm.NHSession;
this.grid1.DataSource = session.CreateQuery(query).List();
}
finally
{
session.Close();
}
//*************************************

and it is working fine. But i want that by firing one query only all the controls on form like textbox etx should be filled.

How can i do it...Pls help...

Regards,
Gaurav

Hi Gaurav!

You may use BindingSource on your form - and bing grids, listboxes, textboxes and other controls to it.

Or you may store retreived list in some other place (the most straightforward but not the best is field/propertry of this form itself) and initialize DataSource of your controls with this "stored" value, while retreiving data only once.

Hi Igor
Thanks for the reply. I would really appreciate if u could give me an example/code...
Well, I tried binding my controls to the class with this code

textBox1.DataBindings.Add(new Binding("Text",session.CreateQuery(query).List(),"ExampleApplication.Customer.CompanyName"));

but it throws me this error..
Child list for field ExampleApplication cannot be created

How to use DataBindings with control? I want that when i select some value in a combo box..a query should be fired and data should get filled in various controls on that form.
Please help...

Thanks

Gaurav