This is a migrated thread and some comments may be shown as answers.

[Solved] Rad grid

1 Answer 134 Views
Grid
This is a migrated thread and some comments may be shown as answers.
yeswanth pavan
Top achievements
Rank 1
yeswanth pavan asked on 22 Jan 2010, 02:40 PM
Hi all,

1) I have implemented Rad ajax panel(progress bar) for Rad grid on click of Link button if it is going to  any exception the page is getting hanged due to Rad ajax panel  until any event is fired how can we handle when we got any exception

2)the Between option for Filtering is Showing Wrong data for dates when we use Telerik grid bound column i also used Datatype as system.datatime if we use Telerik Datetime it is not showing Between option.


 

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">  
 
<asp:UpdatePanel ID="UpdatePanel2" runat="server">  
 
<ContentTemplate> 
 
<telerik:RadGrid ID="gviewProjectwisetask" runat="server" Width="100%" AutoGenerateColumns="False"   
 
GridLines="None" CellPadding="2"   
 
 
onrowcommand="gviewProjectwisetask_RowCommand"   
 
onpageindexchanging="gviewProjectwisetask_PageIndexChanging"   
 
BackImageUrl="~/images/grad_l2.gif" BorderColor="#66CCFF"   
 
BorderStyle="Solid" BorderWidth="1px"   
 
onrowdatabound="gviewProjectwisetask_RowDataBound"   
 
onrowediting="gviewProjectwisetask_RowEditing"   
 
onrowdeleting="gviewProjectwisetask_RowDeleting" Skin="Vista"   
 
onitemcommand="gviewProjectwisetask_ItemCommand"   
 
onitemdatabound="gviewProjectwisetask_ItemDataBound">  
 
 
<MasterTableView> 
 
<Columns> 
 
<telerik:GridTemplateColumn HeaderText="Resource Name">  
 
<ItemTemplate> 
 
<asp:LinkButton ID="ResourceName" runat="server" CommandName="Select" Text='<%#DataBinder.Eval(Container.DataItem,"Resource Name") %>'></asp:LinkButton> 
 
 
</ItemTemplate> 
 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
 
</telerik:GridTemplateColumn> 
 
 
 
<telerik:GridBoundColumn DataField="Resource ID" HeaderText="ResourceId"   
 
ItemStyle-CssClass="columnHidden" HeaderStyle-CssClass="columnHidden" > 
 
 
<HeaderStyle CssClass="columnHidden" /> 
 
<ItemStyle CssClass="columnHidden" Font-Bold="False" Font-Italic="False"   
 
Font-Overline="False" Font-Strikeout="False" Font-Underline="False"   
 
HorizontalAlign="Left" Wrap="True" /> 
 
 
</telerik:GridBoundColumn> 
 
<telerik:GridTemplateColumn HeaderText="Task/Module Name">  
 
<ItemTemplate> 
 
<asp:Label ID="lblTaskmane" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Task Name") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
 
 
<telerik:GridTemplateColumn HeaderText="Task Description">  
 
<ItemTemplate> 
 
<asp:Label ID="lblDesc" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Description") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
 
 
<telerik:GridTemplateColumn HeaderText="Assigned By">  
 
<ItemTemplate> 
 
<asp:Label ID="lblAssignedBy" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Assigned By") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
 
<telerik:GridTemplateColumn HeaderText="ModifiedBy">  
 
<ItemTemplate> 
 
<asp:Label ID="lblModifiedBy" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Modified By") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
 
 
<telerik:GridTemplateColumn HeaderText="Phase">  
 
<ItemTemplate> 
 
<asp:Label ID="lblphase" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"phase") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
 
</telerik:GridTemplateColumn> 
 
<telerik:GridTemplateColumn HeaderText="ETA(Hrs)">  
 
<ItemTemplate> 
 
<asp:Label ID="lblETA" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Estimated Hours") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
 
</telerik:GridTemplateColumn> 
 
<telerik:GridTemplateColumn HeaderText="Date">  
 
<ItemTemplate> 
 
<asp:Label ID="lblDate" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Date") %>'></asp:Label> &nbsp;  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn>   
 
 
<telerik:GridBoundColumn DataField="Task ID" HeaderText="TaskID"   
 
> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridBoundColumn> 
 
<telerik:GridBoundColumn DataField="Document ID" HeaderText="DocumentID"   
 
> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridBoundColumn> 
 
<telerik:GridTemplateColumn HeaderText="Document">  
 
<ItemTemplate> 
 
<asp:LinkButton ID="lnkDocument" runat="server" CommandName="Select2" Text='<%#DataBinder.Eval(Container.DataItem,"File Name") %>'></asp:LinkButton> 
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
<telerik:GridTemplateColumn HeaderText="Remove Att. File">  
 
<ItemTemplate> 
 
<asp:ImageButton ID="imgbtnRemoveDocument" runat="server" ToolTip="Remove Attached File" 
 
ImageUrl="~/images/delete-file-icon.gif" CommandName="Select3" OnClientClick="return confirm('Are you sure you want to remove att. file?');"/>  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
<telerik:GridTemplateColumn HeaderText="Add More">  
 
<ItemTemplate> 
 
<asp:ImageButton ID="imgbtnAddmore" runat="server" ToolTip="Add More Tasks" 
 
ImageUrl="~/images/AddMore.gif" CommandName="Select4"/>  
 
</ItemTemplate> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"   
 
Wrap="True" /> 
 
 
</telerik:GridTemplateColumn> 
 
<telerik:GridBoundColumn DataField="status" HeaderText="Status"   
 
> 
 
 
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"   
 
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left"   
 
Wrap="True" /> 
 
 
</telerik:GridBoundColumn> 
 
</Columns> 
 
</MasterTableView> 
 
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> 
 
<PagerStyle   
 
ForeColor="Black" HorizontalAlign="Center" Height="30px" Font-Bold="True" Font-Names="Arial"   
 
Font-Size="Smaller" CssClass="footerbg" /> 
 
 
</telerik:RadGrid> 
 
</ContentTemplate> 
 
</asp:UpdatePanel> 
 
</telerik:RadAjaxPanel> 
 
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px" 
 
Width="75px" Skin="Sunset">  
 
</telerik:RadAjaxLoadingPanel> 
 
 
 
 


..................................Code for Filtering...........................................

 

 

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

 

 

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

 

 

 

 

 

<ContentTemplate>

 

 

 

 

 

<telerik:RadGrid ID="gviewResource" runat="server" AutoGenerateColumns="False" OnRowEditing="gviewResource_RowEditing"

 

 

 

 

 

OnRowDeleting="gviewResource_RowDeleting" AllowPaging="True" AllowSorting="True"

 

 

 

 

 

OnDataBound="gviewResource_DataBound" CellPadding="0"

 

 

 

 

 

GridLines="None" Width="100%" OnPageIndexChanging="gviewResource_PageIndexChanging"

 

 

 

 

 

OnRowCreated="gviewResource_RowCreated" OnSorting="gviewResource_Sorting"

 

 

BorderColor="#66CCFF" BorderStyle="Solid" BorderWidth="1px"

 

 

onrowdatabound="gviewResource_RowDataBound"

 

 

onitemcommand="gviewResource_ItemCommand" Skin="Vista"

 

 

AllowFilteringByColumn="True" onitemcreated="gviewResource_ItemCreated"

 

 

EnableLinqExpressions="False"

 

 

onitemdatabound="gviewResource_ItemDataBound">

 

 

 

 

 

 

<MasterTableView>

 

 

 

 

 

<Columns>

 

 

 

 

 

<telerik:GridBoundColumn DataField="ResourceID" HeaderText="ID" >

 

 

 

 

 

<HeaderStyle CssClass="textCenter" Width="6%" Wrap="True" />

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" HeaderStyle-Width="75px">

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Designation" HeaderText="Designation" SortExpression="Designation" HeaderStyle-Width="75px">

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Date Of Joining" HeaderText="Date Of Joining" SortExpression="Date Of Joining" HeaderStyle-Width="75px">

 

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Date Of Birth" HeaderText="Date Of Birth" SortExpression="Date Of Birth" HeaderStyle-Width="75px">

 

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="Exp. In Yrs" HeaderText="Exp. In Years" SortExpression="Exp. In Yrs" HeaderStyle-Width="75px">

 

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Exp. In Mon" HeaderText="Exp. In Mon" SortExpression="Exp. In Mon" HeaderStyle-Width="75px">

 

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Email" HeaderText="Email ID" SortExpression="Email" HeaderStyle-Width="75px">

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Resource Status" HeaderText="Status" SortExpression="Resource Status" HeaderStyle-Width="75px">

 

 

 

 

 

 

<HeaderStyle Width="75px" />

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridTemplateColumn HeaderText="Edit" AllowFiltering="false" >

 

 

 

 

 

 

<ItemTemplate>

 

 

 

 

 

<asp:ImageButton ID="Image" runat="server" ImageUrl="images/edit.gif" CommandName="Edit" ></asp:ImageButton>

 

 

 

 

 

</ItemTemplate>

 

 

 

 

 

 

</telerik:GridTemplateColumn>

 

 

 

 

 

<telerik:GridTemplateColumn HeaderText="Reject/Delete" AllowFiltering="false">

 

 

 

 

 

<ItemTemplate>

 

 

 

 

 

<asp:ImageButton ID="imgbtnDeActivate" runat="server" ToolTip="Delete Resource" ImageUrl="~/images/delete-icon.gif"

 

 

 

 

 

CommandName="Delete" OnClientClick="return confirm('Are you sure you want to reject/delete this resource?');" />

 

 

 

 

 

</ItemTemplate>

 

 

 

 

 

 

 

</telerik:GridTemplateColumn>

 

 

 

 

 

</Columns>

 

 

 

 

 

</MasterTableView>

 

 

 

 

 

<ClientSettings EnableRowHoverStyle="true">

 

 

 

 

 

<Selecting AllowRowSelect="true" />

 

 

 

 

 

<Scrolling EnableVirtualScrollPaging="True" UseStaticHeaders="False" />

 

 

 

 

 

<Resizing AllowColumnResize="True" />

 

 

 

 

 

</ClientSettings>

 

 

 

 

 

<FooterStyle ForeColor="White" />

 

 

 

 

 

 

 

<HeaderStyle CssClass="heading" Font-Bold="True" Font-Strikeout="False" Font-Underline="False"

 

 

 

 

 

Height="30px" />

 

 

 

 

 

 

 

</telerik:RadGrid>

 

 

 

 

 

</ContentTemplate>

 

 

 

 

 

</asp:UpdatePanel>

 

 

 

 

 

</telerik:RadAjaxPanel>

 

 

 

 

 

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px"

 

 

 

 

 

Width="75px" Skin="Sunset">

 

 

 

 

 

</telerik:RadAjaxLoadingPanel>

 

1 Answer, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 27 Jan 2010, 03:32 PM
Hello yeswanth,

1) I would suggest you not to nest the RadAjaxPanel and the ASP:UpdatePanel controls. You should use either RadAjaxPanel or ASP:UpdatePanel in order to ajaxify particular page content but both. Therefore, please try removing the ASP:UpdatePanel and see if the loading image is displayed properly now.

2) Indeed, the default filter functions for the GridDateTimeColumn do not include Between/NotBetween as this would require one more RadDatePicker control in the column filter.
Regarding the case when you are using GridBoundColumn with DataType of System.DateTime, try setting the EnableLinqExpressions property of the grid to false and see if the column is filtered properly.
Additionally, in order to implement the Between filter for date columns, you could try the approach illustrated in this demo.

I hope this helps.

Best wishes,
Iana
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
Grid
Asked by
yeswanth pavan
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Share this question
or