Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
123 views

I create a RadGrid in code behind which works perfectly fine.

Now I need (additionally to the server-side filtering when clicking a filter menu entry) to add client-side filtering when the user presses the "Enter" key.

This also works perfectly fine, because I add to every GridFilteringItem an OnKeyPress event handler to the filter-TextBox in ItemCreated:

textBox.Attributes.Add("onkeypress", string.Format("doFilter(this, event,'{0}', Telerik.Web.UI.GridFilterFunction.Contains)", Grid.ClientID));

 

My Problem:

I cannot find a possibility to add the event handler to the filter-TextBox of the GridDateTimeColumn.

How can I do that?

Eyup
Telerik team
 answered on 26 Apr 2016
7 answers
309 views
Hi, All:

I have a RadDatePicker inside my RadGrid, and I do a Update-All:

<

rad:GridTemplateColumn HeaderText="DateIn" DataField="DateIn" SortExpression="DateIn">
<EditItemTemplate>
<rad:RadDatePicker ID="RadDateTimePicker1" runat="server" Culture="English (United States)"
DbSelectedDate='<%# Bind("DateIn", "{0:D}") %>'>
<DateInput runat="server" />

update-all:

foreach (Telerik.Web.UI.GridEditableItem editedItem in rgJobInv.EditItems)
{
Hashtable newValues = new Hashtable();
e.Item.OwnerTableView.RetrieveNullAsDBNull =
true;
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);

but, null was passed to my stored procedure from the RadDatePicker, when I enter '8-28-2008'.

Please help.

Stanley

Eyup
Telerik team
 answered on 26 Apr 2016
6 answers
676 views
Hello,
We use RadGrid to populate 2500 rows from the DB with a gridtemplatecolumn containing a RadDatePicker with name "dtpStart"
How do we trigger the RadDatePicker event, when it is changed so that we change a value of other Datepicker in the same row..

Need Solution......Thanks
Eyup
Telerik team
 answered on 26 Apr 2016
1 answer
104 views

Hi Telerik Team,

I want to restrict adding new appointments on to the scheduler (datasource binding) for a specific category ("Personal" for example)

i.e. :

>it wont be possible to add a new appointment either by right click or double click, The added appointement will be saved as "Personal" category.

>Edit Personal Appointements only, the other appointements categories are not editable

what is the solution to restrict adding the new appointments please.?

Thanks & Regards

Hristo Valyavicharski
Telerik team
 answered on 26 Apr 2016
1 answer
94 views

Hi,

After some workaround about creating RadPersistenceManagerProxy dinamically and checking some examples from the website I can´t find any information about this.

This is the scenario. I have class CustomGrid that inherits from RadGrid. Within this class I tried without success to create a RadPersistenceManagerProxy so I would have it for every page. I tried to do it in the page code, in the class itself and in different events without succes.

Is there any way to do it?

I would like to have this feature so I would not have to create it manually in every page.

Thanks in advance.

Eyup
Telerik team
 answered on 26 Apr 2016
1 answer
195 views

Hi,

 

I'am using the RadGrid with a GridDateTimeColumn with rangefiltering. The custom lay-out is to put both calender filters next to each other. I need to display them below each other and therefor I've used the solution to rearange them in the ItemDataBound event.

However when I use the nested view in the grid, the filter resets to it's original lay-out.

 

The problem is the nestedview triggers the databound event with the GridNestedViewItem and not the GridFilteringItem.

 

Could you please help?

 

Code:

<telerik:RadGrid ID="rgdLaadOrder" runat="server" CellSpacing="0" DataSourceID="qOverview" GridLines="None" Skin="AlfonsFreriks" EnableEmbeddedSkins="false"
   PageSize="10" ClientSettings-EnableRowHoverStyle="True" AllowPaging="true" OnItemCommand="rgdLaadOrder_ItemCommand" Width="1124px" OnInit="rgdLaadOrder_Init"
   AllowFilteringByColumn="True" AutoGenerateColumns="False" EnableLinqExpressions="False" OnItemDataBound="rgdLaadOrder_ItemDataBound" OnItemCreated="rgdLaadOrder_ItemCreated">
   <PagerStyle Mode="NextPrevAndNumeric" />
   <ExportSettings OpenInNewWindow="true" FileName="Export">
     <Pdf ContentFilter="Ascii85" BorderType="AllBorders" PageWidth="297mm" PageHeight="210mm">
       <PageHeader>
         <LeftCell TextAlign="Left" />
         <MiddleCell TextAlign="Left" />
         <RightCell TextAlign="Left" />
       </PageHeader>
     </Pdf>
   </ExportSettings>
   <ClientSettings EnableRowHoverStyle="True" EnablePostBackOnRowClick="True">
     <Selecting AllowRowSelect="true" />
   </ClientSettings>
   <MasterTableView NoMasterRecordsText="Er zijn geen laadorders te tonen" AutoGenerateColumns="false" TableLayout="Auto" HierarchyLoadMode="ServerOnDemand"
     DataKeyNames="LaadOrderNummer, LAADADRESNUMMER, LOSADRESNUMMER">
     <NestedViewSettings DataSourceID="qItem">
       <ParentTableRelation>
         <telerik:GridRelationFields DetailKeyField="LaadOrderNummer" MasterKeyField="LaadOrderNummer" />
         <telerik:GridRelationFields DetailKeyField="LaadAdresNummer" MasterKeyField="LAADADRESNUMMER" />
         <telerik:GridRelationFields DetailKeyField="LosAdresNummer" MasterKeyField="LOSADRESNUMMER" />
       </ParentTableRelation>
     </NestedViewSettings>
     <NestedViewTemplate>
       <asp:Repeater ID="rptAgendaItem" runat="server" DataSourceID="qItem">
       <ItemTemplate>
         <div class="cellLinks">
           <%# Eval("Titel") %>
         </div>
         <div class="cellRechts">
           <%# Eval("Waarden") %>
         </div>
       </ItemTemplate>
       <SeparatorTemplate>
         <br style="clear:both;" />
       </SeparatorTemplate>
     </asp:Repeater>
     </NestedViewTemplate>
     <Columns>
       <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="ncr" HeaderText="NCR" Display="false">
         <HeaderStyle Width="28px" />
         <ItemStyle Width="28px" />
         <ItemTemplate >
           <asp:Image runat="server" ID="imgStatus" ImageUrl="~/Assets/Images/status/INFO_RED.png" Visible='<%# (int)Eval("AANTALNCR") > 0 %>' />
         </ItemTemplate>
       </telerik:GridTemplateColumn>
       <telerik:GridBoundColumn DataField="LaadOrderNummer" HeaderText="Nummer" UniqueName="LaadOrderNummer" AllowFiltering="false" Display="false"/>
       <telerik:GridBoundColumn DataField="LaadInfoDefinitiefJN" HeaderText="LaadInfoDefinitiefJN" UniqueName="LaadInfoDefinitiefJN" AllowFiltering="false" Display="false"/>
       <telerik:GridBoundColumn DataField="LosInfoDefinitiefJN" HeaderText="LosInfoDefinitiefJN" UniqueName="LosInfoDefinitiefJN" AllowFiltering="false" Display="false"/>
       <telerik:GridBoundColumn DataField="LAADADRESNUMMER" HeaderText="LAADADRESNUMMER" UniqueName="LAADADRESNUMMER" AllowFiltering="false" Display="false"/>
       <telerik:GridBoundColumn DataField="LOSADRESNUMMER" HeaderText="LOSADRESNUMMER" UniqueName="LOSADRESNUMMER" AllowFiltering="false" Display="false"/>
 
       <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="link" HeaderText="" Exportable="false">
         <HeaderStyle Width="44px" />
         <ItemTemplate >
           <asp:Image runat="server" ID="imgLink" ImageUrl="~/Assets/Images/afje_wit.png" />
         </ItemTemplate>
       </telerik:GridTemplateColumn>
       <telerik:GridBoundColumn DataField="OPDRACHTNUMMERKLANT" HeaderText="Klant ref." UniqueName="OPDRACHTNUMMERKLANT"
         AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" FilterControlWidth="100%">
         <HeaderStyle Width="180px" />
       </telerik:GridBoundColumn>
       <telerik:GridBoundColumn DataField="LAADORDERDISPLAYNUMMER" HeaderText="Laadordernr" UniqueName="LAADORDERDISPLAYNUMMER"
         AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" FilterControlWidth="100%">
         <HeaderStyle Width="120px" />
       </telerik:GridBoundColumn>
       <telerik:GridDateTimeColumn DataField="LAADDATUM" HeaderText="Laaddatum" UniqueName="LAADDATUM"
         AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false" DataType="System.DateTime"
         DataFormatString="{0:dd-MM-yyyy}" FilterControlWidth="106px" EnableTimeIndependentFiltering="true" EnableRangeFiltering="true">
         <HeaderStyle Width="160px" />
       </telerik:GridDateTimeColumn>
       <telerik:GridBoundColumn DataField="LAADADRESPLAATS" HeaderText="Laadplaats" UniqueName="LAADADRESPLAATS"
         AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" FilterControlWidth="100%">
         <HeaderStyle Width="200px" />
       </telerik:GridBoundColumn>
       <telerik:GridDateTimeColumn DataField="LOSDATUM" HeaderText="Losdatum" UniqueName="LOSDATUM"
         AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false" DataType="System.DateTime"
         DataFormatString="{0:dd-MM-yyyy}" FilterControlWidth="106px" EnableTimeIndependentFiltering="true" EnableRangeFiltering="true">
         <HeaderStyle Width="160px" />
       </telerik:GridDateTimeColumn>
       <telerik:GridBoundColumn DataField="LOSADRESPLAATS" HeaderText="Losplaats" UniqueName="LOSADRESPLAATS"
         AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" FilterControlWidth="100%">
         <HeaderStyle Width="200px" />
       </telerik:GridBoundColumn>
       <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="ncr" HeaderText="NCR" Exportable="false">
         <HeaderStyle Width="40px" />
         <ItemTemplate >
           <asp:ImageButton runat="server" ID="imgStatusRed" ImageUrl="~/Assets/Images/status/bullet_ball_glass_red.png" Visible='<%# (int)Eval("AANTALNCR") > 0 %>' CommandName="NCR_Click" />
           <asp:Image runat="server" ID="imgStatusGreen" ImageUrl="~/Assets/Images/status/bullet_ball_glass_green.png" Visible='<%# (int)Eval("AANTALNCR") == 0 %>' />
         </ItemTemplate>
       </telerik:GridTemplateColumn>
     </Columns>
     <PagerStyle PageSizes="10, 25, 50, 75, 100" PagerTextFormat="{4} Er zijn <strong>{5}</strong> laadorders die overeenkomen met de zoekcriteria"
       PageSizeLabelText="Resultaten per pagina:" AlwaysVisible="true" />
   </MasterTableView>
 </telerik:RadGrid>

 

    protected void rgdLaadOrder_ItemDataBound(object sender, GridItemEventArgs e)
    {
      if (e.Item is GridFilteringItem)
      {
        GridFilteringItem filterItem = e.Item as GridFilteringItem;
 
        (filterItem["LAADDATUM"].Controls[0] as LiteralControl).Text = "<span style='width:45px; display:inline-block;'>" + WebTranslate.GetTranslation("rgdLaadOrderVanFilter") + "</span>";
        (filterItem["LAADDATUM"].Controls[3] as LiteralControl).Text = "<br /><span style='width:45px; display:inline-block;'>" + WebTranslate.GetTranslation("rgdLaadOrderTotFilter") + "</span>";
 
        (filterItem["LOSDATUM"].Controls[0] as LiteralControl).Text = "<span style='width:45px; display:inline-block;'>" + WebTranslate.GetTranslation("rgdLaadOrderVanFilter") + "</span>";
        (filterItem["LOSDATUM"].Controls[3] as LiteralControl).Text = "<br /><span style='width:45px; display:inline-block;'>" + WebTranslate.GetTranslation("rgdLaadOrderTotFilter") + "</span>";
      }
}

 

Eyup
Telerik team
 answered on 26 Apr 2016
9 answers
1.3K+ views
Hi

I have implemented custom paging on one of my Telerik RadGrid's
I did this making use of a Sql Stored Procedure to return only the number of records - same amount as the PageSize as set on the RadGrid.

The problem is that my stored procedure only returns say 15 records of the possible 360 records, then when this is bound to the grid which has the PageSize property set to 15 then of course the pager shows 15 records and page 1 of 1. I know that there are 360 records and thus 24 pages of 15 records each, my questions is how to I set the PageCount property to 24 manually so that the user can use the prev/next buttons to get to the next 15 records?

Thanks



Viktor Tachev
Telerik team
 answered on 26 Apr 2016
0 answers
102 views

I am using RAD GRID. I have more than 1000 rows in Grid. I have kept 50 row per page.

If click on Page Size = "ALL" grid takes 5 minutes to display all the rows.

This happens only in Internet Explorer. Can anyone help me to get resolved?

Govindon
Top achievements
Rank 1
 asked on 25 Apr 2016
1 answer
463 views
All we are using Telerik Web UI controls version 2011.1.315.40.  Is there any foreseeable comparability issues if we change our underlying Target Framework to version 4.6.1
Marin Bratanov
Telerik team
 answered on 25 Apr 2016
2 answers
158 views
Hi,
        I am using RadTreeList control. I used the EditFormSetting with EditFormType='Template'. In that template I am bounding the values to server control with the help of Bind function. When I click on edit button, edit form is coming fine but when i try to click on add a record, it throws an exception which is "DataBinding: 'Telerik.Web.UI.TreeListInsertionObject' does not contain a property with the name 'Title'."

1) And more important when we will add a new record, how we get to know that the newly added record is a child of which parent?

Regards,
Imran Ahmad
Pavlina
Telerik team
 answered on 25 Apr 2016
Narrow your results
Selected tags
Tags
+? more
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?