Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
197 views

So, I have a scenario that I'm not sure how to handle.  We have some pages that have a huge amount of numeric textboxes on them and having them each as a  RadNumericTextBox just doesn't work very well.   So I looked to RadInputManager.   Problem is it seems that me that there is an issue when dealing with a container of controls, take a GridView for example.   I may have 20 rows each with 5 numeric boxes in them.   1 box may require 0 decimal places for integer, 2 boxes may require 2 decimal places for money and 2 boxes may require 3 decimal places for %.   Ideally I could create a RadInputManager outside of that repeater and specify different decimals for each box, but I'm pretty sure that can't be done, because the only input to the RadInputManager is a single ClientID, not an ability to specify the container and then the name inside that container.  Is that correct? 

So, my next thought is to try to create 3 RadInputManagers inside of the GridView .   That's 3 managers total.  But I don't think there's a way to do that either, at least in the .aspx page. 

So my next thought which I'm pretty sure would work, is inside of each Template Column (or where relevant), or maybe just the first column, create three managers that each define number of decimal places and then set the ids there.   While I imagine this would probably work, my question is would there be a big hit on performance creating 3 managers per row?  Could it be done better in a code behind?  Is there a better solution I haven't thought of?


An Example of this last idea with just 2 managers:

<GridView .....>

<asp:TemplateField>

<ItemTemplate>

<telerik:RadInputManager ID="RadInputManager2" runat="server">

<telerik:NumericTextBoxSetting DecimalDigits="2">

<TargetControls>

<telerik:TargetInput ControlID="SortOrder" />

</TargetControls>

</telerik:NumericTextBoxSetting>

</telerik:RadInputManager>

<asp:TextBox runat="server" ID="SortOrder" Text='<%#Eval("SortOrder") %>'></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

 

<asp:TemplateField
<ItemTemplate>
<telerik:RadInputManager ID="RadInputManager1" runat="server">
<telerik:NumericTextBoxSetting DecimalDigits="0">
<TargetControls>
<telerik:TargetInput ControlID="ItemAmount" />
<telerik:TargetInput ControlID="ItemAmountAdj" />
</TargetControls>
</telerik:NumericTextBoxSetting>
</telerik:RadInputManager>
<asp:TextBox runat="server" ID="ItemAmount" Text='<%#Eval("ItemAmount") %>'></asp:TextBox>
<asp:TextBox runat="server" ID="ItemAmountAdj" Text='<%#Eval("ItemAmountAdj") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>

</GridView>

Alex
Top achievements
Rank 1
 answered on 18 Feb 2011
1 answer
95 views
Hi.

I'd like to know how to get from the radtreelist, the dataitems that will be rendered after requesting a node expansion, and in which event it could be done.

I've tried the following code, but without success.

protected void TreeList_Load(object sender, EventArgs e)
{
     MyTreeList.DataSource = ws.GetSales(); 
     //This retrieves an array of objects which represent the sales of several stores,
     //their managers and their employees
  
     TreeListDataItemCollection rendered_items = MyTreeList.Items;
  
     object[] data = rendered_items.Select(s => s.DataItem).ToArray(); 
     //I thought this would get the DataBoundItems
     //in the treelist, but instead it gets an Array with null objects
  
     //Code for Exporting the desired data
}

By the way, getting the Items from "MyTreeList" in the OnLoad event, retrieves me the Items shown in the previous state of the control, not the ones that were recently asked for, so I don't know which event could work better. Could you help me?

Regards
Tsvetina
Telerik team
 answered on 18 Feb 2011
6 answers
326 views

I have problems to erase a register from a RADGRID, associated to a SessionDataSource, which I use temporarily, playing the role of a “recipient“ ( just insert and delete).

 

The code the .aspx for the SessionDataSource is as below:

<sds:SessionDataSource 
    DisplayWarning                  = "False"    
    PrimaryKeyFields                = "dp_key"
    ProviderName                    = "System.Data.SqlClient"
    ID                                          = "devis" 
    runat                                     = "server" 
    ConnectionString               = "<%$ ConnectionStrings:string_Connection %>" 
    ConflictDetection               = "CompareAllValues" 
    OldValuesParameterFormatString  = "original_{0}"
  
    SelectCommand="SELECT * FROM [devis] ORDER BY dp_key"
    DeleteCommand="DELETE   FROM [devis] WHERE [dp_key] = ?"
    InsertCommand="INSERT   INTO devis(dp_codeprd, dp_nombre, dp_convives, dp_prixs, dp_prixs_unitaire) VALUES (?, ?, ?, ?, ? )" 
    >
    <DeleteParameters>
        <asp:Parameter Name="original_dp_key"             Type="Int32"   />
    </DeleteParameters>
  
    <InsertParameters>
        <asp:Parameter Name="dp_codeprd"                   Type="String"   />
        <asp:Parameter Name="dp_nombre"                    Type="String"   />
        <asp:Parameter Name="dp_convives"                   Type="Int16"    />
        <asp:Parameter Name="dp_prixs"                          Type="Decimal"  />
        <asp:Parameter Name="dp_prixs_unitaire"           Type="Decimal"  />
    </InsertParameters>
  
</sds:SessionDataSource>

The code the .aspx for RadGrid is as below:

<telerik:RadGrid 
        ShowFooter              = "false"
        ID                      = "devis_prd" 
        runat                   = "server"
        DataSourceID            = "devis" 
        Width                   = "100%" 
        AllowPaging             = "True" 
        PageSize                = "10" 
        AllowSorting            = "false"
        GridLines               = "None"
           
        AllowAutomaticDeletes   = "True" 
        AllowAutomaticInserts   = "True"
        AllowAutomaticUpdates   = "True" 
        onitemdatabound         = "devis_prd_ItemDataBound" 
    >
    <HeaderContextMenu EnableTheming="True">
        <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
    </HeaderContextMenu>
    <MasterTableView 
        AutoGenerateColumns="False" 
        CommandItemDisplay="None" 
        CurrentResetPageIndexAction="SetPageIndexToFirst" 
        DataKeyNames="dp_key, dp_codeprd, dp_nombre, dp_convives, dp_prixs, dp_prixs_unitaire" 
        HorizontalAlign="NotSet" Name="devis_prd" 
        NoDetailRecordsText="Aucun produit sélectionné !" 
        NoMasterRecordsText="Votre devis est vide !" Width="100%">
        <Columns>
            <telerik:GridBoundColumn DataField="dp_key" DataType="System.Int32" 
                HeaderText="Id " ReadOnly="True" SortExpression="dp_key" UniqueName="dp_key" 
                Visible="false">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="dp_CodePrd" 
                DataFormatString="{0:LLL-LL-000}" DataType="System.String" 
                HeaderText="Code Produit" UniqueName="dp_CodePrd">
                <HeaderStyle HorizontalAlign="Center" />
                <ItemStyle HorizontalAlign="Center" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="dp_nombre" DataType="System.String" 
                HeaderText="Nom du Produit" SortExpression="dp_nombre" UniqueName="dp_nombre">
                <HeaderStyle HorizontalAlign="Left" />
                <ItemStyle HorizontalAlign="Left" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="dp_convives" DataType="System.Int32" 
                HeaderText="Convives" SortExpression="dp_convives" UniqueName="dp_convives">
                <HeaderStyle HorizontalAlign="Right" />
                <ItemStyle CssClass="monto_grid" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="dp_prixs" DataFormatString="{0:C2}" 
                DataType="System.Decimal" HeaderText="Prix de la Paella" 
                SortExpression="dp_prixs" UniqueName="dp_prixs">
                <HeaderStyle HorizontalAlign="Right" />
                <ItemStyle CssClass="monto_grid" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="dp_prixs_unitaire" 
                DataFormatString="{0:C2}" DataType="System.Decimal" HeaderStyle-Width="120" 
                HeaderText="Prix unitaire " SortExpression="dp_prixs_unitaire" 
                UniqueName="dp_prixs_unitaire">
                <HeaderStyle HorizontalAlign="Right" />
                <ItemStyle CssClass="monto_grid" />
            </telerik:GridBoundColumn>
            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" 
                ConfirmDialogType="RadWindow" 
                ConfirmText="Cette action permet de supprimer le produit sélectionné de votre devis. <br/><br/>Etes-vous sûr ? <br/><br/>" 
                Text="Supprimer ce produit" UniqueName="DeleteColumn">
                <HeaderStyle Width="20px" />
                <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
            </telerik:GridButtonColumn>
        </Columns>
    </MasterTableView>
    <PagerStyle Mode="NextPrevAndNumeric" />
</telerik:RadGrid>

The insert I do it with the code behind and it works without any problem:

 

public void Insert_Devis(object source, EventArgs e)
{
    devis.InsertParameters["dp_codeprd"].DefaultValue        = Code_PRD();
    devis.InsertParameters["dp_nombre"].DefaultValue         = Produits_ID.Text;
    devis.InsertParameters["dp_convives"].DefaultValue       = RadComboBox1.Text;
    devis.InsertParameters["dp_prixs"].DefaultValue          = (Convert.ToDouble(RadComboBox1.SelectedValue) * Convert.ToInt16(RadComboBox1.Text)).ToString();
    devis.InsertParameters["dp_prixs_unitaire"].DefaultValue = RadComboBox1.SelectedValue.ToString();
    devis.Insert();
}

But at the moment of deleting a registry from the “recipient” (RadGrid) I get the following message:

Mensaje: Sys.WebForms.PageRequestManagerServerErrorException: Error de sintaxis en la expresión.

Línea: 3

Carácter: 74672

Código: 0

URI: http://subtest.test.com/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bAjaxControlToolkit%2c+Version%3d4.1.40412.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d28f01b0e84b6d53e%3aes-ES%3aacfc7575-cdee-46af-964f-5d85d9cdcf92%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2010.3.1109.40%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aes-ES%3a30468509-1b07-456a-b5f4-bb35a9cae168%3a16e4e7cd%3a874f8ea2%3af7645509%3a24ee1bba%3af46195d3%3a19620875%3a490a9d4e%3abd8f85e4%3a86526ba7%3ae330518b%3a1e771326%3ac8618e41%3aed16cbdc%3a39040b5c%3af85f9819%3ab7778d6c%3a82923ac3%3bAjaxControlToolkit%2c+Version%3d4.1.40412.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d28f01b0e84b6d53e%3aes-ES%3aacfc7575-cdee-46af-964f-5d85d9cdcf92%3a923aa3cc%3a853c2e0b%3a46f97eb1%3a782b16ab%3a535785ef »

Please help me to solve this problem.

Thanks for your help,
Jorge Saa-Gerbier

Radoslav
Telerik team
 answered on 18 Feb 2011
1 answer
132 views
Is there a way to change the skin, or color of a RadGrid Button COlumn Confirmation popup?
<telerik:GridButtonColumn ConfirmText="Delete this record?" ConfirmDialogType="RadWindow" ConfirmDialogHeight="150" ConfirmDialogWidth="250" ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"         UniqueName="DeleteColumn"  />
I have a RadWindowManager on the screen but how do I set the ID of the Confirm popup for the Window, or is there another setting?
Shinu
Top achievements
Rank 2
 answered on 18 Feb 2011
5 answers
235 views
I made a custom control which incorporates the RadEditor.  So I end up with a dll (the custom control) which displays the RadEditor control, AND I have to display one set of buttons or another in the RadEditor based on the user's permissions.  I have been able to make the ToolsFile an embedded resource, but the RadEditor throws an ArgumentException when it tries to use the file.

All of this is working fine if I set the RadEditor1.ToolsFile string like this

I have to make the ToolsFile an embedded resource so that the files travel w the dll where ever it goes.  I embedded the file and the custom control works fine in the website except that the RadEditor throws an error when it tries to load the ToolsFile: error message =   illegal characters in string

Belowe is how I call the ToolsFile in that scenario.  It seems to me that the RadEditor is throwing an error when it shouldn't.  I use this same method to set an ImageUrl for an asp:Image and it works fine.  Question: How can I access the path to a RadEditor ToolsFile which is an embedded resource in a custom control.
RadEditor1.ToolsFile = this.Page.ClientScript.GetWebResourceUrl(typeof (lbWidgets.RootResources), "lbWidgets.RootResources.CourseAuthorTools.xml");
Kris
Top achievements
Rank 1
 answered on 18 Feb 2011
4 answers
536 views
Hi

I guess the title says it all. Is it possible to programmatically add an aggregate to a grid column and programatically set the gridfooterformatstring?

thanks
Chris
Top achievements
Rank 1
 answered on 18 Feb 2011
4 answers
168 views
Hi,

We are using Intersoft's WebGrid in our application and facing lots of problem related to performance. Specially grid rendering time is very high. I have been asked for testing radgrid and make presentation so that we can switch over RadGrid.

Can anyone explain me the logic behind RadGrid rendering and how it is faster than WebGrid,  is there any unique feature available in radgrid that is not available in other grid.
Any diffrences between RadGrid and WebGrid would make my presentation impressive.

Plzzzzzzzz reply if you have anuy input related to this.

Regards
Devanand Jha



Elliott
Top achievements
Rank 2
 answered on 17 Feb 2011
0 answers
93 views
I am using the RadUpload and all is working fine from my machine.  But when I copy the changes up to the web server I get the error in the attachment.

This is running on iis7
<httpHandlers>
     <remove verb="*" path="*.asmx" />
     <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/>
     <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
     <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
     <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
     <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />
     <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/>
   </httpHandlers>
   <httpModules>      
     <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
     <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI"/>
     <add name="ErrorLog" type="Elmah.ErrorLogModule, Elmah" />
     <add name="ErrorMail" type="Elmah.ErrorMailModule, Elmah" />
     <add name="ErrorFilter" type="Elmah.ErrorFilterModule, Elmah" />      >
   </httpModules>

<system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <modules>
      <remove name="ScriptModule" />
      <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="RadUploadModule" preCondition="integratedMode" type="Telerik.Web.UI.RadUploadHttpModule" />
    </modules>
    <handlers>
      <remove name="WebServiceHandlerFactory-Integrated" />
      <remove name="ScriptHandlerFactory" />
      <remove name="ScriptHandlerFactoryAppServices" />
      <remove name="ScriptResource" />
      <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="Telerik_Web_UI_WebResource_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" />      
    </handlers>

I do have this working on another site on the webserver but it is using classic mode where this website is using Integrated mode.
Eric Klein
Top achievements
Rank 1
 asked on 17 Feb 2011
4 answers
361 views
Hi,

I have created a grid based on the demo Grid Programmatic Binding but can not get the grid to expand or collapse.  I added the following code to the pre-render event and the grid opens with the first item expanded and the data is displayed in the detail grid correctly.  But, when I try to collapse the row it will not collapse and none of the other rows will expand. 

Private

 

Sub rgvSecurityGroups_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles rgvSecurityGroups.PreRender
If Not Page.IsPostBack Then
    rgvSecurityGroups.MasterTableView.Items(0).Expanded = True
End If
End Sub

Below is the code for my page.  Thank you for your assistance.

Tracy

 

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/IPSMaster.Master" CodeBehind="WBC SEC Security Groups.aspx.vb" Inherits="IPS_Gateway.WBC_SEC_Security_Groups" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %>
    
<asp:Content ID="cntMain" ContentPlaceHolderID="cphMainContent" runat="server" >
  
  
<asp:SqlDataSource ID="SQLDS_SecurityGroups"     runat="server"  ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"  
        SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroups-SEL-INS-UPD-DEL]"> 
        <SelectParameters>
            <asp:Parameter Name="strCommandType" Type="String" DefaultValue="Select" />
        </SelectParameters>
</asp:SqlDataSource>
  
<asp:SqlDataSource ID="SQLDS_SecurityGroupUsers"     runat="server"  ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"  
        SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroupUsers-Select]" >
</asp:SqlDataSource>
  
<asp:panel ID="pnlPage"   runat="server"  SkinId="skn_GPC01_Panel_MainContent">      
  
     <telerik:RadAjaxManager ID="RadAjaxManager2"  runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="rgvSecurityGroups">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="rgvSecurityGroups" LoadingPanelID="RadAjaxLoadingPanel1" />
                    <telerik:AjaxUpdatedControl ControlID="rwmMessageBox" />
                    <telerik:AjaxUpdatedControl ControlID="rwmSecuritySettings" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" BackgroundPosition="Center"  ZIndex="150"  
        <asp:Image ID="imgLoading" runat="server" ImageUrl='<%$Resources:Images, LoadingBlack %>' AlternateText="Loading"   />
    </telerik:RadAjaxLoadingPanel>
    <asp:HiddenField ID="hdfSecurityId" runat="server" />
  
    <asp:panel ID="pnlPageHeader"                runat="server"  cssClass="css_GPC01_Panel_PageHeading" >       
        <asp:Label ID="txtPageTitle"             runat="server"  CssClass="css_GPC01_Label_PageTitle" Text="Security Groups" />   
        <asp:ImageButton ID="ibtPageInformation" runat="server"  SkinID="skn_GPC01_ImageButton_PageInformation"  />
    </asp:panel>    
  
    <asp:Panel ID="pnlPageContent"               runat="server"  CssClass="css_GPC01_Panel_PageContent" >     
        <telerik:RadGrid ID="rgvSecurityGroups"  runat="server"  DataSourceID="SQLDS_SecurityGroups"   
                EnableEmbeddedSkins = "true"    Skin="Black"
                AllowMultiRowSelection="false" 
                AllowAutomaticDeletes="True" 
                AllowAutomaticInserts="True"  
                AllowAutomaticUpdates="True"  
                AllowPaging="True" 
                EnableViewState ="true"                 
                AutoGenerateColumns="False"
                height="560px">
                                  
            <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" />
            <ClientSettings AllowColumnsReorder="false" EnablePostBackOnRowClick="true" 
                            AllowExpandCollapse="true"  >  
                <Selecting AllowRowSelect="true" />
                <Scrolling AllowScroll="true" UseStaticHeaders="true" />
            </ClientSettings>
            <MasterTableView    DataSourceID="SQLDS_SecurityGroups" DataKeyNames="SecurityID"     
                EditMode="InPlace" CommandItemDisplay="Top"  PageSize="30"   >
                <CommandItemTemplate >
                    <div style="padding: 5px 5px;">
                        <asp:LinkButton ID="lbtAdd"          runat="server" CommandName="InitInsert"     ToolTip ="Add New Group"               Visible='<%# Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgAdd" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,AddRecord20%>" /> Add </asp:LinkButton>  
                        <asp:LinkButton ID="IbtEdit"         runat="server" CommandName="EditSelected"   ToolTip ="Edit Group"                  Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'>          <asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images, EditRecord20%>"/> Edit </asp:LinkButton>  
                        <asp:LinkButton ID="IbtCancel"       runat="server" CommandName="CancelAll"      ToolTip ="Cancel Edit/Add"             Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 Or rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgCancel" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,CancelRecord20%>" /> Cancel </asp:LinkButton>  
                        <asp:LinkButton ID="lbtSaveNew"      runat="server" CommandName="PerformInsert"  ToolTip ="Save New Group"              Visible='<%# rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="imgSaveNew" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" /> Save New</asp:LinkButton>  
                        <asp:LinkButton ID="lbtDelete"       runat="server" CommandName="DeleteSelected" ToolTip ="Delete Group"                Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgDelete"       runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,DeleteRecord20%>" />Delete </asp:LinkButton>  
                        <asp:LinkButton ID="lbtSave"         runat="server" CommandName="UpdateEdited"   ToolTip ="Save Changes"                Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 or rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" />  Update </asp:LinkButton>  
                        <asp:LinkButton ID="ibtSettings"     runat="server" CommandName="ShowSettings"   ToolTip ="Edit/View Security Settings" Visible='<%# rgvSecurityGroups.EditIndexes.Count=0 AND Not rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="Image1" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SecuritySettings20%>" /> Security Settings  </asp:LinkButton>  
                        <asp:LinkButton ID="lbtRefresh"      runat="server" CommandName="RebindGrid"     ><asp:Image id="imgRefresh" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$Resources:Images, ReloadBlue16 %>" AlternateText ="Refresh Grid" /></asp:LinkButton>                     
                    </div>
                </CommandItemTemplate>
                <Columns>
                    <telerik:GridBoundColumn DataField="SecurityId"     UniqueName="SecurityID"     HeaderText="Security Id"        HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="80px"    ItemStyle-HorizontalAlign="Center"  DataType="System.Int32" ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="SecurityGroup"  UniqueName="SecurityGroup"  HeaderText="Group"              HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="200px"   ColumnEditorID ="gtcEditor1"/>
                    <telerik:GridBoundColumn DataField="UserCount"      UniqueName="UserCount"      HeaderText="User Count"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="80px"    ItemStyle-HorizontalAlign="Center"  DataType="System.Int32" ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="CreatedBy"      UniqueName="CreatedBy"      HeaderText="Created By"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Left"    ReadOnly="true"  />
                    <telerik:GridBoundColumn DataField="CreatedDate"    UniqueName="CreatedDate"    HeaderText="Created Date"       HeaderStyle-HorizontalAlign="Center"   HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Center"  DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}"   ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="UpdatedBy"      UniqueName="UpdatedBy"      HeaderText="Updated By"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Left"    ReadOnly="true" />
                    <telerik:GridBoundColumn DataField="UpdatedDate"    UniqueName="UpdatedDate"    HeaderText="Updated Date"       HeaderStyle-HorizontalAlign="Center"   HeaderStyle-Width="130px"   ItemStyle-HorizontalAlign="Center"  DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}" ReadOnly="true" />                           
                </Columns>    
                <DetailTables>
                    <telerik:GridTableView   DataKeyNames="SecurityObject" >
                        <Columns>
                            <telerik:GridBoundColumn DataField="UserId"          UniqueName="UserID"         HeaderText="User Id"           HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="50px"    ItemStyle-HorizontalAlign="Center"  ReadOnly="true" DataType="System.Int32"  />
                            <telerik:GridBoundColumn DataField="UserName"        UniqueName="UserName"       HeaderText="User Name"         HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"   />
                            <telerik:GridBoundColumn DataField="SecurityObject"  UniqueName="SecurityObject" HeaderText="Security Object"   HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"  DataType="System.Int32"  />
                            <telerik:GridBoundColumn DataField="UserLoginId"     UniqueName="UserLoginId"    HeaderText="Login Id"          HeaderStyle-HorizontalAlign="Left"     HeaderStyle-Width="150px"   />
                            <telerik:GridBoundColumn DataField="UserStatus"      UniqueName="UserStatus"     HeaderText="Status" />
                            <telerik:GridBoundColumn DataField="EmployeeStatus"  UniqueName="EmployeeStatus" HeaderText="Employee Status" />
                        </Columns>
                    </telerik:GridTableView>
                </DetailTables>                
            </MasterTableView>
        </telerik:RadGrid>
        <telerik:GridTextBoxColumnEditor ID="gtcEditor1" runat="server" TextBoxStyle-Width="200px" />     
        <telerik:RadWindowManager ID="rwmMessageBox" runat="server" Behaviors="Close, Move"  EnableViewState ="false" Animation="Slide" AnimationDuration="5"  Height="400" Width = "400" VisibleOnPageLoad ="true" DestroyOnClose="true"  Modal="true"   EnableEmbeddedSkins="true" Skin="Black" />
        <telerik:RadWindowManager ID="rwmSecuritySettings" runat="server" Behaviors="Close, Move"  EnableViewState ="false" Animation="Slide" AnimationDuration="5"  Height="700" Width = "835" VisibleOnPageLoad ="true" DestroyOnClose="true"  Modal="true"  Style="z-index:3000"  />
        <br />
    </asp:Panel>
</asp:panel
<asp:Panel ID="pnlFooter" runat="server" CssClass="css_GPC01_Panel_Footer">
        <asp:Label ID="lblObjectId"              runat="server"  CssClass="css_GPC01_Label_Tiny" />
</asp:Panel>
</asp:Content>
Private Sub rgvSecurityGroups_DetailTableDataBind(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles rgvSecurityGroups.DetailTableDataBind
       Dim SelectedRow As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)
       Dim intSecurityObject As Int32 = SelectedRow.GetDataKeyValue("SecurityID")
       SQLDS_SecurityGroupUsers.SelectParameters.Clear()
       SQLDS_SecurityGroupUsers.SelectParameters.Add("intObjectId", Convert.ToInt32(intSecurityObject))
       e.DetailTableView.DataSourceID = "SQLDS_SecurityGroupUsers"
   End Sub

Tracy
Top achievements
Rank 1
 answered on 17 Feb 2011
7 answers
179 views
Hi, we have a large dataset of nearly 200 columns by 250 rows. On screen, the grid presentation is normal with a row-per-record as it should be. However, when exported to Excel and opened in Excel 2008, each record shows in two rows with one row being blank. This results in a row count that is 2x what it should be.

When selecting an individual data item in the resulting excel file, two cells are selected.

The data does not appear to be grouped, at least as far as Excel is concerned.

We have attempted a variety of 'tricks' in Excel to remove the extra rows, but none are perfect and some result in lost data.

Is the issue (2 rows in excel) known and if so, how can we resolve this so that ideally, the excel file appears as it does on screen? We are using .net 2 framework and telerik 2010 Q1 (2010.1.309.20) for this application. Thanks.

Daniel
Telerik team
 answered on 17 Feb 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?