or
Trying to use a RadSearchBox in a FilterTemplate while using OpenAccess (I believe using simple binding?) - not sure how to get the filtering to work/in code behind - looked at several samples/demos - but none seem to show how or if it will work when using OpenAccess (trying to stick with simple binding if possible)
Test code below
<telerik:RadGrid ID="RadGridResults" runat="server" AutoGenerateColumns="False" CellSpacing="0" DataSourceID="OpenAccessLinqDataSource" GridLines="None" AllowPaging="True" AllowSorting="True" EnableLinqExpressions="False" AllowFilteringByColumn="True"> <ClientSettings> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </ClientSettings> <MasterTableView DataKeyNames="ProductID" DataSourceID="OpenAccessLinqDataSource1"> <Columns> <telerik:GridBoundColumn DataField="ProductRef" FilterControlAltText="Filter Product Ref column" HeaderText="ProductRef" SortExpression="ProductRef" UniqueName="ProductRef"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn FilterControlAltText="Filter Brand Name column" UniqueName="ProductBrandName" DataSourceID="OpenAccessLinqDataSourceBrandName" DataField="ProductBrandNameID" HeaderText="Brand Name" SortExpression="CompanyName" ListValueField="CompanyID" AllowSorting="true" ListTextField="CompanyName" DropDownControlType="DropDownList"> <FilterTemplate> <telerik:RadSearchBox ID="RadSearchBox1" runat="server" DataSourceID="OpenAccessLinqDataSourceBrandName" DataTextField="CompanyName" DataValueField="CompanyID" ShowSearchButton="False" OnSearch="RadSearchBox1_Search"> </telerik:RadSearchBox> </FilterTemplate> </telerik:GridDropDownColumn>
Protected Sub RadSearchBox1_Search(sender As Object, e As SearchBoxEventArgs) RadGridResults.MasterTableView.FilterExpression = "([ProductBrandName] = " + e.Text + ")" Dim column As GridColumn = RadGridResults.MasterTableView.GetColumnSafe("ProductBrandName") column.CurrentFilterFunction = GridKnownFunction.EqualTo column.CurrentFilterValue = e.Text RadGridResults.DataBind() End Sub
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" Skin="Black" OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated" AllowSorting="True" AllowMultiRowSelection="False" OnItemCommand="RadGrid1_ItemCommand" AutoGenerateEditColumn="false" OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnNeedDataSource="RadGrid1_NeedDataSource" OnInsertCommand="RadGrid1_InsertCommand" OnPreRender="RadGrid1_PreRender" > <MasterTableView DataKeyNames="TempAccountsId" ShowFooter="true" TableLayout="Fixed" AllowMultiColumnSorting="True" EditMode="InPlace" > <DetailTables> <telerik:GridTableView DataKeyNames="CleaningId" CommandItemDisplay="Top" TableLayout="Fixed" Name="Cleaning" ShowFooter="true" EditMode="InPlace" AllowAutomaticUpdates="false"> <Columns> <telerik:GridTemplateColumn Visible="false"> <ItemTemplate> <asp:Label ID="lblCleaningId" runat="server" Text='<%#Eval("CleaningId") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit" UniqueName="Edit" ItemStyle-Width="25px" HeaderStyle-HorizontalAlign="Center" EditImageUrl="../Images/edit.gif" ItemStyle-HorizontalAlign="Center"> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderText="Delete" UniqueName="Delete" HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="40px" ItemStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:ImageButton runat="server" ID="imgdelete" OnClientClick="return confirm('Are you sure that you want to Delete?');" ImageUrl="../Images/delete.gif" CommandName="Delete" CommandArgument="" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderStyle-Width="180" UniqueName="Rate" HeaderText="Rate" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Center" FooterStyle-HorizontalAlign="Right"> <ItemTemplate> <asp:RadioButton ID="rdbtnPerSqft" runat="server" Text="PerSqft" GroupName="Rate" Enabled="false" Checked='<%# bool.Parse(Eval("IsPerSqftRate").ToString()) %>' /> <asp:RadioButton ID="rdbtnFlat" runat="server" Text="Flat" GroupName="Rate" Enabled="false" Checked='<%# bool.Parse(Eval("IsFlatRate").ToString()) %>' /> </ItemTemplate> <EditItemTemplate> <asp:RadioButton ID="rdbtnPerSqftEdit" runat="server" Text="PerSqft" GroupName="Rate" Checked='<%# bool.Parse(Eval("IsPerSqftRate").ToString()) %>' /> <asp:RadioButton ID="rdbtnFlatEdit" runat="server" CommandName="Flatrate" Text="Flat" GroupName="Rate" Checked='<%# bool.Parse(Eval("IsFlatRate").ToString()) %>' /> <asp:TextBox ID="txtRateEdit" runat="server" Width="55" CssClass="AlgRgh" Visible="true" Text='<%# string.Format("{0:n}", Convert.ToDecimal(Eval("PerSqFtRate"))) %>' onkeypress="javascript:return Allownumbersonly(event);" BorderWidth="1px" ></asp:TextBox> </EditItemTemplate> <InsertItemTemplate> <asp:RadioButton ID="rdbtnPerSqftinsert" runat="server" Text="PerSqft" GroupName="Rate" /> <asp:RadioButton ID="rdbtnFlatinsert" runat="server" Text="Flat" GroupName="Rate" /> <asp:TextBox ID="txtRateinsert" runat="server" Width="55" CssClass="AlgRgh" onkeypress="javascript:return Allownumbersonly(event);" BorderWidth="1px" ></asp:TextBox> </InsertItemTemplate> </telerik:GridTemplateColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridTemplateColumn HeaderText="AccountId" UniqueName="TempAccountsId" Visible="false"> <ItemTemplate> <asp:Label ID="lblTempAccountsId" runat="server" Text='<%#Eval("TempAccountsId") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Account Number" UniqueName="AccountNumber" ItemStyle-Width="120px" HeaderStyle-Width="120px" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left"> <ItemTemplate> <asp:Label ID="lblAccountNumber" runat="server" Text='<%#Eval("AccountNumber") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Account Name" UniqueName="AccountName" ItemStyle-Width="140px" HeaderStyle-Width="140px" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left"> <ItemTemplate> <asp:Label ID="lblAccountName" runat="server" Text='<%#Eval("AccountName") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:Label ID="lbltotalFooter" runat="server" Text="Total:"></asp:Label> </FooterTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings AllowKeyboardNavigation="true" EnableRowHoverStyle="true"> </ClientSettings></telerik:RadGrid>Hi,
I have a checkbox set up as such:
<
telerik:GridCheckBoxColumn DataField="HaulSampledTrueFalse" HeaderText="Haul Sampled?" Visible="false" UniqueName="HaulSampledTrueFalse" EditFormColumnIndex="1"></telerik:GridCheckBoxColumn>
| <telerik:GridBoundColumn DataField="TRNO_ID" DataType="System.Decimal" HeaderText="ID" |
| ColumnEditorID="TRNO_ID_CE"> |
| </telerik:GridBoundColumn> |
| <telerik:GridNumericColumnEditor ID="TRNO_ID_CE" NumericTextBox-EnabledStyle-HorizontalAlign="Right" |
| runat="server" NumericTextBox-Width="75px"> |
| <NumericTextBox ID="NumericTextBox1" runat="server"> |
| <NumberFormat DecimalDigits="2" /> |
| </NumericTextBox> |
| </telerik:GridNumericColumnEditor> |
| <telerik:GridTextBoxColumnEditor ID="TRNO_ID_CE" runat="server"> |
| <TextBoxStyle BackColor="#edffc3" BorderColor="#ecbb0d" BorderStyle="Solid" ForeColor="#7fa822" /> |
| </telerik:GridTextBoxColumnEditor> |

<telerik:RadDropDownTree ID="personalCriteriaDropDownTree" runat="server" AutoPostBack="True" DefaultMessage="Enterprise" DataFieldID="ID" DataFieldParentID="ParentID" DataTextField="Name" DataValueField="TYPE" DropDownSettings-AutoWidth="Disabled" DropDownSettings-Height="400px" ExpandNodeOnSingleClick="True" FullPathDelimiter=" > " OnClientEntryAdding="onProgramDropDownClientEntryAdding" OnClientEntryAdded="persNodeClicking" OnClientEntryRemoved="onProgramDropDownClientEntryRemoved" OnClientDropDownClosed="persNodeClosing" OnEntryAdded ="ProgramDropDownTree_EntryAdded" OnNodeDataBound="PersonalCriteriaDownTree_NodeDataBound" TextMode="FullPath" Width="300px"> <HeaderTemplate> <div class="header"> <span style="color: red">* Words in Bold are selectable </span> </div> </HeaderTemplate> <FooterTemplate> <div class="footer"> <span style="color: red">* Words in Bold are selectable </span> </div> </FooterTemplate></telerik:RadDropDownTree>