How fill values in parameters of questions?

Question

Title says all.

Case:

When Country Combobox changes selected item, to put Country ID in parameter of state combo. (to show only state of this country)

TKS.

 

Answer 1

This might get you started:

http://blogs.msdn.com/b/bethmassi/archive/2007/04/25/tips-on-related-data-binding-and-comboboxes.aspx

---

If you believe that I've answered your question, please remember to mark it as answered.

MicroApplications, Inc. -- Information Systems Integration and Custom Software Development

Answer 2

Yes, It´s my need. But, in LightSwitch.

Answer 3

You're right. Sorry about that. I just assumed anything blogged about by Beth was LightSwitch related, expecially since I included LightSwitch in my search. Sorry, Beth as well.

I remember there being a thread about this here, but I cannot find it.

Update: take a look at this: not quite the use case you're after, but some techniques used may spark your creativity:

http://blogs.msdn.com/b/lightswitch/archive/2010/09/08/how-do-i-filter-items-in-a-combobox-or-modal-window-picker-in-lightswitch-eric-erhardt.aspx

---

If you believe that I've answered your question, please remember to mark it as answered.

MicroApplications, Inc. -- Information Systems Integration and Custom Software Development

Answer 4

I was view this link. Buy There, not say how put value to parameters.

I have created the parametrized queries, but can´t use them.  :(

TKS

Edgard

PD: Sory, if my english is poor.

Answer 5

This is what I tried:

* Create Address, State, Country entities
* Create Country (1) to State (many) relationship
* Create Country (1) to Address (many) relationship
* Create State (1) to Address (many) relationshiop
* Create a parameterized query on State called StateByCountry (Where Country.Id = CountryParam)
* Create a screen on Address entity using New Data Screen template
* Change Country and State from Modal Window Picker to ComboBox
* Add StateByCountry query to the screen via "Add Data Item..." button
* Select the CountryParam query parameter, in the property sheet, set "Parameter Binding" to AddressProperty.Country.Id
* Select State ComboBox, in the property sheet, set the "Choices" property to use the StateByCountry query
* F5

Basically doing the steps described in this article, but with a query parameter with binding.
http://blogs.msdn.com/b/lightswitch/archive/2010/09/08/how-do-i-filter-items-in-a-combobox-or-modal-window-picker-in-lightswitch-eric-erhardt.aspx

Let me know if that works!

Answer 6

Thanks, Andy for another LightSwitch AHA moment!

---

If you believe that I've answered your question, please remember to mark it as answered.

MicroApplications, Inc. -- Information Systems Integration and Custom Software Development

Answer 7

The Solution:

1. Create a query with a parameter.
2. Create a screen of entity.
3. Add query to screen by clicking Add Data Item and choosing query.
4. Add property to screen by clicking Add Data Item and choosing local property
5. Create an union between the property and the query.
6. By code asing value on the property.

The problem.... Je!je!je!

When combobox change selection dont execute mycolection_selectionchanged() event.

Now, can anybody help with this please????

TKS!

Ed