I've created 3 sqlDataSources and defined their relationship in WHDS. I've set up my webgridDataSource=whds1DataMember = DataKeyField = The UltraGrid shows the correct number of rows but only one column that showsInfragistics.Web.USystem.Data.Data1
Am I missing something?
Just wanted to let you know that we have implemented that (automatic CRUDs for UltraWebGrid when bound to WHDS) and it will most probably be included in the official 2008.2 release (still not 100% sure about that, PM has the final say here).
If you want to take a look at what we have, just shoot me an email or private message, and I will send you a project demonstrating how this works.
Hello,
First of all, thanks for writing and for the sample you have sent. I was able to reproduce something similar to what you experience, although unfortunately I am not completely sure I get the whole scenario right and there could be some pieces missing. But starting from the following datasource (note that the syntax is a little bit different from the CTP (most notably that we have deprecated the Key property for DataViews and now use only IDs)
<ig:WebHierarchicalDataSource runat="server" ID="WebHierarchicalDataSource1"> <DataRelations> <ig:DataRelation ChildColumns="SubCategoryId" ChildDataViewID="Things_DefaultView" ParentColumns="Id" ParentDataViewID="SubCategories_DefaultView" /> </DataRelations> <DataViews> <ig:DataView ID="SubCategories_DefaultView" DataMember="DefaultView" DataSourceID="SubCategories" /> <ig:DataView ID="Things_DefaultView" DataMember="DefaultView" DataSourceID="Things" /> </DataViews> </ig:WebHierarchicalDataSource>
I was able to bind correctly to an asp:treeview control with the following
<asp:TreeView Runat="Server" ID="TreeView1" DataSourceID="WebHierarchicalDataSource1" ShowLines="True"> <DataBindings> <asp:TreeNodeBinding DataMember="SubCategories_DefaultView" TextField="Name" /> <asp:TreeNodeBinding DataMember="Things_DefaultView" TextField="Name" /> </DataBindings> </asp:TreeView>
But when I tried to bind directly to WebDataGrid from Aikido, I did have some problems doing so right away and ended up with the following syntax in order to make it work:
<ig:WebDataGrid runat="server" ID="WebDataGrid1" DataSourceID="WebHierarchicalDataSource1" AutoGenerateColumns="false"> <Columns> <ig:TemplateDataField Key="DataItem.ID"> <HeaderTemplate> ID </HeaderTemplate> <ItemTemplate> <%# Eval("DataItem.ID") %> </ItemTemplate> </ig:TemplateDataField> <ig:TemplateDataField Key="DataItem.Name"> <HeaderTemplate> Name </HeaderTemplate> <ItemTemplate> <%# Eval("DataItem.Name") %> </ItemTemplate> </ig:TemplateDataField> </Columns></ig:WebDataGrid>
Frankly speaking, at this point we have been targeting mainly pure hierarchical UI controls like classic ig:UltraWebTree / ig:UltraWebMenu and the Aikido version of ig:WebDataTree. While we do plan to provide great support for WHDS in WebDataTree, at this point we are at research phase. Now is the time to provide some feedback on what you would expect in terms of integration features - we are listening and will do out best to include all good suggestions in the next CTP release.
I have sent you a private message with my infragistics email account - if it is possible for you (and if you have the time), could you please send me a small subset of your project reproducing the issue? I will do my best to address any issues that are evident there and will send you an updates Aikido Assembly with the fixes, so you can continue exploring the product.
<cc1:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server"><DataViews><cc1:DataView runat="server" DataMember="DefaultView" DataSourceID="SqlDataSource1" Key="SqlDataSource1.DefaultView"></cc1:DataView><cc1:DataView runat="server" DataMember="DefaultView" DataSourceID="SqlDataSource2" Key="SqlDataSource2.DefaultView"></cc1:DataView><cc1:DataView runat="server" DataMember="DefaultView" DataSourceID="SqlDataSource3" Key="SqlDataSource3.DefaultView"></cc1:DataView></DataViews><DataRelations><cc1:DataRelation runat="server" ChildColumns="DomainID" ChildDataViewKey="SqlDataSource2.DefaultView" ParentColumns="DomainID" ParentDataViewKey="SqlDataSource1.DefaultView"></cc1:DataRelation><cc1:DataRelation runat="server" ChildColumns="AlbumID" ChildDataViewKey="SqlDataSource3.DefaultView" ParentColumns="AlbumID" ParentDataViewKey="SqlDataSource2.DefaultView"></cc1:DataRelation></DataRelations></cc1:WebHierarchicalDataSource>
George:
Can you post the markup generated by the WHDS? I just created a sample that uses 3 SQL DS's bound to the Customers, Orders and Order Details tables in Northwind and bound that to the WebGrid with no problem.
Devin