or
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="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> I need to hide the filter icon, enable the AutoPostBackOnFilter and set the default filter function value.<telerik:RadGrid AutoGenerateColumns="false" ID="RadGrid1" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" PageSize="15" AllowPaging="True" runat="server" >
<MasterTableView >
<Columns>
<telerik:GridNumericColumn DataField="OrderID" HeaderText="OrderID" AutoPostBackOnFilter="true" CurrentFilterFunction="LessThanOrEqualTo" />
<telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" />
<telerik:GridDateTimeColumn DataField="OrderDate" HeaderText="OrderDate" AutoPostBackOnFilter="true" CurrentFilterFunction="LessThanOrEqualTo" />
</Columns>
</MasterTableView>
</telerik:RadGrid><asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM Orders" runat="server">
</asp:SqlDataSource><rad:RadGrid ID="myGrid" runat="server" AllowSorting="True" AutoGenerateColumns="false" AllowPaging="True" GridLines="Both" GroupingEnabled="true" AllowFilteringByColumn="true" EnableAJAX="True" EnableHeaderContextMenu="true" ShowGroupPanel="false" ShowFooter="True" PageSize="20" EnableHeaderContextFilterMenu="true" AllowMultiRowEdit="true" AllowMultiRowSelection="true" OnNeedDataSource="myGrid_NeedDataSource" OnDetailTableDataBind="myGrid_DetailedTableDataBind" OnItemDataBound="myGrid_OnItemDataBound" OnPreRender="myGrid_OnPreRender"> <ClientSettings EnableRowHoverStyle="true" Resizing-AllowColumnResize="True" AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnablePostBackOnRowClick="true"> <Selecting AllowRowSelect="True" /> <ClientEvents OnGridCreated="OnGridCreated" /> </ClientSettings>The problem here is , it doesnt show checkboxed for displaying/hiding columns.
Where as other pages are working fine.
Appriciate your help.

<asp:Panel ID="uxMessagePanel" Visible="false" runat="server" CssClass="message success"> <asp:Label ID="uxMessageLabel" runat="server" /></asp:Panel>RadButton uxDeleteContact = (RadButton)sender;GridNestedViewItem currentNestedRow = (GridNestedViewItem)uxDeleteContact.NamingContainer;GridDataItem currentRow = (GridDataItem)currentNestedRow.ParentItem; //some other code here //Show Success Message to User((Panel)(currentRow.Parent.Parent.Parent.Parent.FindControl("uxMessagePanel"))).Visible = true;((Label)(currentRow.Parent.Parent.Parent.Parent.FindControl("uxMessageLabel"))).Text = "Contact successfully deleted.";