This is a migrated thread and some comments may be shown as answers.

DetailedTable does not show after set dataformat in PreRender

2 Answers 108 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Wenting asked on 02 May 2012, 03:55 PM

screenshot-detaitview.png

Hi

I use detailedtable in radgrid. Everything goes well as screenshot shows. However, when I try to set dataformat of column in Grid, the detailedtable does not show anymore. It seems expand icon does trigger event DetailTableDataBind and detailedtable.datasource does has data. It confuses me that why the detailedtable disappears.

Can anyone help me? Thank you in advance.

here is my code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Control.UserRequest;

using Control.Global;

using Control.Position_C;

using Control.Salesman_C;

using Control.Depart_C;

using Model;

using Telerik.Web.UI;

using Control.Bill_C;

namespace ERP.SalesAnalysis

{

public partial class BillByCustMonth : Is_Login

{

private UserRequestController urc = null;

IList<Cust> custList = null;

IList<Dept> departList = null;

IList<Salesman> salesList = null;

static string digit = "";

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

urc = GlobalUserController.get_login_user_request_controller(Session["userID"].ToString());

string permitString = urc.getBillByCustMonthPermit();

LoadPosition();

LoadCustomerComboBox(urc);

LoadDepartment();

LoadSalesman();

setPermit(permitString, urc);

YearComboBox.SelectedValue = DateTime.Now.Year.ToString();

decimal p = SystemParamController.param.amt_point;

//decimal p = 2; for test

digit = "";

for (decimal i = 0; i < p; i++)

{

digit += "0";

}

if (digit != "")

{

digit = "{0:#,#." + digit + "}";

}

else

{

digit = "{0:#,#}";

}

private void LoadSalesman()

{

salesList = SalesmanController.getAllSalesmanList();

if (salesList.Count != 0)

for (int i = 0; i < salesList.Count; i++)

{

SalesmanComboBox1.Items.Add(new RadComboBoxItem(salesList[i].salesmanId.deptcode + "\t" + salesList[i].salesmanId.name, salesList[i].salesmanId.name));

SalesmanComboBox2.Items.Add(new RadComboBoxItem(salesList[i].salesmanId.deptcode + "\t" + salesList[i].salesmanId.name, salesList[i].salesmanId.name));

}

SalesmanComboBox1.ClearSelection();

SalesmanComboBox2.ClearSelection();

}

private void LoadDepartment()

{

departList = DepartController.getDepartList();

DepartComboBox1.DataSource = departList;

DepartComboBox1.DataTextField = "deptcode";

DepartComboBox1.DataValueField = "deptcode";

DepartComboBox1.DataBind();

DepartComboBox2.DataSource = departList;

DepartComboBox2.DataTextField = "deptcode";

DepartComboBox2.DataValueField = "deptcode";

DepartComboBox2.DataBind();

}

private void setPermit(string permitString, UserRequestController urc)

{

}

protected void LoadPosition()

{

PositionComboBox.DataSource = PositionController.getPositionList();

PositionComboBox.DataTextField = "p_code";

PositionComboBox.DataValueField = "p_code";

PositionComboBox.DataBind();

}

protected void LoadCustomerComboBox(UserRequestController urc)

{

custList = urc.getCustomerListByUser();

CustomerComboBox1.HighlightTemplatedItems = true;

CustomerComboBox1.DataSource = custList;

CustomerComboBox1.DataTextField = "c_code";

CustomerComboBox1.DataValueField = "c_code";

CustomerComboBox1.DataBind();

CustomerComboBox2.HighlightTemplatedItems = true;

CustomerComboBox2.DataSource = custList;

CustomerComboBox2.DataTextField = "c_code";

CustomerComboBox2.DataValueField = "c_code";

CustomerComboBox2.DataBind();

}

protected void BillGrid_PreRender(object sender, System.EventArgs e)

{

setFormat();

}

protected void setFormat()

{

string format = digit;

if (!StandardCurrency.Checked)

{

format = "{0:#,#.00}";

}

foreach (GridColumn column in BillGrid.Columns)

{

if (column.UniqueName == "Sales1" || column.UniqueName == "Sales2" || column.UniqueName == "Sales3" ||

column.UniqueName == "Sales4" || column.UniqueName == "Sales5" || column.UniqueName == "Sales6" ||

column.UniqueName == "Sales7" || column.UniqueName == "Sales8" || column.UniqueName == "Sales9" ||

column.UniqueName == "Sales10" || column.UniqueName == "Sales11" || column.UniqueName == "Sales12")

{

(column as GridBoundColumn).DataFormatString = format;

}

else if (column.UniqueName == "Sum" || column.UniqueName == "Avg")

{

(column as GridCalculatedColumn).DataFormatString = format;

}

BillGrid.Rebind();

}

protected void BillGrid_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

if (!e.IsFromDetailTable)

{

string year = YearComboBox.SelectedValue;

string position = PositionComboBox.SelectedValue;

string startDept = DepartComboBox1.SelectedValue;

string endDept = DepartComboBox2.SelectedValue;

string startSales = SalesmanComboBox1.SelectedValue;

string endSales = SalesmanComboBox2.SelectedValue;

string startCust = CustomerComboBox1.SelectedValue;

string endCust = CustomerComboBox2.SelectedValue;

bool standard = true;

if (!StandardCurrency.Checked)

{

standard = false;

}

BillGrid.DataSource = BillController.getBill(year, position, startDept, endDept, startSales, endSales, startCust, endCust, standard);

}

protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)

{

GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;

switch (e.DetailTableView.Name)

{

case "BillDetails":

{

string year = YearComboBox.SelectedValue;

string position = PositionComboBox.SelectedValue;

string startCust = CustomerComboBox1.SelectedValue;

string endCust = CustomerComboBox2.SelectedValue;

bool standard = true;

if (!StandardCurrency.Checked)

{

standard = false;

}

string salesman = dataItem.GetDataKeyValue("Salesman").ToString();

e.DetailTableView.DataSource = BillController.getBillBySaleman(year, position, salesman, startCust, endCust,standard);

//e.DetailTableView.Rebind();

break;

}

protected void SearchButton_Click(object sender, EventArgs e)

{

string year = YearComboBox.SelectedValue;

string position = PositionComboBox.SelectedValue;

string startDept = DepartComboBox1.SelectedValue;

string endDept = DepartComboBox2.SelectedValue;

string startSales = SalesmanComboBox1.SelectedValue;

string endSales = SalesmanComboBox2.SelectedValue;

string startCust = CustomerComboBox1.SelectedValue;

string endCust = CustomerComboBox2.SelectedValue;

bool standard = true;

if (!StandardCurrency.Checked) {

standard = false;

}

BillGrid.DataSource = BillController.getBill(year, position, startDept, endDept, startSales, endSales, startCust, endCust, standard);

BillGrid.Rebind();

setFormat();

}

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="BillByCustMonth.aspx.cs" Inherits="ERP.SalesAnalysis.BillByCustMonth" %>

<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.0.12.302, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="SearchButton">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="BillGrid" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<table width="100%">

<tr>

<td><asp:label id="PositionLabel" runat="server" Text="<%$ Resources:language,position%>"></asp:label></td>

<td>

<telerik:RadComboBox ID="PositionComboBox" Runat="server"

Width="150px" Height="150px">

<headertemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;">编码</td>

<td style="width:60px;">名称</td>

</tr>

</table>

</headertemplate>

<itemtemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;"><%# DataBinder.Eval(Container.DataItem, "p_code") %></td>

<td style="width:60px;"><%# DataBinder.Eval(Container.DataItem, "p_name") %></td>

</tr>

</table>

</itemtemplate>

</telerik:RadComboBox>

</td>

<td><asp:label id="Label1" runat="server" Text="<%$ Resources:language,department%>"></asp:label></td>

<td><telerik:RadComboBox ID="DepartComboBox1" Runat="server" Width="150px" AllowCustomText="True"

Height="150px"

>

<headertemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;">编码</td>

<td style="width:60px;">名称</td>

</tr>

</table>

</headertemplate>

<itemtemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;"><%# DataBinder.Eval(Container.DataItem, "deptcode")%></td>

<td style="width:60px;"><%# DataBinder.Eval(Container.DataItem, "deptname")%></td>

</tr>

</table>

</itemtemplate>

</telerik:RadComboBox>

</td>

<td><telerik:RadComboBox ID="DepartComboBox2" Runat="server" Width="150px" AllowCustomText="True" Height="150px">

<headertemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;">编码</td>

<td style="width:60px;">名称</td>

</tr>

</table>

</headertemplate>

<itemtemplate>

<table style="width:100px;">

<tr>

<td style="width:40px;"><%# DataBinder.Eval(Container.DataItem, "deptcode")%></td>

<td style="width:60px;"><%# DataBinder.Eval(Container.DataItem, "deptname")%></td>

</tr>

</table>

</itemtemplate>

</telerik:RadComboBox>

</td>

<td><asp:label id="Label2" runat="server" Text="<%$ Resources:language,salesman%>"></asp:label></td>

<td><telerik:RadComboBox ID="SalesmanComboBox1" Runat="server" Height="150px" Width="100px" AllowCustomText="True" >

</telerik:RadComboBox>

</td>

<td><telerik:RadComboBox ID="SalesmanComboBox2" Runat="server" Height="150px" Width="100px" AllowCustomText="True" >

</telerik:RadComboBox>

</td>

</tr>

<tr>

<td><asp:label id="Label3" runat="server" Text="<%$ Resources:language,year%>"></asp:label></td>

<td>

<telerik:RadComboBox ID="YearComboBox" Runat="server" Filter="StartsWith"

Width="100px" Height="150px" DataTextField="Text" DataValueField="Value"

DataSourceID="XmlDataSource1" >

</telerik:RadComboBox>

<asp:XmlDataSource ID="XmlDataSource1" runat="server"

DataFile="~/Common/year.xml"></asp:XmlDataSource>

</td>

<td><asp:label id="Label4" runat="server" Text="<%$ Resources:language,customerID%>"></asp:label></td>

<td><telerik:RadComboBox ID="CustomerComboBox1" Runat="server" AllowCustomText="True"

Height="250px" >

<headertemplate>

<table style="width:160px">

<tr>

<td style="width:60px;">编码</td>

<td style="width:100px;">名称</td>

</tr>

</table>

</headertemplate>

<itemtemplate>

<table style="width:160px">

<tr>

<td style="width:60px;"><%# DataBinder.Eval(Container.DataItem, "c_code") %></td>

<td style="width:100px;"><%# DataBinder.Eval(Container.DataItem, "c_abrname") %></td>

</tr>

</table>

</itemtemplate>

</telerik:RadComboBox></td>

<td><telerik:RadComboBox ID="CustomerComboBox2" Runat="server"

Height="250px" AllowCustomText="True" >

<headertemplate>

<table style="width:160px">

<tr>

<td style="width:60px;">编码</td>

<td style="width:100px;">名称</td>

</tr>

</table>

</headertemplate>

<itemtemplate>

<table style="width:160px">

<tr>

<td style="width:60px;"><%# DataBinder.Eval(Container.DataItem, "c_code") %></td>

<td style="width:100px;"><%# DataBinder.Eval(Container.DataItem, "c_abrname")%></td>

</tr>

</table>

</itemtemplate>

</telerik:RadComboBox></td>

<td><asp:label id="Label5" runat="server" Text="<%$ Resources:language,currency%>"></asp:label></td>

<td>

<asp:RadioButton ID="StandardCurrency" runat="server" Text="<%$ Resources:language,standardCurrency%>" Checked="true" GroupName="currency"></asp:RadioButton>

<asp:RadioButton ID="ForeCurrency" runat="server" Text="<%$ Resources:language,foreCurrency%>" GroupName="currency"></asp:RadioButton>

</td>

</tr>

<tr>

<td colspan="8" align="right">

<telerik:RadButton runat="server" ID="SearchButton" Text="<%$ Resources:language,search%>"

onclick="SearchButton_Click"></telerik:RadButton>

</td>

</tr>

</table>

<telerik:RadGrid ID="BillGrid" Width="100%" runat="server" Height="375px"

AllowPaging="true" AutoGenerateColumns="False" PageSize="10" AllowSorting="True"

OnNeedDataSource="BillGrid_NeedDataSource" OnPreRender="BillGrid_PreRender"

OnDetailTableDataBind="RadGrid1_DetailTableDataBind"

Skin="Office2010Blue" >

<MasterTableView Width="100%" AllowMultiColumnSorting="false" GroupLoadMode="Server" DataKeyNames="Salesman" ShowFooter="true" CssClass="number">

<DetailTables>

<telerik:GridTableView DataKeyNames="Salesman" Name="BillDetails" Width="100%" ShowFooter="false" ShowHeader="false" CssClass="number" >

<Columns>

<telerik:GridBoundColumn HeaderStyle-Width="80px" DataField="Blanck"></telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderStyle-Width="90px" DataField="Custcode"></telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderStyle-Width="90px" DataField="Custname"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales21" HeaderStyle-Width="80px" DataField="Sales1" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales22" HeaderStyle-Width="80px" DataField="Sales2" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales23" HeaderStyle-Width="80px" DataField="Sales3" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales24" HeaderStyle-Width="80px" DataField="Sales4" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales25" HeaderStyle-Width="80px" DataField="Sales5" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales26" HeaderStyle-Width="80px" DataField="Sales6" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales27" HeaderStyle-Width="80px" DataField="Sales7" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales28" HeaderStyle-Width="80px" DataField="Sales8" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales29" HeaderStyle-Width="80px" DataField="Sales9" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales210" HeaderStyle-Width="80px" DataField="Sales10" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales211" HeaderStyle-Width="80px" DataField="Sales11" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Sales212" HeaderStyle-Width="80px" DataField="Sales12" DataFormatString="{0:###,###.##}"></telerik:GridBoundColumn>

<telerik:GridCalculatedColumn UniqueName="Sum2" HeaderStyle-Width="80px" DataFields="Sales1,Sales2,Sales3,Sales4,Sales5,Sales6,Sales7,Sales8,Sales9,Sales10,Sales11,Sales12" Expression="{0}+{1}+{2}+{3}+{4}+{5}+{6}+{7}+{8}+{9}+{10}+{11}" DataFormatString="{0:###,###.##}"></telerik:GridCalculatedColumn>

<telerik:GridCalculatedColumn UniqueName="Avg2" HeaderStyle-Width="80px" DataFields="Sales1,Sales2,Sales3,Sales4,Sales5,Sales6,Sales7,Sales8,Sales9,Sales10,Sales11,Sales12" Expression="({0}+{1}+{2}+{3}+{4}+{5}+{6}+{7}+{8}+{9}+{10}+{11})/12" DataFormatString="{0:###,###.##}"></telerik:GridCalculatedColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn HeaderText="<%$ Resources:language,department%>" HeaderStyle-Width="80px" DataField="Depart"></telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="<%$ Resources:language,salesman%>" HeaderStyle-Width="80px" DataField="Salesman"></telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="<%$ Resources:language,customerId%>" HeaderStyle-Width="90px" DataField="Custcode"></telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="<%$ Resources:language,customerName%>" HeaderStyle-Width="90px" DataField="Custname"></telerik:GridBoundColumn>

<telerik:GridNumericColumn HeaderText="1月份" UniqueName="Sales1" HeaderStyle-Width="80px" DataField="Sales1" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="2月份" UniqueName="Sales2" HeaderStyle-Width="80px" DataField="Sales2" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="3月份" UniqueName="Sales3" HeaderStyle-Width="80px" DataField="Sales3" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="4月份" UniqueName="Sales4" HeaderStyle-Width="80px" DataField="Sales4" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="5月份" UniqueName="Sales5" HeaderStyle-Width="80px" DataField="Sales5" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="6月份" UniqueName="Sales6" HeaderStyle-Width="80px" DataField="Sales6" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="7月份" UniqueName="Sales7" HeaderStyle-Width="80px" DataField="Sales7" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="8月份" UniqueName="Sales8" HeaderStyle-Width="80px" DataField="Sales8" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="9月份" UniqueName="Sales9" HeaderStyle-Width="80px" DataField="Sales9" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="10月份" UniqueName="Sales10" HeaderStyle-Width="80px" DataField="Sales10" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="11月份" UniqueName="Sales11" HeaderStyle-Width="80px" DataField="Sales11" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridNumericColumn HeaderText="12月份" UniqueName="Sales12" HeaderStyle-Width="80px" DataField="Sales12" Aggregate="Sum"></telerik:GridNumericColumn>

<telerik:GridCalculatedColumn HeaderText="总计" UniqueName="Sum" HeaderStyle-Width="80px" DataFields="Sales1,Sales2,Sales3,Sales4,Sales5,Sales6,Sales7,Sales8,Sales9,Sales10,Sales11,Sales12" Expression="{0}+{1}+{2}+{3}+{4}+{5}+{6}+{7}+{8}+{9}+{10}+{11}" ></telerik:GridCalculatedColumn>

<telerik:GridCalculatedColumn HeaderText="月平均" UniqueName="Avg" HeaderStyle-Width="80px" DataFields="Sales1,Sales2,Sales3,Sales4,Sales5,Sales6,Sales7,Sales8,Sales9,Sales10,Sales11,Sales12" Expression="({0}+{1}+{2}+{3}+{4}+{5}+{6}+{7}+{8}+{9}+{10}+{11})/12"></telerik:GridCalculatedColumn>

</Columns>

</MasterTableView>

<ClientSettings>

<Selecting AllowRowSelect="True"></Selecting>

<Resizing AllowColumnResize="true" EnableRealTimeResize="True"/>

<Scrolling UseStaticHeaders="true" AllowScroll="true" />

</ClientSettings>

</telerik:RadGrid>

</asp:Content>

2 Answers, 1 is accepted

answered on 07 May 2012, 10:52 AM

Hello Wenting,

Could you please try removing the BillGrid.Rebind() line from the setFormat method and let me know if the issues still persists:

protected void setFormat()

{

string format = digit;

if (!StandardCurrency.Checked)

{

format = "{0:#,#.00}";

}

foreach (GridColumn column in BillGrid.Columns)

{

if (column.UniqueName == "Sales1" || column.UniqueName == "Sales2" || column.UniqueName == "Sales3" ||

column.UniqueName == "Sales4" || column.UniqueName == "Sales5" || column.UniqueName == "Sales6" ||

column.UniqueName == "Sales7" || column.UniqueName == "Sales8" || column.UniqueName == "Sales9" ||

column.UniqueName == "Sales10" || column.UniqueName == "Sales11" || column.UniqueName == "Sales12")

{

(column as GridBoundColumn).DataFormatString = format;

}

else if (column.UniqueName == "Sum" || column.UniqueName == "Avg")

{

(column as GridCalculatedColumn).DataFormatString = format;

}

//BillGrid.Rebind();

}

Looking forward for your reply.

All the best,
Radoslav
the Telerik team

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.