You are welcome Terry.

I am glad you found the problem.  And keep in mind that SF BOs are greatly flexible, extensible and powerful, little by little I found the logic used behind them very nice and worthy specially when working with several projects at the same time.

Edhy Rijo

I found the error that was causing the wrong data to load. Thank you again for your help.

I had my code just like yours but I was not getting the correct data. Therefore, I wanted to make sure I could do it the way you indicated and that I originally had,  but I must have something not quite right in my other code which is giving me the wrong data.  I did put a break on the code but I think I was looking for the BO that was being used and did not find it and did not pay any attention to the table being used.

Terry,

Your code is using the objbo.FillDataTable(cmd) instead of Me.FillDataTable(cmd).

Here is how it should be.  If you put a break in Me.FillDataTable(cmd) then see the value of cmd.Commandtext, notice that the correct table for the instance of the BO is used, remember "Generic", each BO is created for a specific table, hence the String.Format() code, so when you drop a BO and run the FillAllData() it will work just fine.  It is a good idea to take a look at the SF source code to learn how they use this generic logic for the FillBy... methods in the BO class.

    Public Overridable Sub FillAllData()
        Using cmd As New SqlCommand()
            cmd.CommandType = CommandType.Text
            cmd.CommandText = String.Format("Select * From {0}", Me.TableNameAndSchema)
 
            Me.FillDataTable(cmd)
        End Using
    End Sub

Edhy Rijo

OK but I think I am having trouble with it filling the correct BO since I am using the same Sub to fill multiple BO's but I will try again and see what happens. Thanks.

Hi Terry,

You don't need to pass any parameter nor the current BO.

Your current class, by inheriting the base BO it will know from which BO the method is executing, so when you reference Me in the base BO code it will be using whatever BO you have inherited from the base.

It may sound too easy, but it works and it is the way it is

Edhy Rijo