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

RadGrid

10 Answers 172 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Amit
Top achievements
Rank 1
Amit asked on 21 Aug 2012, 12:09 PM
Hello,

I want the demo for Filtering and grouping in one radgrid
Please give me the demo for My requirement.

Please help me its urgent.

Regards

10 Answers, 1 is accepted

Sort by
0
Accepted
Princy
Top achievements
Rank 2
answered on 21 Aug 2012, 12:29 PM
Hi Amit,

Try the following code to show grouping and filtering in RadGrid.
aspx:
<telerik:RadGrid  AllowFilteringByColumn="true" ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" ShowHeader="true" AutoGenerateColumns="false">
  <MasterTableView>
   <GroupByExpressions>
      <telerik:GridGroupByExpression>
         <SelectFields>
              <telerik:GridGroupByField FieldName="FirstName" />
         </SelectFields>
         <GroupByFields>
            <telerik:GridGroupByField FieldName="FirstName"  />
         </GroupByFields>
      </telerik:GridGroupByExpression>
  </GroupByExpressions>
 <Columns>
   <telerik:GridBoundColumn UniqueName="EmployeeID" HeaderText="EmployeeID" DataField="EmployeeID"></telerik:GridBoundColumn>
   <telerik:GridBoundColumn UniqueName="FirstName" HeaderText="FirstName" DataField="FirstName"></telerik:GridBoundColumn>
 </Columns>
</MasterTableView>
</telerik:RadGrid>

Thanks,
Princy.
0
Amit
Top achievements
Rank 1
answered on 21 Aug 2012, 12:33 PM
Thanks Princy for replying quikly
But I am binding data to radgrid at runtime through the collection
can you tell me how should I manage it

Thanks
0
Amit
Top achievements
Rank 1
answered on 21 Aug 2012, 01:16 PM
Hi,
Are you able to understand my problem I want to bind data after postback after filtering
How should I Manage it.
0
Princy
Top achievements
Rank 2
answered on 22 Aug 2012, 06:44 AM
Hi Amit,

Here is the sample code I tried for binding a RadGrid with ArrayList and implementing the Filtering and Grouping functionality.

ASPX:
<telerik:RadGrid ID="grid" runat="server" AutoGenerateColumns="false" AllowFilteringByColumn="true" onneeddatasource="grid_NeedDataSource">
    <MasterTableView>
        <GroupByExpressions>
                <telerik:GridGroupByExpression>
                    <SelectFields>
                        <telerik:GridGroupByField FieldName="A" />
                    </SelectFields>
                    <GroupByFields>
                        <telerik:GridGroupByField FieldName="B"  />
                    </GroupByFields>
                </telerik:GridGroupByExpression>
        </GroupByExpressions>
    <Columns>
        <telerik:GridBoundColumn DataField="A" HeaderText="FirstField"></telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="B" HeaderText="SecondField"></telerik:GridBoundColumn>
    </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:
protected void grid_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    ArrayList list = new ArrayList();
    list.Add(new TestListItem("Item 0", 0));
    list.Add(new TestListItem("Item 1", 0));
    list.Add(new TestListItem("Item 2", 1));
    list.Add(new TestListItem("Item 3", 1));
    list.Add(new TestListItem("Item 4", 2));
    grid.DataSource = list;
}
public class TestListItem
{
    private string _a;
    private int? _b;
 
    public TestListItem(string a, int? b)
    {
        this._a = a;
        this._b = b;
    }
 
    public string A
    {
        get
        {
            return this._a;
        }
        set
        {
            this._a = value;
        }
    }
 
    public int? B
    {
        get
        {
            return this._b;
        }
    }
}

Thanks,
Princy.
0
Amit
Top achievements
Rank 1
answered on 22 Aug 2012, 06:51 AM
Thanks
Ya it is working fine now I have added RAdtabstrip

like

<td align="left" colspan="3" class="tdBorderLeftRightBottom">

<table cellspacing="5" cellpadding="0" width="100%" border="0">

<tr valign="bottom">

<td align="left" width="100%" valign="top">

<telerik:RadTabStrip ID="RadTabStrip1" runat="server"

OnClientTabSelecting="onTabSelecting" SelectedIndex="0"

MultiPageID="RadMultiPage1">

<Tabs>

<telerik:RadTab runat="server" Text="Active" PageViewID="RadPageView1">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="Closed" PageViewID="RadPageView2"

Selected="True">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

</td>

</tr>

<tr>

<td valign="top" align="left" width="100%">

<telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0">

<telerik:RadPageView ID="RadPageView1" runat="server">

<div id="divOpenGrid">

<table cellspacing="0" cellpadding="0" width="100%" border="0">

<tr>

<td align="left">

<telerik:RadGrid ID="rOpenGrid" runat="server" SkinID="ESSGrid" AllowFilteringByColumn="True"

AutoGenerateColumns="False" AllowPaging="true" PageSize="20" PagerStyle-Mode="NextPrevAndNumeric"

GridLines="None" OnDeleteCommand="rOpenGrid_DeleteCommand"

AllowSorting="True" OnNeedDataSource="rOpenGrid_NeedDataSource"

OnColumnCreated="rOpenGrid_ColumnCreated" HorizontalAlign="Center"

onprerender="rOpenGrid_PreRender"

onpagesizechanged="rOpenGrid_PageSizeChanged">

<PagerStyle />

<MasterTableView DataKeyNames="TicketID" AllowFilteringByColumn="true" TableLayout="Fixed" GroupHeaderItemStyle-HorizontalAlign="Left">

<NoRecordsTemplate>

<div>

&nbsp;&nbsp;&nbsp;There are no records to display

</div>

</NoRecordsTemplate>

<%

-- <GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldAlias="Ticket" FieldName="TypeText" FormatString=""

HeaderText="" HeaderValueSeparator=" Type : "></telerik:GridGroupByField>

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="TypeText" FieldAlias="TypeText" SortOrder="Ascending"

FormatString="" HeaderText=""></telerik:GridGroupByField>

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>--

 

%>

<Columns>

<telerik:GridTemplateColumn HeaderText="TypeText" UniqueName="TypeText" FilterControlWidth="45px"

CurrentFilterFunction="Contains">

<ItemTemplate>

<asp:Label ID="lnkTypeName" runat="server" Text='<%# Eval("TypeText") %>'>

</asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="20%" />

<ItemStyle HorizontalAlign="Left" Width="20%" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Employee" UniqueName="Name" CurrentFilterFunction="Contains">

<ItemTemplate>

<asp:Label ID="lnkEmpName" runat="server" Text='<%# Eval("CreatedBy") + " , " + Eval("Name")%>'>

</asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="22%" />

<ItemStyle HorizontalAlign="Left" Width="22%" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Subject " UniqueName="Subject" FilterControlWidth="55px">

<ItemTemplate>

<asp:LinkButton ID="lnkSubjectName" runat="server" CommandArgument='<%# Eval("Status")%>'

CommandName='<%# Eval("TicketID")%>' OnClick="lnkSubjectName_Click" Text='<%# Eval("Subject")%>'></asp:LinkButton>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="24%" />

<ItemStyle HorizontalAlign="Left" Width="24%" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Total Replies" UniqueName="TotalReplies"

AllowFiltering="false">

<ItemTemplate>

<asp:Label ID="lnkTotalReplies" runat="server" Text='<%# Eval("TotalReplies")%>'></asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="10%" />

<ItemStyle HorizontalAlign="Center" Width="10%" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Status" UniqueName="StatusText" AllowFiltering="false">

<ItemTemplate>

<asp:Label ID="lnkStatus" runat="server" Text='<%# Eval("StatusText")%>'>

</asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="9%" />

<ItemStyle HorizontalAlign="Left" Width="9%" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Last Updated On" UniqueName="CreatedOn" AllowFiltering="false">

<ItemTemplate>

<asp:Label ID="lnkCreatedOn" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CreatedOn", "{0:dd/MM/yyyy}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Width="15%" />

<ItemStyle HorizontalAlign="Left" Width="15%" />

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</td>

</tr>

</table>

</div>

</telerik:RadPageView>


Ok Now I am unable to filtering the data
after postback
0
Amit
Top achievements
Rank 1
answered on 22 Aug 2012, 10:00 AM
I want demo for

Radgrid inside the radtabstrip
Radgrid with filtering and paging and grouping,
Radgrid datasource is collection at runtime
Radgrid is inside the radtabstrips RadPageView1

If anybody from telerik give methis its urgent we have purchase license from you telerik  give support for this
please
0
Princy
Top achievements
Rank 2
answered on 23 Aug 2012, 06:23 AM
Hi Amit,

In order to implement filtering for template columns, you should set DataField property. Here is the sample code.

ASPX:
<telerik:RadTabStrip ID="RadTabStrip1" runat="server" SelectedIndex="0" MultiPageID="RadMultiPage1">
 <Tabs>
  <telerik:RadTab runat="server" Text="Active" PageViewID="RadPageView1"></telerik:RadTab>
  <telerik:RadTab runat="server" Text="Closed" PageViewID="RadPageView2" Selected="True"></telerik:RadTab>
 </Tabs>
</telerik:RadTabStrip>
<telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0">
<telerik:RadPageView ID="RadPageView1" runat="server">
<telerik:RadGrid ID="grid" runat="server" AllowPaging="true" PageSize="2" AutoGenerateColumns="false" AllowFilteringByColumn="true" onneeddatasource="grid_NeedDataSource">
    <MasterTableView>
        <GroupByExpressions>
                <telerik:GridGroupByExpression>
                    <SelectFields>
                        <telerik:GridGroupByField FieldName="A" />
                    </SelectFields>
                    <GroupByFields>
                        <telerik:GridGroupByField FieldName="B"  />
                    </GroupByFields>
                </telerik:GridGroupByExpression>
        </GroupByExpressions>
    <Columns>
     . . .
       <telerik:GridTemplateColumn HeaderText="Subject" DataField="Subject" UniqueName="Subject" FilterControlWidth="55px">
         <ItemTemplate>
          <asp:LinkButton ID="lnkSubjectName" runat="server" CommandArgument='<%# Eval("Status")%>' CommandName='<%# Eval("TicketID")%>' OnClick="lnkSubjectName_Click" Text='<%# Eval("Subject")%>'></asp:LinkButton>
        </ItemTemplate>
    </Columns>
 </MasterTableView>
</telerik:RadGrid>
</telerik:RadPageView>
</telerik:RadMultiPage>

Hope this helps.

Regards,
Princy.
0
Amit
Top achievements
Rank 1
answered on 23 Aug 2012, 08:06 AM
Thanks
Ya it is working fine now.
 
Please give me your direct contact mail so further if any help I require can communicate with  you
we are using telerik from one year stiil lots of telerik property  not used.


0
Vamsi Kamal
Top achievements
Rank 1
answered on 19 Nov 2012, 02:17 PM
I have a requirement for RadGrid like below. Can anyone suggest me the best way to do it.

- Need to provide check boxes column headers
- If we select one of the check box, then that column should be invisible. And the column name should be added to a dropdown list, which is on top of the RadGrid. All the selected column names should be added to drop down list.
- If I select the drop down list and click on a button then all the selected columns should be visible.

- Need to achieve this without posting back the page.

Thanks in advance.
0
Eyup
Telerik team
answered on 22 Nov 2012, 09:16 AM
Hi Vamsi,

Have you tried the approach suggested in the following topic?
http://www.telerik.com/community/forums/aspnet-ajax/grid/rendering-issue-with-radgrid-grouping.aspx

All the best,
Eyup
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Amit
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Amit
Top achievements
Rank 1
Vamsi Kamal
Top achievements
Rank 1
Eyup
Telerik team
Share this question
or