Fill method with count fields


Author
Message
Keith Chisarik
Keith Chisarik
StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
I have a fill method that creates a count field, it is "filling" correctly. I need to know how to use the fill in the SF Listview please.



In the past I have used CopyDataFrom almost exclusively but that isn't working here due to the dynamic field. I tried setting the MethodToExecute to my customer Fill but I dont know how to set the fields/column values. I imagine I will set to 'PopulatedThroughEvent" but I dont know what to put in the RowPopulating method.



Also, after I get this working I will need to be able to have columns that are calculated from both other columns in the listview row and BO field values, I think i can just add blank columns with type PopulatedThroughEvent? Am I way off base here?



My fill SQL:

loCommand.CommandText = "select distinct(rent_itemcode), count(rent_itemcode) as rent_itemcount from rentitems where rent_ordnum = @param1 and rent_itemcode <> ':MISC' AND rent_usesbarcode = 1 group by rent_itemcode"

Keith Chisarik
Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Have you tried passing over the CurrentDataTable rather than the whole BO.  There is an overload to accept a DataTable instead of a BusinessLayerBase.  This is "ignorant" of the fields and should move all of the columns.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search