Questions on UI for ASP.NET AJAX Forum

5 answers

521 views

I need to format a columns datetime Display, but keep it's value in both the RadGrid And Excel Export using Biff(or someway)

<telerik:GridBoundColumn DataField="Recorded Date2" <br> FilterControlAltText="Filter Reported Date column" HeaderText="Reported Date" <br

>            ReadOnly="True" SortExpression="Recorded Date" UniqueName="Recorded_Date" ItemStyle-HorizontalAlign="Right" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy}"><

br> </telerik:GridBoundColumn>

I want my column to Display 06/18/13 in my Grid.

And I want it to Display 06/18/13 in my Excel Export.

However, I want my DateTime field in Excel to Retain it's DateTime attribute and be sortable.

Tuesday, June 18, 2013 8:00:00 AM	06/18/13
Tuesday, June 18, 2013 8:00:00 AM	Tuesday, June 18, 2013 12:00:00 AM

This is my export before and after. I modified the Excel Cell Format of column B2 after export. I want it to display Tuesday, June 18, 2013 8:00:00 AM instead of Tuesday, June 18, 2013 12:00:00 AM.

Grid

answered on 21 Jun 2013

1 answer

71 views

is it possible to export multiple grids into individual worksheets in an excel file

I've got a page with 4 grids on it. For exporting we have a button that uses the following code to export the data.

protected void ExportToExcel_Click(object sender, EventArgs e)

{

RG.ExportSettings.ExportOnlyData = true;

RG.ExportSettings.IgnorePaging = true;

RG.ExportSettings.OpenInNewWindow = true;

RG.ExportSettings.FileName = "Assessment_Outcomes_Detail_" + DateTime.Today.Month.ToString() + "_" + DateTime.Today.Day.ToString() + "_" + DateTime.Today.Year.ToString();

RG.MasterTableView.ExportToExcel();

}

Is it possible to do something so that each grid is placed into a worksheet and then the excel file exported? Instead of having our user export each grid into its own excel file.

thanks

Grid

answered on 21 Jun 2013

1 answer

123 views

Get Editor and Expression

Hi All,

I have created a custom RadFilterDataFieldEditor to manage a specific set of my data. I need to do some additional work in code with any expressions created that are using this Editor (but only when they use a specific operator - Equal To).

Looking at the code, I can't seem to get the expression and the Editor at the same time. If I get to the RadFilterSingleExpressionItem, it has an Editor property that I can see at runtime, but is protected - so I can't access it. The Expression itself doesn't seem to have a link, and if I go in via the FieldEditors property on the RadFilter, I can get the Editors but they don't seem to have a link to the expression.

Basically, I want to do the below (aircoded):

If typeof(Editor) is MyCustomEditor and expression.FilterFunction = EqualTo Then

'Do Custom Work

End If

Can anyone point out how to achieve this?

Thanks
Fergal

Filter

answered on 21 Jun 2013

7 answers

240 views

Client side Grid binding and passing params to service

I am creating a search form, where the result is displayed in the RadGrid. I'm binding the Grid to a wcf Service.

<DataBinding SelectMethod="GetDataAndCount" Location="../Services/RecordService.svc" SortParameterType="Linq"

FilterParameterType="Linq" CountPropertyName="Count">

</DataBinding>

</ClientSettings

>

I can not send the extra search fields to the service and rebind the grid without having to do a full page post back.

My Service looks like

public ResultData<Record> GetDataAndCount(int startRowIndex, int maximumRows, string sortExpression, string

filterExpression)

I want it to look something along these lines

public ResultData<Record> GetDataAndCount(int startRowIndex, int maximumRows, string sortExpression, string filterExpression, RecrodSearchCriteria

criteria)

Any help would be greatly appreciated. This will make or break my decision to go with Telerik controls or not.

Thanks
Bullish

Grid

answered on 21 Jun 2013

1 answer

218 views

How to show menu align on left side when it drops down

by default it always goes to the right side.

same problem as here
https://forums.digitalpoint.com/threads/how-to-show-drop-down-menu-expanding-on-left-side.2037316/

solution is basically to add this style to telerik menu:

ul.alignleft {

left:-100px;

}

but how the * do I do this? I tried for hours

Menu

answered on 21 Jun 2013

0 answers

108 views

Maintaining drag-and-drop state of RadTreeView on client side without postback?

I have a RadTreeView

<telerik:RadTreeView ID="RadTreeView1" runat="server" EnableDragAndDrop="True"

EnableDragAndDropBetweenNodes="true" DataFieldID="CategoryID" DataFieldParentID="ParentID"

DataSourceID="LinqDataSource1" DataTextField="Name" DataValueField="CategoryID"

AllowNodeEditing="False" ExpandAnimation-Duration="150" OnNodeCheck="RadTreeView1_NodeCheck"

OnNodeDataBound="RadTreeView1_NodeDataBound" CheckBoxes="True"

OnClientNodeDropping="onNodeDropping">

I want to save my drag-and-drop using client calls with ajax. I'm able to get all the information I need with onNodeDropping but the client state is not persistent. After the drop the node goes back to the original position. If I do a postback and rebind the tree then it works fine but I don't want to do a postback.
Thank you

TreeView

asked on 20 Jun 2013

1 answer

110 views

RadNumericTextBox and scientific notation

Hello,
how to allow a user to enter a number type 1.2e-36 in a radnumnertextebox ?
Thanx

Input

answered on 20 Jun 2013

0 answers

141 views

Empty value in RadComboBox

i'm new in telerik control ,
i use ASP gridview with TemplateField,EditItemTemplate,RadComboBox
i use column in database that allow null value .
i want empty value in RadComboBox that can update value with null in side gridview.

ComboBox

asked on 20 Jun 2013

1 answer

31 views

RadScheduler

I have a radscheduler starting from 04:00:00 am to 03:59:00 am tomorrow but the problem is when it display in appointment in monthview the appointment goes next day also how can i display that only for one day.

General Discussions

answered on 20 Jun 2013

2 answers

215 views

Default Grid to 1st 50 rows

How can I defualt my grid to show the 1st 50 rows. I have basic paging turned on, and the users have requested that the grid defualt to 50 rows instead of them having to pick the 50 option in the paging. Some of the grid don't have 50 rows however and in this case they just want to show all.

<telerik:RadGrid ID="myRadGrid" runat="server" Width="100%" Skin="Web20">

<MasterTableView AutoGenerateColumns="false" Font-Size="10" DataKeyNames="intScheduleId" CommandItemDisplay="Top" AllowPaging="true" AllowSorting="true">

<HeaderStyle ForeColor="White" Font-Bold="true" HorizontalAlign="Center" />

<ItemStyle HorizontalAlign="Center"/>

<AlternatingItemStyle BackColor="#B0C4DE" HorizontalAlign="Center" />

<PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" />

<CommandItemStyle Height="25px" Font-Bold="true" Font-Underline="true" HorizontalAlign="Left" VerticalAlign="Bottom" />

Grid

answered on 20 Jun 2013