StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Adding a parameter when populating combo box from BO

Adding a parameter when populating combo box from BO

Jason Seidell — Fri, 26 Oct 2007 10:22:18 GMT

I tried to search, and I couldn't find an answer to this question.

I have a table with various codesets that I want to use for populating combo boxes and also display in various reports

ie. Table - codesets

Codeset Value Description

Version 1234 Basic File version

Version 2345 Extended File version

DataType N Numeric

DataType S String

DataType T Time

I have created the CodeSetBO and created a FillCodeSet(CodeSet) on the BO like the following

Public Sub FillCodeSet(ByVal CodeSet As String)

Me.FillDataTable("SELECT * FROM CodeSets WHERE CodeSet = " & CodeSet & " ORDER BY Value")

End Sub

And then when I set the PopulationDataSourceSettings to call FillCodeSet and then pass the parameter (ie. Version or DataType) to load the combo box, but I cannot figure out how to allow the parameter through.

Here is the populating code from the form.designer.vb code

ListPopulationSettings1.MethodToExecute = "FillCodeSet;System.String"

As long as I leave the System.String it successfully calls FillCodeSet but the string is NOTHING. I have tried several variations of entering the parameter and it will fail before the sub is called with a value cannot be null error.

Any ideas??

Thanks,

Jason

RE: Adding a parameter when populating combo box from BO

Jason Seidell — Fri, 26 Oct 2007 10:22:18 GMT

Ok, thanks for pointing out the listPopulating event that worked, thanks!!!

RE: Adding a parameter when populating combo box from BO

Trent L. Taylor — Fri, 26 Oct 2007 10:08:45 GMT

You can either pass it over and manually call the Requery method...or better yet, handle the ListPopulating event of the combo box. That is the purpose of this event, it allows you to specify parms to a method that is being executed. You can refer to the docs for more detail. There is a nice step-by-step article showing you exactly how to do this:

Application Framework -> UI Layer -> Controls -> List Population