| protected void SearchGrid_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridPagerItem) { //These control the footer of the grid where the page change can be displayed |
| Label ChangePageSizeLabel = (Label)e.Item.FindControl("ChangePageSizeLabel"); |
| //Created a "First Page" button |
| LinkButton btnFirst = new LinkButton(); |
| btnFirst.Text = "«"; |
| btnFirst.CommandName = "Page"; |
| btnFirst.CommandArgument = "First"; |
| //Add the button to the control |
| ChangePageSizeLabel.Parent.Parent.Controls.AddAt(0, btnFirst); } } |
| // Create a list of items to filter by (for the the main search grid) |
| string strItemsToFilter = ""; |
| foreach (ITEM item in GridToDS) |
| { |
| strItemsToFilter += "([UniqueObjectID] <> '" + item.UniqueObjectID + "') AND "; |
| } |
| // Remove " AND " from the filtered items list |
| if (strItemsToFilter.Length > 0) |
| strItemsToFilter = strItemsToFilter.Substring(0, strItemsToFilter.Length - 5); |
| grdFROM.Columns.FindByUniqueName("UniqueObjectID").CurrentFilterValue = strItemsToFilter; |
| grdFROM.Rebind(); |
<
radG:RadGrid ID="rgDepartmentList" runat="server" Width="99%" AllowPaging="True" AllowCustomPaging="true" OnPageIndexChanged="rgDepartmentList_PageIndexChanged"
AllowSorting="True" ShowStatusBar="True" GridLines="None" AutoGenerateColumns="False" PageSize="5">
<MasterTableView CommandItemDisplay="Top" DataKeyNames="dept_id" RowIndicatorColumn-Display="false">
<NoRecordsTemplate>
<table width="99%" align="center">
<tr>
<td>
No record found.
</td>
</tr>
</table>
</NoRecordsTemplate>
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn Resizable="False" Visible="False">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<radG:GridTemplateColumn HeaderText="Edit" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="30px"
ItemStyle-Width="30px">
<ItemTemplate>
<img onclick=" NavigateToEdit('<%# Eval("dept_id") %>','<%# Eval("dept_active") %>','<%# Eval("dept_name") %>');"
style="cursor: pointer;" alt="Edit" src="../../../Images/common/edit.gif" />
</ItemTemplate>
</radG:GridTemplateColumn>
<radG:GridButtonColumn HeaderText="Delete" ButtonType="ImageButton" CommandName="Delete"
ConfirmText="Do you want to delete this record?" ImageUrl="../../../Images/common/DeleteImage.JPG"
Text="Delete" UniqueName="column1">
<HeaderStyle HorizontalAlign="Center" Width="40px" />
<ItemStyle HorizontalAlign="Center" Width="40px" />
</radG:GridButtonColumn>
<radG:GridTemplateColumn HeaderText="Active">
<ItemTemplate >
<asp:CheckBox ID="chkbox" runat="server" Checked='<%# Bind("dept_active") %>' />
</ItemTemplate>
</radG:GridTemplateColumn>
<radG:GridBoundColumn HeaderText="Department Name" DataField="dept_name" UniqueName="dept_name">
</radG:GridBoundColumn>
</Columns>
<CommandItemTemplate>
<table class="CommandItemTemplate" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="" src="../../../Images/common/register.gif" /></td>
<td>
<a id="A1" onclick="NavigateToAdd();" href="#">Add Department</a>
</td>
<td>
</td>
<td>
</td>
<td>
<img src="../../../Images/common/button_refresh.gif" alt="" />
</td>
<td>
<asp:LinkButton ID="lbtnRefresh" Text="Refresh" runat="server" CommandName="Refresh"
onmouseover="OnRefreshCommandMouseOver();" onmouseout="OnRefreshCommandMouseOut();"></asp:LinkButton>
</td>
<td width="*">
</td>
</tr>
</table>
</td>
</tr>
</table>
</CommandItemTemplate>
</MasterTableView>
<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
<ClientSettings EnableClientKeyValues="True" AllowColumnsReorder="true" ApplyStylesOnClient="true"
ReorderColumnsOnClient="True">
<ClientEvents OnRowClick="" OnRowSelected="RowSelected" />
<Selecting AllowRowSelect="true" />
<Resizing AllowColumnResize="true" AllowRowResize="true" ResizeGridOnColumnResize="false"
ClipCellContentOnResize="true" EnableRealTimeResize="false" />
</ClientSettings>
</
radG:RadGrid>
Code behind is
Private
Sub LoadGrid(ByVal currentindex As Integer)
Dim totalrecords As Integer = 0
Dim ds As New DataSet
ds = SFSetupDepartments.GetDepartmentsByPage((currentindex + 1), 5, totalrecords)
With rgDepartmentList
.MasterTableView.VirtualItemCount = (totalrecords / .PageSize)
.DataSource = ds.Tables(0)
.DataBind()
End With
End Sub