bradley baker
asked on 11 Nov 2009, 10:38 PM
Im trying to break down my grid in mutiple datasets for easy sorting and so I dont overload the client with too much data. So I have a button and in the button I change the SQL and Rebind the data and it displays correctly in the grid. However if you then goto filter etc it repull in the original binding information.
This works except when I got filter then it goes back to the original select statment.
This works except when I got filter then it goes back to the original select statment.
| Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES, " & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1, DRSU2, " & _ |
| "DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12, DRM1, DRM2, DRM3, DRM4, DRM5, DRM6, DRM7, DRM8, DRM9, DRM10, " & _ |
| "DRM11, DRM12, DRL1, DRL2, DRL3, DRL4, DRL5, DRL6, DRL7, DRL8, DRL9, DRL10, DRL11, DRL12, DRO1, DRO2, DRO3, DRO4, DRO5, DRO6, DRO7, DRO8, DRO9, " & _ |
| "DRO10, DRO11, DRO12, DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR, " & _ |
| "DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR, " & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR, " & _ |
| "DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR, " & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR, " & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost, " & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR Between Year(GetDate())-2003 and Year(GetDate())-2000" |
| HistoryGrid.DataBind() |
| End Sub |
8 Answers, 1 is accepted
0
answered on 12 Nov 2009, 10:17 PM
Ideas anyone?
0
Hi bradley,
Please, take a look at out examples and the related help topics on Simple and Advanced databinding, and if the problem persists could you paste your mark-up and code-behind for a closer inspection. Thanks.
Greetings,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Please, take a look at out examples and the related help topics on Simple and Advanced databinding, and if the problem persists could you paste your mark-up and code-behind for a closer inspection. Thanks.
Greetings,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
answered on 16 Nov 2009, 03:54 PM
| <%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="sales_hist.aspx.vb" Inherits="sales_sales_hist" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="Header" Runat="Server"> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="PrimaryContent" Runat="Server"> |
| <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="HistoryGrid"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="HistoryGrid" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="Button3"> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="Button4"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="HistoryGrid" /> |
| <telerik:AjaxUpdatedControl ControlID="Button4" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="Button1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="HistoryGrid" /> |
| <telerik:AjaxUpdatedControl ControlID="Button1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="Button2"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="HistoryGrid" /> |
| <telerik:AjaxUpdatedControl ControlID="Button2" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="Button5"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="Button5" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManagerProxy> |
| <asp:SqlDataSource ID="HistorySQL" runat="server" |
| ConnectionString="<%$ ConnectionStrings:MSQL_ERPLXUSRFConnectionString %>" SelectCommand="SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES, |
| DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1, |
| DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12, |
| DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5, |
| DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10, |
| DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12, |
| DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR, |
| DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR, |
| DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR, |
| DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR, |
| DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR, |
| DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost, |
| Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV |
| FROM D097 WHERE DRYEAR = Year(GetDate())-2000"></asp:SqlDataSource> |
| <div style="overflow-x: scroll"> |
| <telerik:RadGrid ID="HistoryGrid" runat="server" AllowFilteringByColumn="True" |
| AllowPaging="True" AllowSorting="True" EnableHeaderContextMenu="True" |
| GridLines="None" ShowGroupPanel="True" PageSize="100" ShowFooter="True" |
| OnExcelMLExportStylesCreated="ExcelMLExportStylesCreated"> |
| <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" |
| ShowGroupFooter="True" |
| GroupsDefaultExpanded="False"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="DRCMPY" DataType="System.Decimal" |
| HeaderText="Company" SortExpression="DRCMPY" UniqueName="DRCMPY"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRYEAR" DataType="System.Decimal" |
| HeaderText="Year" SortExpression="DRYEAR" UniqueName="DRYEAR"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRMKT" HeaderText="Market" |
| SortExpression="DRMKT" UniqueName="DRMKT"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCCOD" HeaderText="Cust Code" |
| SortExpression="DRCCOD" UniqueName="DRCCOD" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRBCN" HeaderText="Bill to Cust" |
| SortExpression="DRBCN" UniqueName="DRBCN"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSSN1" HeaderText="Ship Agt Salesman" |
| SortExpression="DRSSN1" UniqueName="DRSSN1" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSSN2" HeaderText="Ship Fld Salesman" |
| SortExpression="DRSSN2" UniqueName="DRSSN2" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSSN3" HeaderText="Ship CSR" |
| SortExpression="DRSSN3" UniqueName="DRSSN3" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRTEAM" HeaderText="Team" |
| SortExpression="DRTEAM" UniqueName="DRTEAM" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRPLNR" HeaderText="Planner" |
| SortExpression="DRPLNR" UniqueName="DRPLNR" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSTYL" HeaderText="Style" |
| SortExpression="DRSTYL" UniqueName="DRSTYL" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSTDS" HeaderText="Style Desc" |
| SortExpression="DRSTDS" UniqueName="DRSTDS" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRFCST" HeaderText="Forecast" |
| SortExpression="DRFCST" UniqueName="DRFCST" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRFCDS" HeaderText="Forecast Desc" |
| SortExpression="DRFCDS" UniqueName="DRFCDS" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSIZE" DataType="System.Decimal" |
| HeaderText="Size" SortExpression="DRSIZE" UniqueName="DRSIZE"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRITEM" HeaderText="Item" |
| SortExpression="DRITEM" UniqueName="DRITEM" Aggregate="Count" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRIDES" HeaderText="Desc" |
| SortExpression="DRIDES" UniqueName="DRIDES"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRIDS2" HeaderText="Desc 2" |
| SortExpression="DRIDS2" UniqueName="DRIDS2" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOAT" HeaderText="Coating" |
| SortExpression="DRCOAT" UniqueName="DRCOAT" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCTDS" HeaderText="Coating Desc" |
| SortExpression="DRCTDS" UniqueName="DRCTDS" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCPRT" HeaderText="Cust PN" |
| SortExpression="DRCPRT" UniqueName="DRCPRT" Display="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD1" DataType="System.Decimal" |
| HeaderText="$ Jan" SortExpression="DRSD1" UniqueName="DRSD1" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD2" DataType="System.Decimal" |
| HeaderText="$ Feb" SortExpression="DRSD2" UniqueName="DRSD2" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD3" DataType="System.Decimal" |
| HeaderText="$ Mar" SortExpression="DRSD3" UniqueName="DRSD3" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD4" DataType="System.Decimal" |
| HeaderText="$ Apr" SortExpression="DRSD4" UniqueName="DRSD4" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD5" DataType="System.Decimal" |
| HeaderText="$ May" SortExpression="DRSD5" UniqueName="DRSD5" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD6" DataType="System.Decimal" |
| HeaderText="$ Jun" SortExpression="DRSD6" UniqueName="DRSD6" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD7" DataType="System.Decimal" |
| HeaderText="$ Jul" SortExpression="DRSD7" UniqueName="DRSD7" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD8" DataType="System.Decimal" |
| HeaderText="$ Aug" SortExpression="DRSD8" UniqueName="DRSD8" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD9" DataType="System.Decimal" |
| HeaderText="$ Spt" SortExpression="DRSD9" UniqueName="DRSD9" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD10" DataType="System.Decimal" |
| HeaderText="$ Oct" SortExpression="DRSD10" UniqueName="DRSD10" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD11" DataType="System.Decimal" |
| HeaderText="$ Nov" SortExpression="DRSD11" UniqueName="DRSD11" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSD12" DataType="System.Decimal" |
| HeaderText="$ Dec" SortExpression="DRSD12" UniqueName="DRSD12" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU1" DataType="System.Decimal" |
| HeaderText="Units Jan" SortExpression="DRSU1" UniqueName="DRSU1" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU2" DataType="System.Decimal" |
| HeaderText="Units Feb" SortExpression="DRSU2" UniqueName="DRSU2" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU3" DataType="System.Decimal" |
| HeaderText="Units Mar" SortExpression="DRSU3" UniqueName="DRSU3" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU4" DataType="System.Decimal" |
| HeaderText="Units Apr" SortExpression="DRSU4" UniqueName="DRSU4" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU5" DataType="System.Decimal" |
| HeaderText="Units May" SortExpression="DRSU5" UniqueName="DRSU5" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU6" DataType="System.Decimal" |
| HeaderText="Units Jun" SortExpression="DRSU6" UniqueName="DRSU6" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU7" DataType="System.Decimal" |
| HeaderText="Units Jul" SortExpression="DRSU7" UniqueName="DRSU7" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU8" DataType="System.Decimal" |
| HeaderText="Units Aug" SortExpression="DRSU8" UniqueName="DRSU8" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU9" DataType="System.Decimal" |
| HeaderText="Units Sept" SortExpression="DRSU9" UniqueName="DRSU9" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU10" DataType="System.Decimal" |
| HeaderText="Units Oct" SortExpression="DRSU10" UniqueName="DRSU10" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU11" DataType="System.Decimal" |
| HeaderText="Units Nov" SortExpression="DRSU11" UniqueName="DRSU11" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSU12" DataType="System.Decimal" |
| HeaderText="Units Dec" SortExpression="DRSU12" UniqueName="DRSU12" Display="false" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST1" DataType="System.Decimal" |
| HeaderText="Cost Jan" SortExpression="DRCST1" UniqueName="DRCOST1" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST2" DataType="System.Decimal" |
| HeaderText="Cost Feb" SortExpression="DRCST2" UniqueName="DRCOST2" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST3" DataType="System.Decimal" |
| HeaderText="Cost Mar" SortExpression="DRCST3" UniqueName="DRCOST3" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST4" DataType="System.Decimal" |
| HeaderText="Cost Apr" SortExpression="DRCST4" UniqueName="DRCOST4" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST5" DataType="System.Decimal" |
| HeaderText="Cost May" SortExpression="DRCST5" UniqueName="DRCOST5" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST6" DataType="System.Decimal" |
| HeaderText="Cost Jun" SortExpression="DRCST6" UniqueName="DRCOST6" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST7" DataType="System.Decimal" |
| HeaderText="Cost Jul" SortExpression="DRCST7" UniqueName="DRCOST7" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST8" DataType="System.Decimal" |
| HeaderText="Cost Aug" SortExpression="DRCST8" UniqueName="DRCOST8" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST9" DataType="System.Decimal" |
| HeaderText="Cost Spt" SortExpression="DRCST9" UniqueName="DRCOST9" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST10" DataType="System.Decimal" |
| HeaderText="Cost Oct" SortExpression="DRCST10" UniqueName="DRCOST10" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST11" DataType="System.Decimal" |
| HeaderText="Cost Nov" SortExpression="DRCST11" UniqueName="DRCOST11" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRCOST12" DataType="System.Decimal" |
| HeaderText="Cost Dec" SortExpression="DRCST12" UniqueName="DRCOST12" Display="false" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSDYR" DataType="System.Decimal" |
| HeaderText="$ Year" SortExpression="DRSDYR" UniqueName="DRSDYR" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRSUYR" DataType="System.Decimal" |
| HeaderText="Units Year" SortExpression="DRSUYR" UniqueName="DRSUYR" Aggregate="Sum" DataFormatString="{0:n}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRMYR" DataType="System.Decimal" |
| HeaderText="Material Year" SortExpression="DRMYR" UniqueName="DRMYR" Aggregate="Sum" Display="false" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DRLYR" DataType="System.Decimal" |
| HeaderText="Labor Year" SortExpression="DRLYR" UniqueName="DRLYR" Aggregate="Sum" Display="false" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DROYR" DataType="System.Decimal" |
| HeaderText="Overhead Year" SortExpression="DROYR" UniqueName="DROYR" Aggregate="Sum" Display="false" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="YRCost" DataType="System.Decimal" |
| HeaderText="Year Costs" SortExpression="YRCost" UniqueName="YRCost" Aggregate="Sum" DataFormatString="{0:c}"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="YRPV" DataType="System.Decimal" |
| HeaderText="Year PV" SortExpression="YRPV" UniqueName="YRPV" Aggregate="AVG" DataFormatString="{0:p}"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True"> |
| </ClientSettings> |
| </telerik:RadGrid> |
| </div> |
| <asp:Button ID="Button3" runat="server" Text="Export to Excel" OnClick="Button3_Click" OnClientClick='return confirm("Are you sure you want to export everything above?")' /> |
| <asp:Button ID="Button5" runat="server" Text=" Load Current Year Data" OnClientClick='return confirm("The current years data is loaded by default. Are you sure?")' /> |
| <asp:Button ID="Button4" runat="server" Text=" Load Previous Year Data" /> |
| <asp:Button ID="Button1" runat="server" Text=" Load Previous 3 Years Data" /> |
| <asp:Button ID="Button2" runat="server" Text=" Load All Data" OnClientClick='return confirm("Are you sure you want to load the entire database?")' /> |
| </asp:Content> |
| Imports System |
| Imports System.Collections.Generic |
| Imports System.Configuration |
| Imports System.Data |
| Imports System.Data.Common |
| Imports System.Data.SqlClient |
| Imports System.Web.UI |
| Imports Telerik.Web.UI |
| Imports Telerik.Web.UI.GridExcelBuilder |
| Partial Class sales_sales_hist |
| Inherits System.Web.UI.Page |
| Dim SQLID As Integer = 0 |
| Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles HistoryGrid.NeedDataSource |
| If SQLID = "4" Then |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR = Year(GetDate())-2001" |
| End If |
| HistoryGrid.DataSource = HistorySQL |
| End Sub |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| HistoryGrid.GroupingSettings.RetainGroupFootersVisibility = True |
| HistoryGrid.DataSource = HistorySQL |
| End Sub |
| Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) |
| HistoryGrid.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML |
| 'HistoryGrid.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html |
| HistoryGrid.ExportSettings.ExportOnlyData = True |
| HistoryGrid.ExportSettings.IgnorePaging = True |
| HistoryGrid.ExportSettings.OpenInNewWindow = True |
| HistoryGrid.MasterTableView.ExportToExcel() |
| End Sub |
| Protected Sub ExcelMLExportStylesCreated(ByVal source As Object, ByVal e As Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs) |
| For Each style As Telerik.Web.UI.GridExcelBuilder.StyleElement In e.Styles |
| If style.Id = "headerStyle" Then |
| style.FontStyle.Bold = True |
| style.FontStyle.Color = System.Drawing.Color.White |
| style.InteriorStyle.Color = System.Drawing.Color.Blue |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| ElseIf style.Id = "itemStyle" Then |
| style.InteriorStyle.Color = System.Drawing.Color.WhiteSmoke |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| ElseIf style.Id = "alternatingItemStyle" Then |
| style.InteriorStyle.Color = System.Drawing.Color.LightGray |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| End If |
| Next |
| End Sub |
| Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click |
| SQLID = "4" |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR = Year(GetDate())-2001" |
| HistoryGrid.DataBind() |
| End Sub |
| Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR Between Year(GetDate())-2003 and Year(GetDate())-2000" |
| HistoryGrid.DataBind() |
| End Sub |
| Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097" |
| HistoryGrid.DataBind() |
| End Sub |
| Protected Sub Button5_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button5.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR = Year(GetDate())-2000" |
| HistoryGrid.DataBind() |
| End Sub |
| End Class |
0
Hello bradley,
I'd recommend that you take the following steps:
1. Remove the following statement from the Page_Load event:
2. When you are rebinding the grid, call its Rebind() method, not DataBind().
I hope this helps.
Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
I'd recommend that you take the following steps:
1. Remove the following statement from the Page_Load event:
HistoryGrid.DataSource = HistorySQL2. When you are rebinding the grid, call its Rebind() method, not DataBind().
I hope this helps.
Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
answered on 19 Nov 2009, 03:56 PM
Nope, it still defaults back.
Here is the modified VB.
Now when the page is loaded the grid isnt populated (Thats fine), so I click the button to load the data for the Prev Year (Button4), I had to add the HistoryGrid.Datasource = HistorySQL otherwise it came up blank, so this now loads the data, however when you goto group by a field it makes the grouping but there is no data shown (Grid is empty again). Is there something I could do with the needdatasource IE when one of the buttons is pressed a var is assigned a number then in the needdatasource i look at that var and make the query as needed?
Here is the modified VB.
Now when the page is loaded the grid isnt populated (Thats fine), so I click the button to load the data for the Prev Year (Button4), I had to add the HistoryGrid.Datasource = HistorySQL otherwise it came up blank, so this now loads the data, however when you goto group by a field it makes the grouping but there is no data shown (Grid is empty again). Is there something I could do with the needdatasource IE when one of the buttons is pressed a var is assigned a number then in the needdatasource i look at that var and make the query as needed?
| Imports System |
| Imports System.Collections.Generic |
| Imports System.Configuration |
| Imports System.Data |
| Imports System.Data.Common |
| Imports System.Data.SqlClient |
| Imports System.Web.UI |
| Imports Telerik.Web.UI |
| Imports Telerik.Web.UI.GridExcelBuilder |
| Partial Class sales_sales_hist |
| Inherits System.Web.UI.Page |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| HistoryGrid.GroupingSettings.RetainGroupFootersVisibility = True |
| End Sub |
| Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) |
| HistoryGrid.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML |
| HistoryGrid.ExportSettings.ExportOnlyData = True |
| HistoryGrid.ExportSettings.IgnorePaging = True |
| HistoryGrid.ExportSettings.OpenInNewWindow = True |
| HistoryGrid.MasterTableView.ExportToExcel() |
| End Sub |
| Protected Sub ExcelMLExportStylesCreated(ByVal source As Object, ByVal e As Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs) |
| For Each style As Telerik.Web.UI.GridExcelBuilder.StyleElement In e.Styles |
| If style.Id = "headerStyle" Then |
| style.FontStyle.Bold = True |
| style.FontStyle.Color = System.Drawing.Color.White |
| style.InteriorStyle.Color = System.Drawing.Color.Blue |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| ElseIf style.Id = "itemStyle" Then |
| style.InteriorStyle.Color = System.Drawing.Color.WhiteSmoke |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| ElseIf style.Id = "alternatingItemStyle" Then |
| style.InteriorStyle.Color = System.Drawing.Color.LightGray |
| style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid |
| End If |
| Next |
| End Sub |
| Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR = Year(GetDate())-2001" |
| HistoryGrid.DataSource = HistorySQL |
| HistoryGrid.Rebind() |
| End Sub |
| Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR Between Year(GetDate())-2003 and Year(GetDate())-2000" |
| HistoryGrid.Rebind() |
| End Sub |
| Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097" |
| HistoryGrid.Rebind() |
| End Sub |
| Protected Sub Button5_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button5.Click |
| HistorySQL.SelectCommand = "SELECT DRCMPY, DRYEAR, DRMKT, DRCCOD, DRBCN, DRSSN1, DRSSN2, DRSSN3, DRTEAM, DRPLNR, DRSTYL, DRSTDS, DRFCST, DRFCDS, DRSIZE, DRITEM, DRIDES," & _ |
| "DRIDS2, DRCOAT, DRCTDS, DRCPRT, DRSD1, DRSD2, DRSD3, DRSD4, DRSD5, DRSD6, DRSD7, DRSD8, DRSD9, DRSD10, DRSD11, DRSD12, DRSU1," & _ |
| "DRSU2, DRSU3, DRSU4, DRSU5, DRSU6, DRSU7, DRSU8, DRSU9, DRSU10, DRSU11, DRSU12," & _ |
| "DRM1+DRL1+DRO1 AS DRCOST1,DRM2+DRL2+DRO2 AS DRCOST2,DRM3+DRL3+DRO3 AS DRCOST3,DRM4+DRL4+DRO4 AS DRCOST4,DRM5+DRL5+DRO5 AS DRCOST5," & _ |
| "DRM6+DRL6+DRO6 AS DRCOST6,DRM7+DRL7+DRO7 AS DRCOST7,DRM8+DRL8+DRO8 AS DRCOST8,DRM9+DRL9+DRO9 AS DRCOST9,DRM10+DRL10+DRO10 AS DRCOST10," & _ |
| "DRM11+DRL11+DRO11 AS DRCOST11,DRM12+DRL12+DRO12 AS DRCOST12," & _ |
| "DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12 AS DRSDYR,DRSU1+DRSU2+DRSU3+DRSU4+DRSU5+DRSU6+DRSU7+DRSU8+DRSU9+DRSU10+DRSU11+DRSU12 AS DRSUYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12 AS DRMYR,DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12 AS DRLYR," & _ |
| "DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS DROYR," & _ |
| "DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12 AS YRCost," & _ |
| "Case WHEN (DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12) = 0 Then 0 Else (((DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)-(DRM1+DRM2+DRM3+DRM4+DRM5+DRM6+DRM7+DRM8+DRM9+DRM10+DRM11+DRM12+DRL1+DRL2+DRL3+DRL4+DRL5+DRL6+DRL7+DRL8+DRL9+DRL10+DRL11+DRL12+DRO1+DRO2+DRO3+DRO4+DRO5+DRO6+DRO7+DRO8+DRO9+DRO10+DRO11+DRO12))/(DRSD1+DRSD2+DRSD3+DRSD4+DRSD5+DRSD6+DRSD7+DRSD8+DRSD9+DRSD10+DRSD11+DRSD12)) END AS YRPV " & _ |
| "FROM D097 WHERE DRYEAR = Year(GetDate())-2000" |
| HistoryGrid.Rebind() |
| End Sub |
| Protected Sub HistorySQL_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles HistorySQL.Selecting |
| e.Command.CommandTimeout = 0 |
| End Sub |
| End Class |
0
Hi bradley,
The best approach in your case is to set the DataSourceID=HistorySql property of the grid in the mark-up and then in the button click event handlers, just change the SelectCommand of the data source object and call the grid's Rebind() method.
Best wishes,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
The best approach in your case is to set the DataSourceID=HistorySql property of the grid in the mark-up and then in the button click event handlers, just change the SelectCommand of the data source object and call the grid's Rebind() method.
Best wishes,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
answered on 24 Nov 2009, 03:42 PM
Thats all fine, but I still have the problem when you go to "Filter" and/or "Group" and/or "Sort" it reverts back to the original SQL.
Page is loaded with data for year 2009, user clicks button to load 2008 data insted, (The 2008 data is loaded on the screen), they now want to group it by a field, once its done "grouping" the year field now shows 2009 insted of 2008.
Does something need to be changed in the "need data source"
Page is loaded with data for year 2009, user clicks button to load 2008 data insted, (The 2008 data is loaded on the screen), they now want to group it by a field, once its done "grouping" the year field now shows 2009 insted of 2008.
Does something need to be changed in the "need data source"
0
Hi bradley,
Indeed, in this case, the control's datasource will be reverted to the original state.
You can handle this in two possible ways.
First, you can use the NeedDataSource event handler of the grid to populate it with data. There, you can check what data needs to be passed, and populate the grid accordingly.
Alternatively, you can use a select parameter for the datasource control. The latter approach is demonstrated in the sample project attached to this message. I hope this gets you started as expected.
Best wishes,
Yavor
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Indeed, in this case, the control's datasource will be reverted to the original state.
You can handle this in two possible ways.
First, you can use the NeedDataSource event handler of the grid to populate it with data. There, you can check what data needs to be passed, and populate the grid accordingly.
Alternatively, you can use a select parameter for the datasource control. The latter approach is demonstrated in the sample project attached to this message. I hope this gets you started as expected.
Best wishes,
Yavor
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.