using a RadTreeList I wonder how to hide the expand / collaps Icon when there are no records under parent item
What I found within this platform is
http://www.telerik.com/help/aspnet-ajax/grid-hide-expand-collapse-images-when-no-records.html
but as far as I can see this does not work for RadTreeList, doesn't it?
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
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?
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
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.
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.
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();
}
}
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