or
<telerik:RadGrid ID="rg_VL" runat="server" DataSourceID="SqlDataSourceCODPRO1" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="False" GridLines="None"> <MasterTableView AutoGenerateColumns="false" DataSourceID="SqlDataSourceCODPRO1" DataKeyNames="CODPRO1"> <DetailTables> <telerik:GridTableView DataKeyNames="CODPRO2" DataSourceID="SqlDataSourceCODPRO2" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="CODPRO1" MasterKeyField="CODPRO1" /> </ParentTableRelation> <DetailTables> <telerik:GridTableView DataKeyNames="CODPRO3" DataSourceID="SqlDataSourceCODPRO3" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="CODPRO2" MasterKeyField="CODPRO2" /> </ParentTableRelation> <DetailTables> <telerik:GridTableView DataKeyNames="CODPRO4" DataSourceID="SqlDataSourceCODPRO4" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="CODPRO3" MasterKeyField="CODPRO3" /> </ParentTableRelation> <DetailTables> <telerik:GridTableView DataKeyNames="CODPRO5" DataSourceID="SqlDataSourceCODPRO5" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="CODPRO4" MasterKeyField="CODPRO4" /> </ParentTableRelation> <Columns> <telerik:GridBoundColumn SortExpression="CODPRO5" HeaderText="CODPRO5" HeaderButtonType="TextButton" DataField="CODPRO5" UniqueName="CODPRO5"> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn SortExpression="CODPRO4" HeaderText="CODPRO4" HeaderButtonType="TextButton" DataField="CODPRO4" UniqueName="CODPRO4"> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn SortExpression="CODPRO3" HeaderText="CODPRO3" HeaderButtonType="TextButton" DataField="CODPRO3" UniqueName="CODPRO3"> </telerik:GridBoundColumn> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="CODPRO3"></telerik:GridSortExpression> </SortExpressions> </telerik:GridTableView> </DetailTables> <Columns> <%--<telerik:GridBoundColumn SortExpression="CODPRO2" HeaderText="CODPRO2" HeaderButtonType="TextButton" DataField="CODPRO2" UniqueName="CODPRO2"> </telerik:GridBoundColumn>--%> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="CODPRO2"></telerik:GridSortExpression> </SortExpressions> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn SortExpression="CODPRO1" HeaderText="CODPRO1" HeaderButtonType="TextButton" DataField="CODPRO1" UniqueName="CODPRO1"> </telerik:GridBoundColumn> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="CODPRO1"></telerik:GridSortExpression> </SortExpressions> </MasterTableView> </telerik:RadGrid><asp:SqlDataSource ID="SqlDataSourceCODPRO1" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>" ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO1 FROM VENTES_LACH_REG ORDER BY CODPRO1" runat="server"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSourceCODPRO2" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>" ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO2 FROM VENTES_LACH_REG Where CODPRO1 = :CODPRO1" runat="server"> <SelectParameters> <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string"> </asp:SessionParameter> </SelectParameters></asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSourceCODPRO3" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>" ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO3 FROM VENTES_LACH_REG CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2" runat="server"> <SelectParameters> <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string"> </asp:SessionParameter> </SelectParameters></asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSourceCODPRO4" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>" ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO4 FROM VENTES_LACH_REG WHERE CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2 AND CODPRO3 = :CODPRO3" runat="server"> <SelectParameters> <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO3" SessionField="CODPRO3" Type="string"> </asp:SessionParameter> </SelectParameters></asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSourceCODPRO5" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>" ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO5 FROM VENTES_LACH_REG WHERE CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2 AND CODPRO3 = :CODPRO3 AND CODPRO4 = :CODPRO4" runat="server"> <SelectParameters> <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO3" SessionField="CODPRO3" Type="string"> </asp:SessionParameter> <asp:SessionParameter Name="CODPRO4" SessionField="CODPRO4" Type="string"> </asp:SessionParameter> </SelectParameters></asp:SqlDataSource>private void dRepeater_ItemCloned(object sender, DataRepeaterItemEventArgs e){ RadMultiColumnComboBox multiCBSup = (RadMultiColumnComboBox)e.DataRepeaterItem.Controls["cbSup"]; dtSup = dtCategories.Select("id=1").CopyToDataTable().DefaultView.ToTable(true, "value", "text"); multiCBSup.DataSource = dtSup; //Category RadMultiColumnComboBox multiCBCat = (RadMultiColumnComboBox)e.DataRepeaterItem.Controls["cbCat"]; dtCat = dtCategories.Select("id=2").CopyToDataTable().DefaultView.ToTable(true, "supcat", "cat", "value", "text"); multiCBCat.DataSource = dtCat; multiCBCat.DisplayMember = "cat"; multiCBCat.ValueMember = "cat"; }This code should populate each row of controls with it's own data. So when I change combobox1 in row 1 I don't want to change combobox1 on every row.private void dRepeater_DrawItem(object sender, Microsoft.VisualBasic.PowerPacks.DataRepeaterItemEventArgs e){ DataRow dr = (DataRow)dtAct.Rows[e.DataRepeaterItem.ItemIndex]; RadMultiColumnComboBox multiCB = (RadMultiColumnComboBox)e.DataRepeaterItem.Controls.Find("cbSup", false)[0]; }
I have a gridView with a bunch of columns and a bottom summary row which also has a bunch of SUM columns.
One of my columns, "volume" has 2 decimal places but the summary row seems to be rounding the values therefore gives an incorrect value.
I have formatted the summary to show 2 decimal places, which is does but the SUM calculation is still incorrect.
To test this I added an export to excel function so that I could use Excel to double check the total SUM of the Volume column and this does show that the Grid summary is incorrect.
I know I must be missing something obvious but I cannot see it.
Thanks for your help.
Cheers
Shaun.