Hi,

I´ve read in the post below that Ed says about configure a CFP to shows.

http://forum.strataframe.net/Topic17056-7-1.aspx

I configured my CFP and implemented this code below, but BD does not show my field on list.

''' <summary>

''' NOME DO VENDEDOR CUSTOM PROPERTY

''' </summary>

''' <remarks></remarks>

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Nome do Vendedor"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

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

Get

Dim loCommand As New SqlClient.SqlCommand()

'-- Build the command

loCommand.CommandText = "SELECT ven_nome from tb_vendedor where ven_cod = @ven_cod"

'-- Create and set the parameters

loCommand.Parameters.Add("@ven_cod", SqlDbType.Int)

loCommand.Parameters("@ven_cod").Value = Me.ven_cod

'-- Execute the query and return the value

Return CType(Me.ExecuteScalar(loCommand), String)

End Get

End Property

Some help?

Edhy,

I will check my project.
Tel me.... Is my code correct?
I don´t wanna work with view, this is very hard work to manage..
And about the performance and we work with CFP?

I made a test with BD populate event, oh Gosh... so slow.....

tks

Hi Luiz,



I don't see any problem with your code.



Now keep in mind that CFP could be an slow solution when you are returning many records because of the Scalar method being called per each record/row.



In case of many records, a view will be easier to manage and much more faster. If you use the SF DDT you can create your view definition in DDT and use the BO with the view to get the table structure correct.



There are many other approaches you can use. Do a search in the forum using the word "slow" and you will find many threads.

Edhy Rijo

Luiz,



Did you override the GetCustomBindablePropertyDescriptors and add your new property to the array returned there? If you have not done that, it will not show up within any binding segment of the code.