I have a RadGrid which gets populated with data from a SQL Server database. One of the columns in the RadGrid shows data that was collected from a multiline textbox (which allows user to obviously enter carriage returns). In the codebehind of my aspx page, I convert the database line breaks to BR tags so that the column properly displays the line breaks in the browser. I give users the ability to export the grid to excel, however, I just noticed that the BR tags are causing extra rows to be created in the excel file that gets generated (a new row is created in the excel file for each BR tag instead of keeping all the data for each record in one row). Here is the code I use to generate the excel file:


How do I fix this? What are my options?

Hi ,

I'm facing one strange issue

In RAD grid ,i have an edit icon as shown in IMG1. First time when I Click on Edit Icon RAD grid scroll position is remains same not going down as shown in IMG2. But the scroll position suppose to be like shown in IMG3

But second time when i click on edit icon in rad grid scroll position is going down as expected as shown like in IMG3.

My issue is when i load the page first time and click on edit icon in rad grid , getting the scrollbar issue.


and my code for the above is shown in IMG4

Hi,

I have one bring string and I would like my text to move  one word at a time to  the left of screen and load new character on right of screen at the same time.  Can you provide some sample code for this?

Thanks,
Prava

Hi !!

I have a RadEditor in aspx page and aspx page is in a RadWindow. Now, I want to hide the "page attributes" section from "page properties" dialog and shrink it to fit with rest sections i.e Body Attribute and Margins.

I tries a lot using javascript and jQuery but I am not getting the result. Please see attached image. Awaiting for your valuable response.

Thanks

Hello,

I am trying to set the time of a RadTimePicker from CodeBehind. No matter how I do it a date always shows in the TimePicker. When I click into the control the time I set is there; hwoever, it goes back to date when it loses focus.

If I set the Time with the RadTimePicker, it shows the time, even after losing focus.

It is very confusing why a time picker would even contain selected date properties as it is a time.

I have tried this a suggested in the forums but id doesn't work for me either.

Any suggestions?

Thanks,
John S.

hi,

I have radgrid ,its showing two others column but in database view its only exists, Bold column not exists in view. 

I attached output of radgrid.

View's Column
---------------------
 ,[StartDate]      ,[EndDate]      ,[DepartmentName]      ,[LabourRate]      ,[BillingRate]      ,[AgencyRate]      ,[FirstName]      ,[LastName]
 ,[Description]      ,[ManagerFirst]   ,[ManagerLast]     ,[WeekEnding]    ,[Hours]    ,[RateType]  ,[TimesheetStatus]  ,[TimesheetID]

---------------------


<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <h1>Current Contractors</h1>
    <br/>
        <telerik:RadButton ID="RadButton1" runat="server" onclick="RadButton1_Click" 
        Text="Previous">
    </telerik:RadButton>
    <telerik:RadButton ID="RadButton2" runat="server" onclick="RadButton2_Click" 
        Text="Next">
    </telerik:RadButton>
    <br/>
    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" 
        CellSpacing="0" DataSourceID="ObjectDataSource1" GridLines="None" 
        AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" 
        ExportSettings-FileName="Payroll Report" ExportSettings-ExportOnlyData="False" 
        ExportSettings-HideStructureColumns="True" ExportSettings-IgnorePaging="True" 
        ExportSettings-OpenInNewWindow="True" 
         
 >
<MasterTableView DataKeyNames="Name,StartDate,EndDate,DepartmentName,LabourRate,FirstName,LastName,Description,ManagerFirst,ManagerLast,WeekEnding,RateType,TimesheetStatus" 
            DataSourceID="ObjectDataSource1" CommandItemDisplay="Top"
            CommandItemSettings-ShowExportToCsvButton="True" CommandItemSettings-ShowExportToExcelButton="True" CommandItemSettings-ShowExportToPdfButton="True"  CommandItemSettings-ShowExportToWordButton="True" CommandItemSettings-ShowAddNewRecordButton="False" CommandItemSettings-ShowRefreshButton="False" CommandItemStyle-HorizontalAlign="Left"
  
            >
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>

    <Columns>
                <telerik:GridBoundColumn DataField="ContractorName" FilterControlWidth="20px" 
            FilterControlAltText="Filter ContractorName column" HeaderText="Contractor" 
            ReadOnly="True" SortExpression="FirstName" UniqueName="ContractorName"  >
        </telerik:GridBoundColumn>

        
        <telerik:GridBoundColumn DataField="Description" 
            FilterControlAltText="Filter Description column" HeaderText="Job" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="Description" UniqueName="Description">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="ManagerName" 
            FilterControlAltText="Filter ManagerName column" HeaderText="Manager" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="ManagerFirst" UniqueName="ManagerName"  >
        </telerik:GridBoundColumn>


      

       
        <telerik:GridBoundColumn DataField="AgencyRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}"
            FilterControlAltText="Filter AgencyRate column" HeaderText="Agency Rate" 
            SortExpression="AgencyRate" UniqueName="AgencyRate">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="LabourRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}"
            FilterControlAltText="Filter LabourRate column" HeaderText="Labour Rate" 
            ReadOnly="True" SortExpression="LabourRate" UniqueName="LabourRate">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="BillingRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}" 
            FilterControlAltText="Filter BillingRate column" HeaderText="Billing Rate" 
            SortExpression="BillingRate" UniqueName="BillingRate">
        </telerik:GridBoundColumn>


       <telerik:GridBoundColumn DataField="StartDate" DataType="System.DateTime" FilterControlWidth="20px" DataFormatString="{0:dd/MM/yyyy}"
            FilterControlAltText="Filter StartDate column" HeaderText="Start" 
            ReadOnly="True" SortExpression="StartDate" UniqueName="StartDate">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="DepartmentName" 
            FilterControlAltText="Filter DepartmentName column" HeaderText="Department" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="DepartmentName" UniqueName="DepartmentName"  >
        </telerik:GridBoundColumn>
        
  <telerik:GridBoundColumn DataField="Name" FilterControlWidth="20px" 
            FilterControlAltText="Filter Name column" HeaderText="Name" ReadOnly="True" 
            SortExpression="Name" UniqueName="Name" >
        </telerik:GridBoundColumn>        

        <telerik:GridBoundColumn DataField="Hours" DataType="System.Int32" FilterControlWidth="20px" 
            FilterControlAltText="Filter Hours column" HeaderText="Hours" 
            SortExpression="Hours" UniqueName="Hours">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="RateType" FilterControlWidth="20px" 
            FilterControlAltText="Filter RateType column" HeaderText="RateType" 
            ReadOnly="True" SortExpression="RateType" UniqueName="RateType">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="TimesheetStatus" FilterControlWidth="20px" 
            FilterControlAltText="Filter TimesheetStatus column" 
            HeaderText="Status" ReadOnly="True" SortExpression="TimesheetStatus" 
            UniqueName="TimesheetStatus">
        </telerik:GridBoundColumn>
    </Columns>

<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>
    </telerik:RadGrid>
   

      <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
        SelectMethod="GetPayrollReport" TypeName="Business.PayrollReportList"  
                SortParameterName="sortBy"
        >
          <SelectParameters>
            <asp:SessionParameter SessionField="WeekEnding" DbType="DateTime" Name="WeekEnding" />
        </SelectParameters>
    </asp:ObjectDataSource>
</asp:Content>

My group is working on software that is used by several public schools. The UI has to be Section 508 compliant (for students with disabilities, etc), which includes being able to navigate the site using only the keyboard. Currently, we're making sure (using only the keyboard) a user can effectively [TAB] to all controls. The issue we're facing is that the DockCommands generated are skipped when tabbing through the UI. We're creating the DockCommands programatically in the C# code like this:

var cmd = new DockCommand();
cmd.AutoPostBack = true;
cmd.Name = commandText;
cmd.Text = commandText;
cmd.CssClass = cssClass;

However, this seems to always create an anchor tag with an empty span tag nested inside. The span contains a background image. Because the anchor has no href attribute and the image is just a background of the span, the tab skips right over it.

Are we doing something wrong? Or is there a way to work around this?

Any help would be much appreciated. Thanks.

Hi,

(1) if a there is not <br />  tag in any data item then grid does displays all rows and also vertical scroll bar is not visible then.

(2) if a there is <br />  tag  in any data item (for multi-line text in a row) then grid does not display all rows (displays rows untill the row with <br /> tag) and also vertical scroll bar is visible then.

How can I have same behavior mentioned in (1) with <br /> tag.

Hello,
I am having an issue where I have a multi-line RadEditor and when the user enters any text into the editor then submits that content to be saved to the database, RadEditor is adding a non-breaking space (see attachment).  I wanted to know how this can be prevented in the RadEditor through configuration instead of lots of find and replaces each time a RadEditor is used.

In SQL Server this is CHAR(13)+CHAR(10) in UTF-8 encoding on Regex.Replace(Input, "\u00A0", "").

In my aspx page I do this:

 
   then in the referenced js file I have this:





However, ddlTicketTypeList is always null. 

How do I resolve what is inside the code block using the referenced js files?