StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » I want to be able to show a field from a joined table on the BrowseDialog listview.

I want to be able to show a field from a joined table on the BrowseDialog listview.

Bill Spack — Tue, 21 Oct 2008 11:01:40 GMT

Back ground: I have 2 tables CD and Artist. CD has an Artist_FK that joins the Artist table. I want to show the name of the artist from the Artist table, in the search result of the browsedialog instead of the foreign key. I have setup a custom field and it shows in the drop down of the browsedialog browseresultslayout.

When I click the search on the browsedialog I get an error. Artist is not recognized. When I walk through the debug code I see the browsedialog creates it's own fill method to return the results instead of using my fill method that contains the join. Is there a way to specify what fill method to use or a way to include my joined field?

thanks

Bill

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Edhy Rijo — Tue, 21 Oct 2008 11:01:40 GMT

Hi Bill,

Glad it work for you, but keep in mind that this method will do a trip to the database to get the Artist Name value to be shown in the listview, this is acceptable in most cases if your search in the BD (Browser Dialog) will not return many records, but if that is the case, there are many alternate methods like Trent and Ivan said, in which you can use either use an Scalar method to just return the Artist Name field or to create a temporary BO in the BD with all the Artist Name and use the BO.SeektoPrimaryKey(Artist_FK) to get its name in the RowPopulation event.

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Ivan George Borges — Tue, 21 Oct 2008 09:59:13 GMT

Great you got it goind! :cool:

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Bill Spack — Tue, 21 Oct 2008 09:42:55 GMT

I really appreciate the quick reply from the group.

I ended up using Edhy's sample to resolve my issue. Works great :D:D

Thank you

Bill

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Ivan George Borges — Tue, 21 Oct 2008 09:22:45 GMT

Oops, it looks like it took me too long to write the post... :D

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Bill Spack — Tue, 21 Oct 2008 09:22:35 GMT

Sorry about that. I'm refering to the results listview in the browse dialog.

PopulateThroughEvent method sounds like the right one for me. I want to see the artist name in the listview not an info panel. I will just need to make a call to the retrieve the artist name based on the artist_FK on the current row right?

Thanks

Bill

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Ivan George Borges — Tue, 21 Oct 2008 09:21:53 GMT

Hi Bill.

While setting the BrowseResultsDialog, by the time you are adding your foreign key column to be dislplayed, have a look at the Population Type, choose PopulatedThroughEvent.

Then, go to your BrowseDialog Events and add an event handler for the RowPopulating.

In it, you can deal with sending the appropriate content for the BrowseDialog results column, something like this:

[codesnippet]

    Private Sub MyBrowseDialog_RowPopulating(ByVal e As MicroFour.StrataFrame.UI.Windows.Forms.RowPopulatingEventArgs) Handles MyBrowseDialog.RowPopulating
        '-- you can use whatever methods suit you better to get the values you need
        '-- you could create a method on your BO with a ExecuteScalar method to bring back only the information needed

        '-- establish locals
        Dim loBO As New MyBO
        loBO.FillByPrimaryKey(MyOtherBO.MyForeignKey)

        '-- set the contents
        With CType(e.BusinessObject, MyBO)
            e.Values(0).DisplayValue = loBO.MyField
        End With
    End Sub
[/codesnippet]

Hope it helps.

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Edhy Rijo — Tue, 21 Oct 2008 09:21:13 GMT

Hi Bill,

I understand that you want to show the name of the Artist in the Browse Dialog Result listview instead of the Artist_FK value. This is what you need to do:

In the CD business object (BO) you would create a Custom Field Property (CFP - look in the help file for a sample) named ArtistName or something like that. This CFP will use the Artist_FK value to search the artist record and return the Artist Name for that property, it would loook like this:

[codesnippet][code]

''' <summary>

''' This property will return the Artist Name

''' </summary>

''' <remarks></remarks>

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("ArtistName"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

Public ReadOnly Property [ArtistName]() As System.String

Get

Dim loBusinessObject As New ArtistBO

loBusinessObject.FillByPrimaryKey(Me.Artist_FK)

If loBusinessObject.Count = 1 Then

Return loBusinessObject.ArtistName

Else

Return String.Empty

End If

' Release the Business Object

loBusinessObject.Dispose()

End Get

End Property

[/code][/codesnippet]

Then, all you need to do is used this property ArtistName instead of the Artist_FK in your Browser Dialog "BrowseResultLayout" fields.

RE: I want to be able to show a field from a joined table on the BrowseDialog listview.

Trent L. Taylor — Tue, 21 Oct 2008 09:10:43 GMT

Well, there are a couple of things here. First of all, you didn't really mention if you were referring to the search fields or the results. Depending on this you would go two different directions.

If you are referring to the Sarch Fields, then you can handle the Searching event of the browse dialog to maniulate the raw WHERE clause of the query. Now redirecting to a join will be more difficult since it is another table. So you may want to create a view to query that has the join done on the server side which would then make this easier without the need to managing the Searching event.

If you are referring to the results, then you can define the column as PopulateThroughEvent and call a scalar method to populate the value or use a browse information panel.

So there are a lot of different options here, so depending on what you are trying to accomplish this should give you some ideas.