or
<telerik:RadGrid ID="rgvEquipos" Width="70%" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowSorting="True" AllowPaging="True" PageSize="30" runat="server" AutoGenerateColumns="False" ShowFooter="true" OnPreRender="rgvEquipos_PreRender" ShowStatusBar="true" EnableLinqExpressions="false" OnItemDataBound="rgvEquipos_ItemDataBound"> <MasterTableView DataKeyNames="equipoId" ShowFooter="true"> <Columns> <telerik:GridBoundColumn UniqueName="equipoId" DataField="equipoId" HeaderText="equipoId" AllowFiltering="false" HeaderStyle-Width="80px" /> <telerik:GridBoundColumn UniqueName="centro" DataField="centro" HeaderText="centro" HeaderStyle-Width="80px"> <FilterTemplate> <telerik:RadComboBox ID="rcbCentro" DataSourceID="SqlDataSource2" DataTextField="centro" DataValueField="centro" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("centro").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="centroIndexChanged"> <Items> <telerik:RadComboBoxItem Text="Todos" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> function centroIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("centro", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="Denominacion" DataField="Denominacion" HeaderText="Denominacion" AllowFiltering="false" HeaderStyle-Width="300px" /> <telerik:GridBoundColumn UniqueName="Ubicacion" DataField="Ubicacion" HeaderText="Ubicacion" AllowFiltering="false" HeaderStyle-Width="300px" /> <telerik:GridBoundColumn UniqueName="centroCosto" DataField="centroCosto" HeaderText="centroCosto" AllowFiltering="false" HeaderStyle-Width="80px" /> </Columns> </MasterTableView> </telerik:RadGrid>....<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:PlanMantenimientoConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [equipoId], [centro], [activoFijo], [Denominacion], [areaEmpresa], [Ubicacion], [GP], [fabricante], [tipoObjeto], [numSerie], [statusSistema], [centroCosto], [calle], [creadoEl], [creadoPor] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND GP <> ' '" runat="server"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:PlanMantenimientoConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT DISTINCT [centro] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND GP <> ' ' Order By Centro" runat="server"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:PlanMantenimientoConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT DISTINCT [GP] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND GP <> ' ' Order By GP" runat="server"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:PlanMantenimientoConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT DISTINCT [activoFijo] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND activoFijo = 'gggg'" runat="server"></asp:SqlDataSource>protected void Page_Load(object sender, EventArgs e) { esp = Request["esp"]; zona = Request["zona"]; } protected void rgvEquipos_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridFilteringItem) { GridFilteringItem filterItem = (GridFilteringItem)e.Item; RadComboBox comboCentro = (RadComboBox)filterItem.FindControl("rcbCentro");// accessing RadComboBox in FilterTemplate RadComboBox comboGP = (RadComboBox)filterItem.FindControl("rcbGP");// accessing RadComboBox in FilterTemplate RadComboBox comboActivo = (RadComboBox)filterItem.FindControl("rcbactivoFijo");// accessing RadComboBox in FilterTemplate if (!IsPostBack) { comboCentro.SelectedValue = zona; comboGP.SelectedValue = esp; } } } protected void rgvEquipos_PreRender(object sender, System.EventArgs e) { if (rgvEquipos.MasterTableView.FilterExpression != string.Empty) { RefreshCombos(); } } protected void RefreshCombos() { SqlDataSource2.SelectCommand = "SELECT DISTINCT [centro] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND GP <> ' ' AND " + rgvEquipos.MasterTableView.FilterExpression.ToString() + " Order By centro"; SqlDataSource3.SelectCommand = "SELECT DISTINCT [GP] FROM [inventarioPM] WHERE (calle LIKE '%TRANSMIS%' OR calle = '') AND Ubicacion NOT LIKE '%ERO%' AND GP <> ' ' AND " + rgvEquipos.MasterTableView.FilterExpression.ToString() + " Order By GP"; SqlDataSource4.SelectCommand = SqlDataSource4.SelectCommand + " AND " + rgvEquipos.MasterTableView.FilterExpression.ToString(); rgvEquipos.MasterTableView.Rebind(); }<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="MasterFormDetailProdGrid.aspx.cs" Inherits="Telerik.RadGrid.MasterFormDetailProdGrid" %><%@ Register TagPrefix="Telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %><asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <Telerik:RadGrid ID="categoriesGrid" runat="server" DataSourceID="categoriesDataSource" AllowFilteringByColumn="True" AllowPaging="True" AutoGenerateColumns="False" allowautomaticdeletes="True" allowautomaticinserts="True" allowautomaticupdates="True" Skin="Office2007" CellSpacing="0" OnItemCommand="categoriesGrid_ItemCommand" OnInsertCommand="categoriesGrid_InsertCommand" OnItemInserted="categoriesGrid_ItemInserted" > <MasterTableView CommandItemDisplay="Top" DataSourceID="categoriesDataSource" EditMode="InPlace" DataKeyNames="CategoryID" GridLines="None" PageSize="1" ShowHeader="False"> <Columns> <Telerik:GridTemplateColumn HeaderText="CategoryID" UniqueName="CategoryIDColumn" AllowFiltering="False" ItemStyle-BorderStyle="None" > <ItemTemplate> <table style="padding: 0; margin: 0; width: 100%"> <tr> <td class="rightDetail" style="width: 120px;"> CategoryID: </td> <td class="leftDetail"> <asp:Label ID="categoryIDLabel" runat="server" Text='<%# Eval("CategoryID") %>' /> </td> </tr> <tr> <td class="rightDetail"> CategoryName: </td> <td class="leftDetail"> <asp:Label ID="categoryNameLabel" runat="server" Text='<%# Eval("CategoryName") %>' /> </td> </tr> <tr> <td class="rightDetail"> Description: </td> <td class="leftDetail"> <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("Description") %>' /> </td> </tr> <tr> <td class="rightDetail"> Picture: </td> <td class="leftDetail"> <telerik:RadBinaryImage runat="server" ID="RadBinaryImage1" DataValue='<%# Eval("Picture") == DBNull.Value? new System.Byte[0]: Eval("Picture") %>' AutoAdjustImageControlSize="false" Width="150px" Height="150px" ToolTip='<%#Eval("CategoryName", "Photo of {0}") %>' AlternateText='<%#Eval("CategoryName", "Photo of {0}") %>' /> </td> </tr> </table> </ItemTemplate> <EditItemTemplate> <asp:Label ID="CategoryIDLabel" runat="server" Text='<# Eval("CategoryID") %>' /> </EditItemTemplate> </Telerik:GridTemplateColumn> <Telerik:GridEditCommandColumn EditText="Edit" ItemStyle-VerticalAlign="Top" ItemStyle-Width="40px" ItemStyle-BorderStyle="None" /> <Telerik:GridButtonColumn Text="Delete" CommandName="Delete" UniqueName="DeleteColumn" ItemStyle-VerticalAlign="Top" ItemStyle-Width="50px" ItemStyle-BorderStyle="None" ConfirmText="Are you sure you want to delete this data?" /> </Columns> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <EditItemStyle CssClass="EditedTelerikGrid"/> <EditFormSettings EditFormType="Template"> <FormTemplate> <table style="padding: 0; margin: 0; width: 100%"> <tr> <td colspan="3" class="rightDetail"> <asp:LinkButton id="insertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Save" CssClass="buttonBlue" CommandArgument="close" ValidationGroup="insertValidationGroup" /> | <asp:LinkButton id="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" CssClass="buttonBlue" /> </td> </tr> <tr> <td class="rightDetail"> CategoryID: </td> <td class="leftDetail"> <asp:Label ID="categoryIDLabel" runat="server" Text='<%# Eval("CategoryID") %>' /> </td> <td class="leftDetail"> </td> </tr> <tr> <td class="rightDetail"> CategoryName: </td> <td class="leftDetail"> <telerik:RadTextBox ID="categoryNameTextBox" runat="server" Text='<%# Bind("CategoryName") %>' Columns="14" MaxLength="15" /> </td> <td class="leftDetail"> <asp:RequiredFieldValidator id="categoryNameValidator" runat="server" ControlToValidate="categoryNameTextBox" ValidationGroup="insertValidationGroup" ErrorMessage="'CategoryName' is required" Text="*" /> </td> </tr> <tr> <td class="rightDetail"> Description: </td> <td class="leftDetail"> <telerik:RadTextBox ID="descriptionTextBox" runat="server" Text='<%# Bind("Description") %>' Columns="80" Rows="3" /> </td> <td class="leftDetail"> <asp:RequiredFieldValidator id="descriptionValidator" runat="server" ControlToValidate="descriptionTextBox" ValidationGroup="insertValidationGroup" ErrorMessage="'Description' is required" Text="*" /> </td> </tr> <tr> <td class="rightDetail"> Picture: </td> <td class="leftDetail"> </td> <td class="leftDetail"> </td> </tr> <tr> <td colspan="3"> <asp:ValidationSummary id="insertValidationSummary" runat="server" ValidationGroup="insertValidationGroup" /> </td> </tr> </table> </FormTemplate> </EditFormSettings> <CommandItemSettings AddNewRecordText="Add" RefreshText="Refresh" /> </MasterTableView> <FilterMenu EnableTheming="True" Skin="Office2007"> <CollapseAnimation Duration="200" Type="OutQuint" /> </FilterMenu> </Telerik:RadGrid> <asp:HiddenField ID="CategoryIDHidden" runat="server" Value='' /> <asp:SqlDataSource ID="categoriesDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Northwind %>" SelectCommand="SELECT * FROM [Categories]" DeleteCommand="DELETE FROM [Categories] WHERE [CategoryID] = @CategoryID" InsertCommand=" INSERT INTO [Categories] ( [CategoryName], [Description] ) VALUES ( @CategoryName, @Description )" UpdateCommand=" UPDATE [Categories] SET [CategoryName] = @CategoryName, [Description] = @Description WHERE [CategoryID] = @CategoryID "> <DeleteParameters> <asp:Parameter Name="CategoryID" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="CategoryName" /> <asp:Parameter Name="Description" /> <asp:Parameter Name="Picture" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="CategoryName" /> <asp:Parameter Name="Description" /> <asp:Parameter Name="Picture" /> <asp:Parameter Name="CategoryID" /> </UpdateParameters> </asp:SqlDataSource> <asp:Label ID="messageLabel" runat="server" Text="" CssClass="notification"></asp:Label></asp:Content><cc1:RadWindow ID="RadWin_AddEdit" runat="server" Modal="true" Width="730" Height="370" VisibleOnPageLoad="false" Visible="false" Behaviors="Close,Reload" VisibleStatusbar="false"> <ContentTemplate> <asp:UpdatePanel ID="upnlSaveUpdateGangway" runat="server" UpdateMode="Conditional"> <ContentTemplate> <table id="tblAddGangway" width="100%"> <tr> <td>Category: </td> <td> <div style="display: inline-block"> <cc1:RadComboBox ID="cmbCategory" runat="server" EmptyMessage="- Select Category -" OnSelectedIndexChanged="cmbCategory_SelectedIndexChanged" AutoPostBack="true" Width="150px"> </cc1:RadComboBox> </div> <div style="display: inline-block"> <cc1:RadComboBox ID="cmbSubCategory" runat="server" EmptyMessage="- Select Sub-category -" OnSelectedIndexChanged="cmbSubCategory_SelectedIndexChanged" AutoPostBack="true" Width="150px"> </cc1:RadComboBox> </div> </tr> <tr> <div style="display: inline-block"> <td>Item Master: </td> <td> <cc1:RadSearchBox runat="server" ID="cmbItemMaster" OnSearch="cmbItemMaster_Search" Skin="WebBlue" Style="padding-right: 5px; padding-left: 5px; font-family: Calibri;" Width="85%" AutoPostBack="true" ZIndex="10000000" DropDownSettings-Width="200px" DropDownSettings-Height="200px"> </cc1:RadSearchBox> <asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator3" ControlToValidate="cmbItemMaster" ForeColor="Red" ValidationGroup="SaveUpdate" Display="Dynamic">*</asp:RequiredFieldValidator> </cc1:RadSearchBox> </td> </div> </tr> <tr> <td style="height: 31px;"> <asp:Label ID="lblMaterialCode" runat="server" Text="Material Code"></asp:Label> </td> <td style="height: 31px" colspan="3"> <cc1:RadComboBox AutoPostBack="true" ID="ddlMaterialCode" OnSelectedIndexChanged="ddlMaterialCode_SelectedIndexChanged" runat="server" Width="40%" EmptyMessage="- Select Material code -"> </cc1:RadComboBox> <asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator2" ControlToValidate="ddlMaterialCode" ForeColor="Red" ValidationGroup="SaveUpdate" Display="Dynamic">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td style="height: 31px;"> <asp:Label ID="lblMaterialName" runat="server" Text="Material Name"></asp:Label> </td> <td style="height: 31px" colspan="3"> <%-- <asp:TextBox ID="tbMaterialName" runat="server" MaxLength="100" Width="160px"></asp:TextBox>--%> <asp:Label ID="lblMName" runat="server" ></asp:Label> </td> </tr> <tr> <td style="height: 31px;"> <asp:Label ID="lblQtyRequired" runat="server" Text="Qty Required"></asp:Label> </td> <td style="height: 31px" colspan="3"> <asp:TextBox ID="tbQtyRequired" runat="server" MaxLength="100" Width="160px"></asp:TextBox> <asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator1" ControlToValidate="tbQtyRequired" ForeColor="Red" ValidationGroup="SaveUpdate" Display="Dynamic">*</asp:RequiredFieldValidator> </tr> <tr> <td style="height: 31px;"> <asp:Label ID="lblPriority" runat="server" Text="Priority"></asp:Label> </td> <td style="height: 31px" class="tdField" colspan="3"> <asp:DropDownList ID="ddlPriority" runat="server" Width="40%"> </asp:DropDownList> <asp:RequiredFieldValidator runat="server" ID="rfvDuration" ControlToValidate="ddlPriority" ForeColor="Red" ValidationGroup="SaveUpdate" Display="Dynamic">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td style="height: 31px;"> <asp:Label ID="lblRemarks" runat="server" Text="Remarks"></asp:Label> </td> <td style="height: 31px" colspan="3"> <asp:TextBox ID="tbRemarks" runat="server" MaxLength="400" TextMode="MultiLine" Width="160px"></asp:TextBox> </td> </tr> </table> <table width="100%"> <tr> <td class="tdControl" align="center"> <asp:Button ID="btnSave" runat="server" Width="50px" OnClick="btnSave_Click" CommandName="Insert" ValidationGroup="SaveUpdate" Text="Save" /> <input id="btnCancel" onclick="CloseChildWindow();" style="width: 50px;" type="button" value="Cancel" name="Cancel" /> <asp:HiddenField ID="hdnMRDId" runat="server" /> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel> </ContentTemplate> </cc1:RadWindow>rgResults.Columns[i].HeaderStyle.Width.Value
<telerik:RadButton runat="server" Text="Letter Manager" Image-EnableImageButton="True" Image-ImageUrl="~/images/btnLetterManger.png" Height="62" Width="207" ID="btnLetterManager" Image-HoveredImageUrl="~/images/btnLetterManger_hover.png" Image-IsBackgroundImage="False" ToolTip="Letter Manager" NavigateUrl="~/LetterManager.aspx" UseSubmitBehavior="True"> </telerik:RadButton>