Code

Re: populate dropdown during OnLoadEvent

Greg Collins — Wed, 30 Aug 2006 20:16:32 GMT

So glad you got it working! Glad to have helped!

Keep up the good work!

Re: populate dropdown during OnLoadEvent

buki79 — Wed, 30 Aug 2006 10:13:42 GMT

Ok. I figured it out. I create a view in the database with the desired fields and select this view when I create a secondary datasource. So I can bind the e. g. concatenated fields to a field in the primary datasource.
Thanks for hints!

Re: populate dropdown during OnLoadEvent

buki79 — Tue, 29 Aug 2006 07:05:27 GMT

Ok. I understand. But how does the drop down know what value to display, when I use managed code to populate the dropdown.
For example, I bind a secondary datasource to the dropdown by the datasource wizard. I add an access database and if I look at the created sql it looks like

select [id],[course_name] from [courses] as [courses]

But now I want to use a more complex sql statement within my C# code.

"select c.course_name,c.id "
	+"from courses c, "
	+"     (select count(id) as part, courseID  as cID from course_participants group by courseID) d " 
	+"where c.participants >  d.part " 
	+"      and c.id = d.cID "
	+"group by c.course_name, c.id"

How does the dropdown know to be updated correctly? Or how does the sql have to look like in order to work? Do the columns have to be named the same way? And what do I do if I want to populate the dropdown by concatenating the retrieved values, e.g. course name and course id?

Re: populate dropdown during OnLoadEvent

Greg Collins — Tue, 22 Aug 2006 23:24:17 GMT

You don't bind the drop-down itself to the repeating element, you right-click your drop-down and choose Properties, and then set it up to be populated from that repeating list.

Re: populate dropdown during OnLoadEvent

buki79 — Tue, 22 Aug 2006 08:06:43 GMT

Hi,

maybe I get something wrong, but when I look at this secondary data source it is a repeating element. The dropdown list is not a repeating element, so I can't bind the dropdown list to the secondary data source.
When I bind the list entries of the dropdown (properties dialog) to the datasource, only an empty row and the first entry is shown when I open the form. Furthermore when I select the empty row the other empty disappears?
What am I missing?

Regards,

Buki

Re: populate dropdown during OnLoadEvent

Agni Jonnalagadda — Mon, 21 Aug 2006 19:12:55 GMT

Hi Buki,
Aren't you binding your dropdown do the "DataObject" that you are querying?
When you do that then it gets automatically updated in the dropdown. You dont need to call forceupdate().

populate dropdown during OnLoadEvent

buki79 — Fri, 18 Aug 2006 06:29:11 GMT

Hi,

I want to populate a dropdown list when the form is openend. The values should appear depending on a select from a database, e. g. only rooms which are not booked should appear in the list.
For this I use the DataObject and submit a query. But as I want to do this in the OnLoadEvent, I can't use forceupdate() to populate the dropdown list.
How do I get the result from the sql select into the dropdown list?

Thanks in advance.

Regards,

Buki