In the designer there'e no problem., everything works Ok.
In my program i would like to this this dynamically.
I'v the tracing below but cannot see what's wrong.
Hope someone sees what I'm doing wrong
Dim WithEvents webGrid As UltraWebGrid
Dim WithEvents band As UltraGridBand
Dim WithEvents llobjDs As SD.LLBLGen.Pro.ORMSupportClasses.LLBLGenProDataSource
Dim WithEvents boundColumn As UltraGridColumn
webGrid = New UltraWebGrid
Me.Form.Controls.Add(webGrid)
llobjDs = New SD.LLBLGen.Pro.ORMSupportClasses.LLBLGenProDataSource
llobjDs.CacheLocation = DataSourceCacheLocation.Session
llobjDs.DataContainerType = DataSourceDataContainerType.EntityCollection
llobjDs.EnablePaging = True
llobjDs.LivePersistence = True
llobjDs.EntityCollectionTypeName = "Cheetah.NET.DAL.CollectionClasses.ClubCollection, EricaDAL"
webGrid.DataSourceID = llobjDs.ID
band = New UltraGridBand
band.Key = "Band 0"
band.AddNewRow.Visible = AddNewRowVisible.NotSet
band.AddNewRow.View = AddNewRowView.NotSet
band.FilterOptions.AllString = ""
band.FilterOptions.EmptyString = ""
band.FilterOptions.NonEmptyString = ""
band.FilterOptions.FilterDropDownStyle.BackColor = Drawing.Color.White
band.FilterOptions.FilterDropDownStyle.BorderColor = Drawing.Color.Silver
band.FilterOptions.FilterDropDownStyle.BorderStyle = BorderStyle.Solid
band.FilterOptions.FilterDropDownStyle.BorderWidth = Unit.Pixel(1)
band.FilterOptions.FilterDropDownStyle.CustomRules = "overflow:auto;"
band.FilterOptions.FilterDropDownStyle.Font.Names = New String() {"Verdana,Arial,Helvetica,sans-serif"}
band.FilterOptions.FilterDropDownStyle.Font.Size = FontUnit.Point(11)
band.FilterOptions.FilterDropDownStyle.Width = Unit.Pixel(200)
band.FilterOptions.FilterDropDownStyle.Padding.Left = Unit.Pixel(2)
band.FilterOptions.FilterHighlightRowStyle.ForeColor = Drawing.Color.White
boundColumn = New UltraGridColumn
boundColumn.BaseColumnName = "clubId"
boundColumn.IsBound = True
boundColumn.Header.Caption = "Id"
band.Columns.Add(boundColumn)
boundColumn = New UltraGridColumn
boundColumn.BaseColumnName = "Name"
boundColumn.IsBound = True
boundColumn.Header.Caption = "Naam"
band.Columns.Add(boundColumn)
webGrid.DataBind()
-tracing
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.FetchPrefetchPath
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformFetchEntityAction
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Enter: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.PerformFetchEntityAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.FetchPrefetchPath
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformFetchEntityAction
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Enter: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.PerformFetchEntityAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.FetchPrefetchPath
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformFetchEntityAction
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Enter: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.PerformFetchEntityAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.FetchPrefetchPath
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformFetchEntityAction
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Enter: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.PerformFetchEntityAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.FetchPrefetchPath
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformGetMultiAction
Method Enter: CreatePagingSelectDQ
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Generated Sql query:
Query: SELECT [Erica].[dbo].[Event].[EventId], [Erica].[dbo].[Event].[ClubId], [Erica].[dbo].[Event].[IsMatch], [Erica].[dbo].[Event].[IsHomeMatch], [Erica].[dbo].[Event].[CompetitionId], [Erica].[dbo].[Event].[HomeTeamId], [Erica].[dbo].[Event].[VisitorsTeamId], [Erica].[dbo].[Event].[LocationId], [Erica].[dbo].[Event].[StartTime], [Erica].[dbo].[Event].[EndTime], [Erica].[dbo].[Event].[IsWholeDay], [Erica].[dbo].[Event].[Description], [Erica].[dbo].[Event].[ShortDescription], [Erica].[dbo].[Event].[MatchId], [Erica].[dbo].[Event].[RecurrenceId], [Erica].[dbo].[Event].[IsClosed], [Erica].[dbo].[Event].[Created], [Erica].[dbo].[Event].[CreatedById] FROM [Erica].[dbo].[Event]
Method Exit: CreateSelectDQ
Method Exit: CreatePagingSelectDQ: no paging.
Method Enter: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.ExecuteMultiRowRetrievalQuery
Method Exit: DaoBase.PerformGetMultiAction
Method Enter: DaoBase.PerformFetchEntityAction
Method Enter: CreateSelectDQ
Method Enter: CreateSelectDQ
Generated Sql query:
Query: SELECT [Erica].[dbo].[Location].[LocationId], [Erica].[dbo].[Location].[Name], [Erica].[dbo].[Location].[RouteDescription], [Erica].[dbo].[Location].[IsActive], [Erica].[dbo].[Location].[VisitAddressId], [Erica].[dbo].[Location].[PhoneNumber], [Erica].[dbo].[Location].[Email], [Erica].[dbo].[Location].[Url]FROM [Erica].[dbo].[Location] WHERE ( [Erica].[dbo].[Location].[LocationId] = @LocationId1)
Parameter: @LocationId1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 1.
Method Exit: CreateSelectDQ
Method Enter: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.ExecuteSingleRowRetrievalQuery
Method Exit: DaoBase.PerformFetchEntityAction