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.