My WHDG uses a natural key (varchar)as the pk and some pk data have spaces in them ( e.g. "Product Line A").The related hierarchical child product data use int surrogate keys. When I attempt to expand rows where the pk has a space in it, I get the following pop-up error: (Rows with no space expand normally.
<ig:WebHierarchicalDataGrid ID="hdgPrdln" runat="server" Height="350px" Width="640px" AutoGenerateBands="False" AutoGenerateColumns="False" DataKeyFields="IproPrdlnNM" DataMember="odsPrdln_DefaultView" DataSourceID="hdsPrdln" Key="odsPrdln_DefaultView"> <ClientEvents DoubleClick="hdgPrdln_DoubleClickPostBack" /> <Columns> <ig:BoundDataField Hidden="false" DataFieldName="IproPrdlnNM" Key="IproPrdlnNM" > <Header Text="Product Line" /> </ig:BoundDataField> </Columns> <Bands> <ig:Band AutoGenerateColumns="false" DataMember="odsPrd_DefaultView" Key="odsPrd_DefaultView" DataKeyFields="SrcSysPrdIDKey"> <Columns> <ig:BoundDataField Hidden="false" Width="30px" DataFieldName="SrcSysPrdIDKey" Key="SrcSysPrdIDKey"> <Header Text="ID" /> </ig:BoundDataField> <ig:BoundDataField Hidden="false" DataFieldName="SrcSysPrdNM" Key="SrcSysPrdNM"> <Header Text="Product Name" /> </ig:BoundDataField> <ig:BoundDataField Hidden="false" DataFieldName="SrcSysNM" Key="SrcSysNM"> <Header Text="Source System" /> </ig:BoundDataField> <ig:BoundDataField Hidden="false" DataFieldName="SrcSysUniqID" Key="SrcSysUniqID"> <Header Text="Unique ID" /> </ig:BoundDataField> </Columns> </ig:Band> </Bands> <Behaviors> <ig:Activation> </ig:Activation> <ig:Selection CellClickAction="Row" RowSelectType="Single"> </ig:Selection> <ig:EditingCore AutoCRUD="False"> <Behaviors> </Behaviors> </ig:EditingCore> </Behaviors> </ig:WebHierarchicalDataGrid>
<ig:WebHierarchicalDataSource ID="hdsPrdln" runat="server"> <DataViews> <ig:DataView ID="odsPrdln_DefaultView" DataMember="DefaultView" DataSourceID="odsPrdln" /> <ig:DataView ID="odsPrd_DefaultView" DataMember="DefaultView" DataSourceID="odsPrd" /> </DataViews> <DataRelations> <ig:DataRelation ChildColumns="IproPrdlnNM" ChildDataViewID="odsPrd_DefaultView" ParentColumns="IproPrdlnNM" ParentDataViewID="odsPrdln_DefaultView" /> </DataRelations> </ig:WebHierarchicalDataSource> <asp:ObjectDataSource ID="odsPrdln" runat="server" SelectMethod="GetMultipleAsObject" TypeName="ITSMR_Data.IproPrdlnClass"></asp:ObjectDataSource> <asp:ObjectDataSource ID="odsPrd" runat="server" SelectMethod="GetMultipleAsObject" TypeName="ITSMR_Data.PrdPrdlnHierarchyROClass"></asp:ObjectDataSource>
Not sure what I may be missing. Thanks for your help!
Jon
Hello Jon,
I am just checking about the progress of this issue.
Let us know if you need further assistance regarding this.