I have had problems in the past using the UltraWebGrid with LLBLGen EntityCollections. LLBLGen support is great and I've contacted them for help on this too. So hopefully someone will have an answer.
I am really looking for just a simple example to bind an LLBLGen Entity collection to a WebHierarchicalDataGrid.
Something like customers - orders - orderDetails.
If someone has done this and can provide me with an example, I would appreciate it.
Chad
Hello Chad,
Thank you for your feedback. I suggest a few valuable resources that will help you out to get started with WHDG (CRUD operations).
Ø Manual CRUD : http://community.infragistics.com/blogs/radoslav_minchev/archive/2010/12/18/manual-crud-webhierarchicaldatagrid.aspx
Ø Auto CRUD : http://help.infragistics.com/NetAdvantage/ASPNET/2010.3/CLR4.0/?page=WebHierarchicalDataGrid_Binding_to_Hierarchical_Data_Source.html / (If you enable EditingCore and CellEditing the grid will be able to persists all changes you make)
About the LLBLGen library I will create a sample using Northwind db and attached it here.
Thanks,
LLBLGen is not free, but it does have a trial. Ask one of the developers that have been around for a few years, they should definitely know what it is. There are some interesting threads regarding Infragistics in some of the older posts on their forums talking about how Infragistics controls are the ones that give the most problems when it comes to databinding. I've been down this path with Infragistics support before, and I was just hoping that the newer controls since I've upgraded would be easier to use.
Ok, at this point, we know I like LLBLGen. It makes the data access programming so much easier for me in my applications. But I would also like to try to have a nice interface as well. So I tossed LLBLGen aside and decided to use the samples to figure out how to accomplish my goal. I went with SqlDataSources, the Infragistics WebHierarchicalDataSource and the WebHierarchicalDataGrid to attempt a hierarchical (3 deep) data binding. I could not get it to work. I tried all sorts of different approaches, looked at all the samples, searched the forums with no luck to figure out how I am supposed to get this thing to add, edit, delete rows in the hierarchy. I was able to get it to view all levels of the hierarchy. And I was even able to get it to edit, but adding did not work as I would expect. I tried capturing events to see if I was supposed to catch something and manually add the row to my underlying datasource. No events were triggered.
I ended up deleting the whole screen and starting over using the UltraWebGrid. At least that grid has decent documentation. I tried following the CSOM documentation on the new grid, it wasn't very helpful.
Sometimes I will struggle learning a new tool simply because I don't understand the pattern in which it was designed. After learning how to use it, I realize it was just an error on my part. Reading threads like this make me feel better knowing it is not just me : http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=12433
Hi Chad,
Is the LLBLGen EntityCollections free? I'm not really familiar with this source. Is it a flat source or is it hierarchical. So long as it implements IEnumerable, the WHDG could bind to it with no problem. You'd just have to have the Bands set up with the correct data members and such. You could also try to set this up through a WHDS. If you're just having trouble with the setup, this should hopefully help you out. If you're actually getting an exception or something, please let us know so we can identify and fix it.
regards,
David Young