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

Exoprt to excel

2 Answers 111 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Devi
Top achievements
Rank 1
Devi asked on 06 Oct 2008, 05:51 AM
 Export radgrid to excel sheet i used coding like this but data is not exporting properly in excel sheet ,  

 ManagerRadGrid.ExportSettings.ExportOnlyData = true;
 ManagerRadGrid.ExportSettings.IgnorePaging = true;
 ManagerRadGrid.ExportSettings.OpenInNewWindow = true;
 ManagerRadGrid.MasterTableView.ExportToExcel();

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 06 Oct 2008, 07:29 AM
Hello Devi,

I have tried the same code as yours at my end and its working as expected. Have you enabled any ajax settings for your grid? If this is the case, go through the following code library submission which explains how to export the grid content to Excel/Word/CSV/PDF when RadGrid resides inside RadAjaxPanel or RadGrid is ajaxified through RadAjaxManager.
Export RadGrid content to Excel/Word/CSV/PDF with Ajax enabled

If this does not help, you could probably explain the required scenario better or send your aspx code across.

Princy.

0
Devi
Top achievements
Rank 1
answered on 06 Oct 2008, 08:55 AM

this is aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Manager.aspx.cs"  MasterPageFile="~/Web_Master_Pages/Main_Page.master" Inherits="Web_Pages_Dev_xml_Manager" %>

 <%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
 <%@ Register Assembly="RadTabStrip.Net2" Namespace="Telerik.WebControls" TagPrefix="radTS" %>
 <%@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="radA" %>
<%@ Register Assembly="RadSplitter.Net2" Namespace="Telerik.WebControls" TagPrefix="radspl" %>
<%@ Register Assembly="RadTreeView.Net2" Namespace="Telerik.WebControls" TagPrefix="radT" %>
<%@ Register Assembly="RadEditor.Net2" Namespace="Telerik.WebControls" TagPrefix="radE" %>
<%@ Register Assembly="GMDatePicker" Namespace="GrayMatterSoft" TagPrefix="cc1" %>

 <asp:Content ID="Content2" ContentPlaceHolderID="MainContentPlaceHolder" runat="Server">
 
   <script language="javascript" type="text/javascript" src="../../Web_Javascript/Manager.js"></script>
     <script type="text/javascript" originalAttribute="src" originalPath="../../Web_Javascript/Manager.js"></script>
     <script type="text/javascript" language="javascript">
function refreshGrid(arg)
{

if(!arg)

{
 window["<%=ManagerRadGrid.ClientID %>"].AjaxRequest('<%= ManagerRadGrid.UniqueID %>', 'Rebind');
}

else

{

window["<%=ManagerRadGrid.ClientID %>"].AjaxRequest('<%= ManagerRadGrid.UniqueID %>', 'RebindAndNavigate');

}

}

 function conditionalPostback(sender,args)
           {
            //on upload button click temporarily disables ajax to perform upload actions
           if(args.EventTarget == '<%=btnExport.UniqueID %>')
            {
           args.EnableAjax =false;
            }
           
            }
    

</script>
 <radA:RadAjaxManager ID="RadAjaxManager1" ClientEvents-OnRequestStart="conditionalPostback"  runat="server" >        
     <AjaxSettings>    
          <radA:AjaxSetting AjaxControlID="ManagerPanel">
              <UpdatedControls >                         
                <radA:AjaxUpdatedControl ControlID="ManagerPanel" />
                 <radA:AjaxUpdatedControl ControlID="SaveMessagelbl"  />
             <radA:AjaxUpdatedControl ControlID="LodingImage" LoadingPanelID="FooterAjaxLoadingPanel" />    
              
             </UpdatedControls >        
         </radA:AjaxSetting>                            
            </AjaxSettings>
     </radA:RadAjaxManager>
    
  
           
     <asp:Panel ID="ManagerPanel" runat="server" >
     <radspl:RadSplitter ID="RadSplitter1" Skin="WebBlue" runat="server" >
    <radspl:RadPane ID="RadPane1" runat="server" Width="9%" >
        <radT:RadTreeView ID="ManagerTreeView" runat="server" AutoPostBack="True" Skin="Inox" OnNodeClick="ManagerTreeView_NodeClick" OnPreRender="ManagerTreeView_PreRender">
            </radT:RadTreeView>
       
        </radspl:RadPane>
       
        <radspl:RadSplitBar ID="RadSplitBar1" runat="server" CollapseMode="Forward" />
      
        <radspl:RadPane ID="RadPane2" runat="server" style="border:3px;"  >
   <div style="text-align: left">
  
  
   <table width="100%">
<tr>
<td>
                    
                                                   <table cellpadding="0" cellspacing="0" width="100%">
                                                   <tr>
                                                   <td style="width:40%">
                                                  
                                                    <radG:RadGrid ID="SalaryAmountDetailsGrid" runat="server"  AutoGenerateColumns="False" GridLines="None" Skin="WebGray20" HeaderStyle-HorizontalAlign="center" ItemStyle-HorizontalAlign="center" HeaderStyle-Height="15px" TabIndex="0"  CellPadding="0" CellSpacing="0" Visible="true" OnItemDataBound="SalaryAmountDetailsGrid_ItemDataBound" OnNeedDataSource="SalaryAmountDetailsGrid_NeedDataSource">
                                          <MasterTableView  Caption="Budget for Manager Below"  Font-Bold="True" Font-Size="12px" >
                                              <Columns>
                                             
                                                    
                                                  <radG:GridTemplateColumn DataField="AllowedIncrease" DataType="System.Decimal" HeaderText="Budget"
                                                      SortExpression="AllowedIncrease" UniqueName="AllowedIncrease">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Budget" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                     
                                                      <ItemTemplate>
                                                          <asp:Label ID="lblbudget" runat="server" Text='<%# Eval("budget") %>' style="text-align:left;float:left;"></asp:Label>
                                                      </ItemTemplate>
                                                     
                                                      <HeaderStyle   HorizontalAlign="left" />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                  </radG:GridTemplateColumn>
                                                  <radG:GridTemplateColumn DataField="AllocatedIncrease" DataType="System.Decimal"
                                                      HeaderText="Spent" SortExpression="AllocatedIncrease" UniqueName="AllocatedIncrease">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Spent" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                      <ItemTemplate>
                                                         <%-- <asp:Label ID="lblspent" runat="server" Text='<%# Eval("spent") %>' style="text-align:left;float:left;"></asp:Label>
                                                         --%>
                                                        
                                                        <%-- <asp:TextBox ID="lblspent" runat="server" Text='<%# Eval("spent") %>' style="text-align:left;float:left;"></asp:TextBox>
                                                        --%>
                                                          <asp:Textbox ID="lblspent" AutoPostBack="false" BorderStyle="none" BackColor="transparent" runat="server" Height="13px" Font-Size="11px" Font-Names="Ariel" Visible="true" Text='<%# Eval("spent") %>' Font-Bold="true" Width="80px" ForeColor="black" Enabled="true" style="text-align:center;"></asp:Textbox> 
                                           
                                                        
                                                      </ItemTemplate>
                                                     
                                                      <HeaderStyle   HorizontalAlign="left" />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                  </radG:GridTemplateColumn>
                                                  <radG:GridTemplateColumn DataField="AvailabelAmount" DataType="System.Decimal" HeaderText="Available"
                                                      SortExpression="AvailabelAmount" UniqueName="AvailabelAmount">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Balance" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                      <ItemTemplate>
                                                          <asp:Label ID="lblbalance" runat="server" Text='<%# Eval("balance") %>' style="text-align:left;float:left;"></asp:Label>
                                                      </ItemTemplate>
                                                    
                                                      <HeaderStyle   HorizontalAlign="left"  />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                    
                                                  </radG:GridTemplateColumn>
                                                
                                                
                                              </Columns>
                                              <ExpandCollapseColumn Visible="False">
                                                  <HeaderStyle Width="19px" BackColor="#E8E8E8" />
                                              </ExpandCollapseColumn>
                                              <RowIndicatorColumn Visible="False">
                                                  <HeaderStyle Width="20px" />
                                              </RowIndicatorColumn>
                                          </MasterTableView>
                                          <ItemStyle HorizontalAlign ="Left" />
                                          <HeaderStyle Height="15px" HorizontalAlign ="Left" />
                           
                        </radG:RadGrid>
                                                  
                                                  
                                              
                                                   </td> 
                                                   <td style="width:5%;">
                                                  
                                                   </td>
                                                   <td style="width:50%">
                                                     <radG:RadGrid ID="OrgnGrid" runat="server"  AutoGenerateColumns="False" GridLines="None" Skin="WebGray20" HeaderStyle-HorizontalAlign="center" ItemStyle-HorizontalAlign="center" HeaderStyle-Height="15px" TabIndex="0"  CellPadding="0" CellSpacing="0" Visible="true" OnItemDataBound="OrgnGrid_ItemDataBound" OnNeedDataSource="OrgnGrid_NeedDataSource">
                                          <MasterTableView  Caption="My Budget"  Font-Bold="True" Font-Size="12px" >
                                              <Columns>
                                             
                                                    
                                                  <radG:GridTemplateColumn DataField="AllowedIncrease" DataType="System.Decimal" HeaderText="Budget"
                                                      SortExpression="AllowedIncrease" UniqueName="AllowedIncrease">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Budget" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                     
                                                      <ItemTemplate>
                                                          <asp:Label ID="lblbudget" runat="server" Text='<%# Eval("budget") %>' style="text-align:left;float:left;"></asp:Label>
                                                      </ItemTemplate>
                                                     
                                                      <HeaderStyle   HorizontalAlign="left" />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                  </radG:GridTemplateColumn>
                                                  <radG:GridTemplateColumn DataField="AllocatedIncrease" DataType="System.Decimal"
                                                      HeaderText="Spent" SortExpression="AllocatedIncrease" UniqueName="AllocatedIncrease">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Spent" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                      <ItemTemplate>
                                                          <asp:Label ID="lblspent" runat="server" Text='<%# Eval("spent") %>' style="text-align:left;float:left;"></asp:Label>
                                                      </ItemTemplate>
                                                     
                                                      <HeaderStyle   HorizontalAlign="left" />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                  </radG:GridTemplateColumn>
                                                  <radG:GridTemplateColumn DataField="AvailabelAmount" DataType="System.Decimal" HeaderText="Available"
                                                      SortExpression="AvailabelAmount" UniqueName="AvailabelAmount">
                                                       <HeaderTemplate>
                                                       <asp:Label ID="HeaderDepartmentDescrLabel" runat="server" Text="Balance" style="text-align:left;float:left;"></asp:Label>
                                                      </HeaderTemplate>
                                                      <ItemTemplate>
                                                          <asp:Label ID="lblbalance" runat="server" Text='<%# Eval("balance") %>' style="text-align:left;float:left;"></asp:Label>
                                                      </ItemTemplate>
                                                    
                                                      <HeaderStyle   HorizontalAlign="left"  />
                                                      <ItemStyle HorizontalAlign ="Left" />
                                                    
                                                  </radG:GridTemplateColumn>
                                                
                                                
                                              </Columns>
                                              <ExpandCollapseColumn Visible="False">
                                                  <HeaderStyle Width="19px" BackColor="#E8E8E8" />
                                              </ExpandCollapseColumn>
                                              <RowIndicatorColumn Visible="False">
                                                  <HeaderStyle Width="20px" />
                                              </RowIndicatorColumn>
                                          </MasterTableView>
                                          <ItemStyle HorizontalAlign ="Left" />
                                          <HeaderStyle Height="15px" HorizontalAlign ="Left" />
                           
                        </radG:RadGrid>
                        </td>
                                                   </tr>
                                                   </table>
                                                    
                                                          
                                                     
                                                     
</td>
</tr>
<tr>
<td>
                                                   

</td>
</tr>
</table>
  
  
    <table width="100%">
      <tr style="width:100%">
                <td valign="middle" style="background-color:#E8E8E8; ">
                <table cellpadding="0" cellspacing="0">
                <tr valign="middle">
              
                  <td id="Td1" align="left" runat="server" style="width:38%; padding-left:10px; height: 28px;">
                                 <asp:Label ID="Label1" runat="server" SkinID="BlueviewSkinLabel">Manager Direct Reports  </asp:Label>
                                    &nbsp;
                                    <asp:DropDownList ID="drpManager" runat="server"  Visible="false" SkinID="DropDownSkin" OnSelectedIndexChanged="drpManager_SelectedIndexChanged" AutoPostBack="true">
        </asp:DropDownList>
                                    <asp:Label ID="UI_ManagerNameLabel" runat="server" Font-Italic="true" ForeColor="red" Font-Bold="true" ></asp:Label>&nbsp;
                                   
                                </td>
                     <td id="Td2" align="left" runat="server" style="height: 28px; width:200px; text-align: center;" >
                                     <asp:RadioButton ID="USDRadioButton" runat="server" SkinID="RadioButtonSkin" GroupName="CurrencyGroup" AutoPostBack="true" Checked="True" Text="USD" OnCheckedChanged="USDRadioButton_CheckedChanged"  />
                                    <asp:RadioButton ID="LocalRadioButton" runat="server" Text="Local" SkinID="RadioButtonSkin" GroupName="CurrencyGroup" AutoPostBack="true" OnCheckedChanged="LocalRadioButton_CheckedChanged"  />
                                </td>
                                <td style="height: 28px">
                                 <img src="../../App_Images/images/alert.gif" originalAttribute="src" originalPath="../../App_Images/images/alert.gif" runat="server" alt="Alerts" id="Budget_AlertsImgButton" style="border-width:0px;" visible="false" />
                                </td>
                    <td align="right" style="height: 28px; text-align: right;" >
         <asp:Button ID="btnSaveManager"  runat="server" Text="Save & Update Budget"  OnClick="btnSaveManager_Click" />
                      
                                         <%-- <asp:Button ID="H" runat="server" Text="Compute Budget" ValidationGroup="Sp_Mgr_Amt_Save" TabIndex="4" />
                                <a href="javascript:fBudgetApprovals_Open()">
                              
                             
                                </a>--%>
                        <asp:Button ID="btnExport" originalAttribute="href" originalPath="javascript:fBudgetApprovals_Open()">
                              
                             
                                </a>--%>
                        <asp:Button ID="btnExport" runat="server" Text="Export to Excel"  OnClick="Button1_Click" />
                        &nbsp;
                    </td>
                   
                    </tr>
                </table>
                </td>
                </tr>
    </table>
    <table >
    
    <tr>
    <td>
         <table>
                             <tr>
                                                <td>
                                               
                                                  <radG:RadGrid ID="ManagerRadGrid" runat="server" AllowPaging="true" PageSize="50" GridLines="None" Width="900px" AutoGenerateColumns="False" MasterTableView-EditMode="EditForms"   Skin="WebGrid20" AllowCustomPaging="false" EnableViewState="true" HeaderStyle-Wrap="true" OnNeedDataSource="ManagerRadGrid_NeedDataSource" OnItemDataBound="ManagerRadGrid_ItemDataBound" OnPreRender="ManagerRadGrid_PreRender" OnItemCreated="ManagerRadGrid_ItemCreated" OnUpdateCommand="ManagerRadGrid_UpdateCommand" OnPageIndexChanged="ManagerRadGrid_PageIndexChanged" >
                                <MasterTableView DataSourcePersistenceMode="ViewState" ShowFooter="True"  DataKeyNames="KeyNum" >
                                <Columns>
                                  <radG:GridTemplateColumn HeaderText="xmlnum" Visible="False" UniqueName="TemplateColumn1">
                                                                        <ItemTemplate>
                                                                            <asp:Textbox ID="lblpxmlnum" runat="server" Text='<%# Eval("KeyNum")%>'></asp:Textbox>
                                                                        </ItemTemplate>
                                                                    </radG:GridTemplateColumn>
                                    <radG:GridTemplateColumn  UniqueName="TemplateColumn" ItemStyle-Wrap="true">
                                    <HeaderTemplate>
                                   <table id="Table1"  cellpadding="0" cellspacing="0" >
                                    <tr>
                                    <td align="center">
                                    <asp:Label ID="lblName" runat="server" Text="Name" Width="120px" SkinId="ModelGridHeadLabel" ></asp:Label>
                                    </td>
                                    <td align="center">
                                    <asp:Label ID="lblhiredate" runat="server" Text="Hire Date" Width="50px" SkinId="ModelGridHeadLabel" ></asp:Label>
                                    </td>
                                     <td align="center">
                                    <asp:Label ID="Label2" runat="server" Text="Location" Width="70px" SkinId="ModelGridHeadLabel" ></asp:Label>
                                    </td>
                                    <td align="center">
                                    <asp:Label ID="lbljob" runat="server" Text="Job Title" Width="140px" SkinId="ModelGridHeadLabel" ></asp:Label>
                                    </td>
                                    </tr>
                                    </table>
                                   
                                    </HeaderTemplate>
                                   
                                    <ItemTemplate>
                                  
                                     <table id="Table2" runat="server" cellpadding="0" cellspacing="0" >
                                  
                                    <tr>
                                   
                                    <td align="center" style="border-width:0px;" runat="server" id="ss">
                                    <asp:Label ID="txtname" runat="server" Width="120px" Text='<%# Eval("EmployeeName") %>'  style="text-align:center;"  Visible="true"></asp:Label>
                                    </td>
                                        <td align="center" style="border-width:0px;" runat="server" id="Td1">
                                    <asp:Label ID="txthiredate" runat="server" Width="60px" Text='<%# Eval("HireDate") %>'  style="text-align:center;"  Visible="true"></asp:Label>
                                    </td>
                                     <td align="center" style="border-width:0px;" runat="server" id="Td6">
                                    <asp:Label ID="txtlocation" runat="server" Width="50px" Text='<%# Eval("Location") %>'  style="text-align:center;"  Visible="true"></asp:Label>
                                    </td>
                                    <td align="center" style="border-width:0px;" runat="server" id="Td2">
                                    <asp:Label ID="txtjob" runat="server"  Width="140px" Text='<%# Eval("Position") %>'  style="text-align:center;"  Visible="true"></asp:Label>
                                    </td>    
                                    </tr>
                                    </table>
                                   
                                    </ItemTemplate>
                                    <FooterTemplate>
                                     <table id="Table3" cellpadding="0" cellspacing="0">
                                    <tr>
                                    <td align="left" style="border-width:0px; font-weight:bold;" >Total / Avg</td>
                                    </tr>
                                   
                                           
                                    </table>
                                    </FooterTemplate>
                                     <HeaderStyle  Width="0px" BackColor="#999999" />
                                     <FooterStyle BackColor="#E8E8E8"/>
                                    
                                   
                                    </radG:GridTemplateColumn>
                                    <radG:GridTemplateColumn DataType="System.Decimal"  UniqueName="SP_MostRecentTemplateColumn">
                                   
                                        <HeaderTemplate>
                                        <table  cellpadding="0" cellspacing="0" id="Table4">
                                           
                                             <tr>
                                            
                                             <td align="center" style=" background-color:#92B4E1; color :White; ">
                                             <asp:Label ID="lblperfrating" runat="server"  Text="Perf Rtg" Width="30px" SkinId="ModelGridHeadLabel" ></asp:Label>
                                            
                                             </td>
                                              <td align="Center" style="background-color:#92B4E1; color :White ;">
                                                  <asp:Label ID="lblannualsalary" runat="server" Text="Annual Salary" Width="70px" SkinId="ModelGridHeadLabel"></asp:Label></td>
                                            
                                              <td id="Td3" align="Center" style="background-color:#92B4E1; color :White ;" runat="server" visible="True" >
                                                  <asp:Label ID="lblguideline" runat="server" Text="Salary Guideline" Width="50px" SkinId="ModelGridHeadLabel"></asp:Label></td>
                                            
                                             </tr>
                                             <tr>
                                             <td  align="center" style=" font-family:Arial;color:White; background-color:#92B4E1; width:100%"></td>                                                                                          
                                             <td  align="center" style=" font-family:Arial;color:White; background-color:#92B4E1; width:100%"><asp:Label runat="server" ID="lblUSD" Text="USD"></asp:Label></td>                                                                                          
                                              <td  align="center" style=" font-family:Arial;color:White; background-color:#92B4E1; width:100%">%</td>                                                                                          
                                           
                                             </tr>
                                            </table>
                                        </HeaderTemplate>
                                        <ItemTemplate>                                                                        
                                        <table id="Table5" cellpadding="0" cellspacing="0" >                                                                                                                                                               
                                             <tr>                                            
                                             <td align="center" style="Width:30px;border-width:0px;">
                                            <asp:Textbox ID="txtrating" runat="server"   Width="30px" Text='<%# Eval("PerformanceRating")%>'  Height="13px" Font-Size="11px" Font-Names="Ariel" Wrap="True" Visible="True"  Font-Bold="true"  TabIndex="1" style="border-style:groove;"></asp:Textbox>
                                                                    
                                             </td>
                                             <td align="center" style="Width:70px;border-width:0px;">
                                             <asp:Label ID="txtannualsalary" runat="server"  Width="70px" Text='<%# Eval("Current_Annual_Salary_USD")%>'></asp:Label>
                                           
                                              </td>
                                              <td align="center" style="Width:50px;border-width:0px;">
                                              <asp:Label ID="txtguideline" runat="server"   Text='<%# Eval("MeritGuideline") %>' Width="50px"></asp:Label>
                                               
                                             </tr>
                                             </table>                                                                    
                                        </ItemTemplate>                                      
                                      
                                        <FooterTemplate>
                                        <table id="Table6" cellpadding="0" cellspacing="0" >
                                        <tr>
                                        <td align="center" style="Width:30px;border-width:0px;" ></td>
                                         <td align="center" style="Width:60px;border-width:0px;" >
                                            <asp:Label ID="fooannualsalary" runat="server" Text="0" Width="70px" style="text-align:center;"></asp:Label></td>
                                        <td align="center" style="Width:0px;border-width:0px;" >
                                        <asp:Label ID="fooguideline" runat="server" Text="0" Width="50px"></asp:Label></td>
                                       
                                       
                                        </tr>
                                        </table>
                                        </FooterTemplate>
                                                                               
                                        <HeaderStyle BackColor="#92B4E1"  HorizontalAlign ="Center" ForeColor ="White" />
                                        <FooterStyle BackColor="#E8E8E8"/>
                                                                         
                                       
                                        
                                    </radG:GridTemplateColumn>
                                   
                                  
                                     <radG:GridTemplateColumn DataType="System.Decimal"  UniqueName="RecommendationTemplateColumn">
                                        <HeaderTemplate>
                                        <table id="Table7" cellpadding="0" cellspacing="0">
                                            
                                             <tr>
                                             <td colspan="2" align="left" >
                                                  <asp:Label ID="lblpctincrease" runat="server" Text="Manager Discretion"   SkinId="ModelGridHeadLabel"></asp:Label></td>
                                            <%-- <td align="center" style="Width:50px;">
                                                  <asp:Label ID="lblincrease" runat="server" Text="Discretion" Width="50px"  SkinId="ModelGridHeadLabel"></asp:Label></td>
                                              --%> 
                                              
                                               </tr>
                                               <tr>
                                            
                                              <td id="Td7" align="center" style="Width:40px;" runat="server" visible="True"><font color="white"> <b>%</b></font></td>
                                               <td id="Td4" align="center" style="Width:60px;" runat="server" visible="True"><asp:Label runat="server" ID="lblUSD2" Text="$" ForeColor="white"></asp:Label></td>
                                             
                                             </tr>
                                            </table>
                                        </HeaderTemplate>
                                        <ItemTemplate>
                                           <table id="Table8"  cellpadding="0" cellspacing="0">
                                             <tr>
                                           
                                               <td align="center" style="Width:40px;border-width:0px;">
                                               <asp:TextBox AutoPostBack="false"  ID="txtpctincrease" runat="server"  Text='<%# Eval("Incr_PCT") %>' Width="40px" Height="13px" Font-Size="11px" Font-Names="Ariel" Wrap="True" Visible="True"  Font-Bold="true"  TabIndex="1" style="border-style:groove;"></asp:TextBox>
                                           
                                                </td>
                                                <td align="center" style="Width:60px;border-width:0px;">
                                                <asp:TextBox AutoPostBack="false" ID="txtincrease" runat="server" Text='<%# Eval("Incr_Amt_USD") %>' Width="60px" Height="13px" Font-Size="11px" Font-Names="Ariel" Wrap="True" Visible="True"  Font-Bold="true" TabIndex="2" style="border-style:groove;"></asp:TextBox>
                                               
                                                </td>
                                              
                                              
                                              
                                             </tr>
                                             </table>
                                        </ItemTemplate>
                                       
                                        <FooterTemplate>
                                       <table id="Table9" cellpadding="0" cellspacing="0">
                                        <tr>
                                        <td align="center" style="Width:40px;border-width:0px;"  >
                                        <asp:Label runat="server" ID="foopctincrease"  Text="0"  style="text-align:center;"></asp:Label>
                                        </td>
                                        <td align="center" style="Width:50px;border-width:0px;" >
                                        <asp:Label runat="server" ID="fooincrease"  Text="0" style="text-align:center;" ></asp:Label>
                                        </td>
                                      
                                        </tr>
                                        </table>
                                       
                                        </FooterTemplate>
                                        <HeaderStyle BackColor="#829FC9" />
                                        <FooterStyle BackColor="#E8E8E8"/>
                                    </radG:GridTemplateColumn>
                             
                           <radG:GridTemplateColumn DataType="System.Decimal"  UniqueName="RecommendationTemplateColumn">
                                        <HeaderTemplate>
                                        <table id="Table7" cellpadding="0" cellspacing="0">
                                            
                                             <tr>
                                      <td align="center" style="Width:80px;">
                                      <asp:Label ID="lblnewannual" runat="server" Text="New Annual Salary" Width="80px" SkinId="ModelGridHeadLabel"></asp:Label></td>
                                       <td align="center">
                                      <asp:Label ID="lblheadxchange" runat="server" Text=""  SkinId="ModelGridHeadLabel" Visible="false"></asp:Label></td>
                                       <td align="center">
                                      <asp:Label ID="lblheadcurrencycode" runat="server" Text=""  SkinId="ModelGridHeadLabel" Visible="false"></asp:Label></td>
                                     
                                              </tr>
                                              <tr>
                                             <td id="Td5" align="center" style="Width:80px;" runat="server"  visible="True"><asp:Label runat="server" ID="lblUSD1" Text="USD" ForeColor="white"></asp:Label></td>
                                             
                                              </tr>
                                              </table>
                                              </HeaderTemplate>
                                              <ItemTemplate>
                                              <table id="Table8"  cellpadding="0" cellspacing="0">
                                             <tr>
                                            <td align="center" style="Width:80px;border-width:0px;">
                                            <%--<asp:Label ID="txtnewannual" runat="server" Visible="false"  Text='<%# Eval("New_Annual_Salary_USD") %>' Width="80px" style="text-align:center;"></asp:Label>  --%>
                                             <asp:Textbox ID="txtnewannual" AutoPostBack="false" BorderStyle="none" BackColor="transparent" runat="server" Height="13px" Font-Size="11px" Font-Names="Ariel" Visible="true" Text='<%# Eval("New_Annual_Salary_USD") %>' Font-Bold="true" Width="80px" ForeColor="black" Enabled="true" style="text-align:center;"></asp:Textbox> 
                                           
                                             </td>
                                            
                                             <td align="center">
                                            <asp:Label ID="lblxchange" runat="server" Visible="false"  Text='<%# Eval("averagerate") %>' style="text-align:center;"></asp:Label>
                                             <%--<asp:Label ID="lblxchange" runat="server" Visible="false"  style="text-align:center;"></asp:Label>  --%>
                                          
                                             </td>
                                            
                                             <td align="center">
                                            <asp:Label ID="lblcurrencycode" runat="server" Visible="false"  Text='<%# Eval("PayCurrency") %>' style="text-align:center;"></asp:Label> 
                                           
                                             <asp:Label ID="lblcountry" runat="server" Visible="false"  Text='<%# Eval("Location") %>' style="text-align:center;"></asp:Label> 
                                      
                                             </td>
                                            
                                              <td align="center">
                                            <asp:Label ID="lblemployeeid" runat="server" Visible="false"  Text='<%# Eval("EmployeeID") %>' style="text-align:center;"></asp:Label> 
                                            </td>
                                             </tr>
                                             </table>
                                                                                          
                                              </ItemTemplate>
                                              <FooterTemplate>
                                              <table id="Table10" >
                                              <tr>
                                               <td align="right" style="Width:80px;border-width:0px;" >
                                        <asp:Label ID="foonewannual" runat="server"  Text="" style="text-align:left;"></asp:Label>
                                        </td>
                                              </tr>
                                              </table>
                                              </FooterTemplate>
                                        <HeaderStyle BackColor="#829FC9" />
                                        <FooterStyle BackColor="#E8E8E8"/>
                                    </radG:GridTemplateColumn>
                                <radG:GridTemplateColumn  UniqueName="MemoTemplateColumn" Groupable="False">
                       <HeaderTemplate>
                         <asp:Label ID="lblcomment" Text="Comments" runat="server"></asp:Label>
                         </HeaderTemplate>
                                  <ItemTemplate>
                                   <asp:Label ID="NoteLabel" Visible="false" runat="server" Text='<%# Eval("comment") %>' style="border-width:0px; border:0px;"></asp:Label>                                  
                                 
                                   <img id="NoteImage" width="25" height="25"  runat="server" src="../../App_Images/images/Readme.gif" originalAttribute="src" originalPath="../../App_Images/images/Readme.gif" alt="Note" style="border-width:0px; border:0px;" />                                                                       
                                   <asp:Label ID="label1" runat="server" Text="" Visible="true" style="border:0px;"></asp:Label>
                                <asp:HyperLink ID="NoteLink" Height="22"  runat="server" Text="Note"></asp:HyperLink>
                                     </ItemTemplate>
                                       <EditItemTemplate>
                                  <%--<asp:Label ID="SP_Notes_Emp_numLabel" runat="server" Text='<%# Eval("Emp_num") %>' Visible="false"></asp:Label>--%>
                                 <%--  <asp:Label ID="SP_Notes_CompNumLabel" Visible="false" runat="server" Text='<%# Eval("Keynum") %>' style="border-width:0px; border:0px;"></asp:Label>
                                  <asp:Label ID="Falselabel" runat="server" Text="23" Visible="true" style="border:0px; color:Background;" ></asp:Label>
                                 --%>
                                 <radE:RadEditor ID="REditornotes" toolsfile="~/RadControls/Editor/AjaxSpell.xml" ShowSubmitCancelButtons="False" runat="server" Height="100px"  Html='<%# Eval("locationcode") %>' TabIndex="0"  >
                                   </radE:RadEditor>
                           </EditItemTemplate>   
                                      <HeaderStyle BackColor="#829FC9" />
                                     
                                        <FooterStyle BackColor="#E8E8E8"/>
                                        <ItemStyle  BorderWidth="0px"/>
                      
                          </radG:GridTemplateColumn>
                         
                                          
                                   
                                   
                                </Columns>
                                <ExpandCollapseColumn Visible="False">
                                    <HeaderStyle Width="19px" />
                                </ExpandCollapseColumn>
                                <RowIndicatorColumn Visible="False">
                                    <HeaderStyle Width="20px" />
                                </RowIndicatorColumn>
                                <PagerStyle Mode="NextPrev" />
                                <EditFormSettings>
                                    <EditColumn UniqueName="EditCommandColumn1">
                                    </EditColumn>
                                </EditFormSettings>
                                                              
                              
                            </MasterTableView>
                            <PagerStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                Font-Underline="False" HorizontalAlign ="Left" Wrap="True" AlwaysVisible="true"   />
                                    <ClientSettings>
                                     <Scrolling AllowScroll="true" ScrollHeight="300px" UseStaticHeaders="true" />
                                   
                                    </ClientSettings>
                                    
                             </radG:RadGrid>
                                                </td>
                                                </tr>
                                            </table>
        <asp:HiddenField ID="HFChangePage" runat="server" />
        <asp:HiddenField ID="sFooPctIncreaseClientID" runat="server" />
        <asp:HiddenField ID="sFooIncreaseClientID" runat="server" />
        <asp:HiddenField ID="slblmgrbalanceClientID" runat="server" />
        <asp:HiddenField ID="sFooNewAnnualClientID" runat="server" />
        <asp:HiddenField ID="sFooGuideLineClientID" runat="server" />
        <asp:HiddenField ID="sFooAnnualSalaryClientID" runat="server" />
        <asp:HiddenField ID="slblmgrbudgetClientID" runat="server" />
        <asp:HiddenField ID="slblmgrspentClientID" runat="server" />
        <asp:HiddenField ID="CurrencyCodeHiddenField" runat="server" />
        <asp:HiddenField ID="countryclientID" runat="server" />
        <asp:HiddenField ID="txtnewannualClientID" runat="server" />
       
                                              
    </td>
      
    </tr>
   
    </table>
   

                                       
                         
    </div>
    </radspl:RadPane>
    </radspl:RadSplitter>
   
                 </asp:Panel>
</asp:Content>

 

Tags
Grid
Asked by
Devi
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Devi
Top achievements
Rank 1
Share this question
or