Questions on UI for ASP.NET AJAX Forum

4 answers

335 views

Hi,

I have several InPlace editable RadGrids on my page located in an asp:DetailsView (together with other fields). The problem is when users update the grid(s) and do not commit changes by pressing the small Update button in a grid's row. Then, when they press the Update button of DetailsView all their changes are lost.

Is there any way to determine if a grid has any pending changes? Something like RadGrid.IsDirty property?

Thanks,

Leszek

Grid

answered on 22 Apr 2015

6 answers

695 views

GridClientSelectColumn and onchange event in radgrid GridTemplateColumn

I have a Radgrid with following items in a row-

GridClientSelectColumn
Several Template column Text Box
Few Template column RadDatePicker

On the client side I want to check "GridClientSelectColumn- checkbox " when a user changes value ( Onchange event ) in the template columns ( textbox/Date field )

How do I achieve it on the client side for multiple controls ( textbox/Date field )

thanks

Grid

answered on 22 Apr 2015

3 answers

144 views

GridDateTimeColumn EnableRangeFiltering defaults

I would like to know how to set the defaults of the From and To dates in a GridDateTimeColumn with EnableRangeFiltering="true".

My questions are in particular:

1) how do I set the From and To dates, and which date format should I use when setting them (dd/mm/yyyy, mm/dd/yyyy or yyyy/mm/dd) and which separator (/, - or .)?

2) how do I set the filter to be *between* the From/To dates and don't let the user to change it (not the dates, the type of filter)?

If there is a documentation page where these questions are answered then could you please share the link to it?

Grid

answered on 22 Apr 2015

2 answers

232 views

[Solved] RadGrid filter on label in GridTemplateColumn

Hi,

I have a RadGrid with a GridTemplateColumn that has a label inside it. This label is populated after the initial datatable is bound to the grid.

Is there any way that I can filter on the contents of this label without having it in my initial datatable?

Here is my template column

<telerik:GridTemplateColumn AllowFiltering="true" HeaderText="Type(s)" UniqueName="column10"

AutoPostBackOnFilter="true" ShowFilterIcon="false">

<ItemTemplate>

<asp:Label ID="LocationTypeLabel" runat="server"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

This is how I populate the label. The datatable _dtTypes is actually the second table returned in the dataset whereas the first table is the datasource of the grid.

For Each dr As DataRow In _dtTypes.Select("CustomerID = " & e.Item.DataItem("CustomerID"))

lbl.Text = lbl.Text & dr("LocationType") & ", "

Next

Grid

answered on 22 Apr 2015

3 answers

477 views

GridBoundColumn displaying the same date format regardless of DataFormatString settings.

Hi,

My grid has 2 collumns showing dates from the datasource which is hooked up to the database.

I serached for a fix for this and found alot of diffrent solutions yet none of them seem to work for me.

Column in grid:

<telerik:GridBoundColumn DataField="created_date" DataType="System.DateTime" FilterControlAltText="Filter created_date column" HeaderText="created date" SortExpression="created_date" UniqueName="created_date" FilterControlWidth="75px" DataFormatString="{0:yyyy/MM/dd}" meta:resourcekey="GridBoundColumnResource24">

</telerik:GridBoundColumn>

DataBase:

Output:

Any suggestions is much appriciated.

Grid

answered on 22 Apr 2015

2 answers

174 views

RadGrid paging and ItemDatabound

Hello,

My Radgrod is paged (no custom paging).

On Itemdatabound i am trying to set an url to GridHyperLinkColumn

But ItemDataBound isnt called if I switch to another page.

Is there any way to call ItemDataBound when switching to another page with RadGrid?

Thanks in advance.

Grid

answered on 22 Apr 2015

2 answers

315 views

RadGrid: some buttons and filters not working

I am trying to recreate the example in the following demo:

http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/export-word-csv/defaultcs.aspx

In my case filtering by column is allowed and the data source is set in the code behind through the RadGrid1NeedDataSource method.

The data is loaded correctly and shown in the table, sorting by clicking on the column names work, the page navigation at the bottom-left corner works fine.

I am facing two problems:

1) The buttons located at the bottom-center for going to a specific page and changing the page size don't work.

2) None of the filters work, entering any text doesn't have any effect and pressing any filter icon, while using the IE F12 DevTools debugger, shows the following error:

SCRIPT5007: Unable to get property '_showFilterMenu' of undefined or null reference<br>File: script block (377), Line: 3, Column: 1

Do you have any idea how I could fix it?

My source code follows:

<form id="form1" runat="server">

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" EnableScriptCombine="False" />

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">

<asp:button id="Button1" text="Export to CSV" onclick="ExportToCvs" runat="server" />

<telerik:RadGrid ID="RadGrid1" Skin="Silk" AutoGenerateColumns="false"

AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True"

PageSize="10" OnNeedDataSource="RadGrid1NeedDataSource" EnableLinqExpressions="false" runat="server">

<ExportSettings HideStructureColumns="true" />

<MasterTableView Width="100%" AllowFilteringByColumn="True">

<PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>

<Columns>

<telerik:GridBoundColumn DataField="Column1" HeaderText="Column1" />

<telerik:GridDateTimeColumn DataField="Column2" UniqueName="Column2" HeaderText="Column2"

PickerType="DatePicker" EnableRangeFiltering="true" FilterControlWidth="110px"

EditDataFormatString="dd.mm.yyyy" DataFormatString="{0:dd/mm/yyyy}" DataType="System.DateTime"

ShowFilterIcon="false" CurrentFilterFunction="Between" />

<telerik:GridBoundColumn DataField="Column3" HeaderText="Column3" />

</Columns>

<ItemStyle BackColor="#DFDFDF" />

<HeaderStyle BackColor="#FFFFFF" ForeColor="#767676" />

<AlternatingItemStyle BackColor="#FFFFFF" />

</MasterTableView>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

</form>

In the code behind:

protected void RadGrid1NeedDataSource(object source, GridNeedDataSourceEventArgs e) {

using (SqlConnection conn = new SqlConnection(Settings.Default.ConnectionString)) {

DataContext db = new DataContext(conn);

Table<Item> items = db.GetTable<Item>();

IEnumerable<Item> query = from x in items select x;

RadGrid1.DataSource = query.ToList();

}

Grid

answered on 22 Apr 2015

2 answers

127 views

Rad Control issue in IE11

Hi Telerik team,

We are using Telerik version 2008.2.1001.35 and are encountering few issues in IE11 due to the version. Please find the issues explained below -
1.       We have a Grid view alignment issue where the row alignment is not proper in the grid.
2.       The text in one column of the grid is overlapping with the next column.
3.       While disabling a control it turns greyed out. But in this version of Telerik, the text is disabled but the borders and icons of the control are in blue color.

Please let us know as to how to resolve the above issues.

Regards,
Siva
CMS Dev Team,
CitiDirect

Grid

answered on 22 Apr 2015

6 answers

717 views

Excel export of RadGrid not working when grouped by a column

Hi,

I am using a Radgrid which have footer and groupfooter. But the excel export of the Radgrid is not working properly when it is grouped.

The code which I used to export to Excel is below.

private void lnkExport_Click(object sender, System.EventArgs e)
  {

            uwgAllocationCount.ExportSettings.FileName = "CountSummary " ;
            uwgAllocationCount.ExportSettings.IgnorePaging = true;
            uwgAllocationCount.ExportSettings.OpenInNewWindow = true;
            uwgAllocationCount.MasterTableView.UseAllDataFields = true;
            uwgAllocationCount.ExportSettings.ExportOnlyData = true;
            uwgAllocationCount.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;
            uwgAllocationCount.ExportSettings.HideStructureColumns = false;
            uwgAllocationCount.MasterTableView.HierarchyDefaultExpanded = true;
            uwgAllocationCount.ExportSettings.SuppressColumnDataFormatStrings = false;
            uwgAllocationCount.MasterTableView.ExportToExcel();
  }

I have even tried GridExcelExportFormat.HTML, insted of GridExcelExportFormat.Biff, but it is showing only the grouped headers. It is not exporting the grouped data.

Please help.

Thanks

Prasanth

Grid