StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Binding an Enhanced List at runtime

RE: Binding an Enhanced List at runtime

Trent L. Taylor — Tue, 11 Mar 2008 13:08:52 GMT

[quote]How do you set up MethodToExecute if there is no parameter for the method being called?[/quote]

Is that a trick question? :) You just leave off the parameters:

[codesnippet]Me.grdHdr.PopulationDataSourceSettings.MethodToExecute = "FillDataTable;"[/codesnippet]

Binding an Enhanced List at runtime

Andria Jensen — Tue, 11 Mar 2008 13:08:52 GMT

I'm trying to use a generic form to maintain several different tables in the database. They all use the same form, but just different data sources. What is the best way to do this in code at run-time instead of setting it through the designer at design time? I figure I need to set some properties of the PopulationDataSourceSettings, but what I'm doing hasn't been working. Here's the code I've got so far to bind the grid, and maybe someone can tell me what I have missing.

Public Class frmSFTableBase
   Public Sub New(ByVal HdrBO As BusinessLayer, ByVal HdrValue As String)
      Me.BusinessObjects.Add(HdrBO)
      Me.grdHdr.PopulationDataSourceSettings.BusinessObjectType = "BBS.Biz.BizTypeBO"      Me.grdHdr.PopulationDataSourceSettings.ValueMember = HdrValue
      Me.grdHdr.PopulationDataSourceSettings.MethodToExecute = "FillDataTable()"
      Me.grdHdr.PopulationDataSourceSettings.DisplayFieldNames.Add(HdrValue)
      Me.grdHdr.PopulationDataSourceSettings.FormatColumns.Add("{0}", MicroFour.StrataFrame.UI.ListViewColumnPopulationType.FormattedString)
      Me.InitializeComponent()

End Sub

Private Sub grdHdr_ListPopulating(ByVal e As MicroFour.StrataFrame.UI.ListPopulatingEventArgs) Handles grdHdr.ListPopulating

e.Parameters(0).Value = "SELECT * FROM BizType"
End Sub

End Class

RE: Binding an Enhanced List at runtime

Geoff Hirst — Tue, 11 Mar 2008 12:13:46 GMT

Guys,

How do you set up MethodToExecute if there is no parameter for the method being called?

thanks

Geoff Hirst

RE: Binding an Enhanced List at runtime

Trent L. Taylor — Mon, 12 Jun 2006 16:35:09 GMT

Yes, this is what we normally do as well. Glad you got going.

RE: Binding an Enhanced List at runtime

Andria Jensen — Mon, 12 Jun 2006 13:08:51 GMT

Ok, it looks like you have to populate a ListViewPopulationSettings object and then set it the listview property. This now works for me:

PopSettings.BusinessObjectType = "BBS.Biz." & HdrValue & "BO"
PopSettings.DisplayFieldNames.Add(HdrValue)
PopSettings.FormatColumns.Add("{0}", MicroFour.StrataFrame.UI.ListViewColumnPopulationType.FormattedString)
PopSettings.FormatString = "{0}"
PopSettings.MethodToExecute = "FillDataTable;System.String"
PopSettings.ValueMember = HdrValue
Me.grdHdr.PopulationDataSourceSettings = PopSettings

RE: Binding an Enhanced List at runtime

Andria Jensen — Mon, 12 Jun 2006 11:28:21 GMT

Oh, and my grid is actually the Enhanced List control from the DevX wrapper classes. Forgot to say that I think.

RE: Binding an Enhanced List at runtime

Andria Jensen — Mon, 12 Jun 2006 11:24:46 GMT

Ok, I now have this:

Me.grdHdr.PopulationDataSourceSettings.BusinessObjectType = "BBS.Biz." & HdrValue & "BO"
Me.grdHdr.PopulationDataSourceSettings.DisplayFieldNames.AddRange(New String() {HdrValue})
Me.grdHdr.PopulationDataSourceSettings.FormatColumns.Add("{0}", MicroFour.StrataFrame.UI.ListViewColumnPopulationType.FormattedString)
Me.grdHdr.PopulationDataSourceSettings.FormatString = "{0}"
Me.grdHdr.PopulationDataSourceSettings.MethodToExecute = "FillDataTable;System.String"
Me.grdHdr.PopulationDataSourceSettings.ValueMember = HdrValue

But on the first line it gives me an exception and the message on Me.grdHdr is "Object cannot be null". It looks like for some reason my grid is Nothing, but I created it on the form at design time so what else do I need to do to have an instance of it?

RE: Binding an Enhanced List at runtime

StrataFrame Team — Mon, 12 Jun 2006 10:46:32 GMT

You can set the properties of the EnhancedList at runtime, but you would probably be best served to create PopulationDataSourceSettings at design-time and then copying the code from the InitializeComponent method. You're missing a few things when you're configuring them at runtime.

The MethodToExecute is a semi-colon-separated list of the method name and parameters... in this case, it would be "FillDataTable;System.String". When we use the same list and populate it with several different data sets, we will set the PopulationDataSourceSettings manually within the code. Other than that, your ListPopulating method is correct, but you'll need to call the Requery() method whenever you want to repopulate the list.