or
protected override void Page_Load(object sender, EventArgs e){ base.Page_Load(sender, e); windowsManager.MinimizeZoneID = minimizeZone.ClientID; windowsManager.RestrictionZoneID = viewPane.ClientID;}public void OpenWindow(string name){ RadWindow window = new RadWindow(); window.ID = name; window.ContentTemplate = Page.LoadTemplate("~/ControlPanel/Views/" + name + ".ascx"); windowsManager.Windows.Add(window); window.VisibleOnPageLoad = true;}<div id="viewPane" runat="server" class="cellDiv" style="height:100%;"> <telerik:RadWindowManager ID="windowsManager" runat="server" Behaviors="Default" EnableShadow="true"> </telerik:RadWindowManager> <div id="minimizeZone" runat="server" class="minimizeZone"> </div></div>if (txtParentGridID.Text != string.Empty){ string cmbZipHandlerName = txtParentGridID.Text + "_cmbZip_SelectedIndexChanged"; string script = "function " + cmbZipHandlerName + "(sender, args) {" + "var grd = $telerik.findGrid('" + txtParentGridID.Text + "', null);" + "ZipAutoFillCurrentEditForm(grd, args.get_item());" + "}"; // Set event handler cmbZip.OnClientSelectedIndexChanged = cmbZipHandlerName; // registering to the Page object works ScriptManager.RegisterStartupScript(Page, typeof(Page), cmbZip.ClientID + "_handler", script, true);}// These zip autofill related functions are separated in a script filefunction ZipAutoFillCurrentEditForm(grd, selectedItem) { var formItem; formItem = GetCurrentFormItem(grd); if (formItem) { var city; var state; var island; var county; var country; city = FindInputInTemplateForm(formItem, 'txtCity'); state = FindInputInTemplateForm(formItem, 'txtState'); island = FindInputInTemplateForm(formItem, 'txtIsland'); county = FindInputInTemplateForm(formItem, 'txtCounty'); country = FindInputInTemplateForm(formItem, 'txtCountry'); FillZipFields(selectedItem, city, state, island, county, country); }}// Get current form item of a gridfunction GetCurrentFormItem(grd) { var master = grd.get_masterTableView(); var formItem; if (master.get_isItemInserted()) { // insert mode formItem = master.get_insertItem(); } else { // @todo check Edit mode // get_editItems() is blank var editItem = master.get_editItems()[0]; if (editItem) { formItem = editItem.get_editFormItem(); } } return formItem;}/* Looks for a HTML element (inputbox) for a given server control - FormItem: HTML element of RadGrid's Insert/Edit form - ServerID: Server-side Control ID*/function FindInputInTemplateForm(formItem, serverID) { if (formItem != null) { var inputs = formItem.getElementsByTagName("input"); for (var i = 0; i < inputs.length; i++) { var input = inputs[i]; // test with city if (input.id.indexOf(serverID) < 0) continue; if (input.type && input.type == "text") { return input; } } }}/* Full all of the address fields that are dependent on zip code - selected: selected item (RadComboBoxItem object) - city, state, island, county, country: respective input element*/function FillZipFields(selected, city, state, island, county, country) { if (selected != null) { var attrs = selected.get_attributes(); city.value = attrs.getAttribute('City'); state.value = attrs.getAttribute('State'); island.value = attrs.getAttribute('Island'); county.value = attrs.getAttribute('County'); country.value = attrs.getAttribute('Country'); }}
<telerik:RadGrid ID="RadGrid1" runat="server" EnableTheming="false" CssClass="myClass" AllowPaging="False" OnNeedDataSource="RadGrid1_NeedDataSource" BorderStyle="None" style="outline:none;" EnableEmbeddedSkins="false" > <MasterTableView DataKeyNames="ID" ShowHeader="false" ShowFooter="false" HierarchyDefaultExpanded="true" CommandItemDisplay="None" > <ItemTemplate> </ItemTemplate> <NestedViewTemplate> <telerik:RadGrid ID="RadGrid2" runat="server" EnableTheming="false" CssClass="myClass" EnableEmbeddedSkins="false" AllowPaging="False" OnNeedDataSource="RadGrid2_NeedDataSource" BorderStyle="None" OnItemDataBound="RadGrid2_ItemDataBound" style="outline:none;" > <MasterTableView ShowHeader="false" ShowFooter="false" ShowGroupFooter="false" HierarchyDefaultExpanded="false" CommandItemDisplay="None" > <ItemTemplate> <table style="font-size:11px; width:100%;border: .1em solid #000000;table-layout: fixed; padding-left: 0px; padding-right: 0px;"> <tr> <td align="center" style="width:40px;border: .1em solid #000000;""> <asp:Label ID="lblRowNumber" runat="server" /></td> <td align="center" style="width:70px;border: .1em solid #000000;"> <%# DataBinder.Eval(Container.DataItem,"CreationDate") %></td> <td align="center" style="width:50px;border: .1em solid #000000;"> <%# DataBinder.Eval(Container.DataItem, "Number")%></td>
<td align="center" style="width:150px;border: .1em solid #000000;"> <asp:Repeater ID="Repeater3" runat="server" DataSource='<%# Eval("Owners") %>'> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "CertificateNumber")%> <%# DataBinder.Eval(Container.DataItem, "IssuedBy")%> <%# DataBinder.Eval(Container.DataItem, "WhenIssued")%> <%# DataBinder.Eval(Container.DataItem,"LegalObject")%> <%# DataBinder.Eval(Container.DataItem, "individual.FIO")%> <%# DataBinder.Eval(Container.DataItem, "legalEntity.Title")%> <%# DataBinder.Eval(Container.DataItem, "legalEntity.INN")%> <%# DataBinder.Eval(Container.DataItem, "legalEntity.OGRN")%> <%# DataBinder.Eval(Container.DataItem, "legalEntity.Address")%> <%# DataBinder.Eval(Container.DataItem, "legalEntity.LegalAddress")%> </ItemTemplate> <SeparatorTemplate> , </SeparatorTemplate> </asp:Repeater> </td>
</tr> </table> </ItemTemplate> </MasterTableView> <ClientSettings EnableAlternatingItems="false"><Selecting AllowRowSelect="False"/></ClientSettings> </telerik:RadGrid> </NestedViewTemplate> </MasterTableView> <ClientSettings EnableAlternatingItems="false" Scrolling-AllowScroll="false" ><Selecting AllowRowSelect="False"/></ClientSettings> </telerik:RadGrid>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gestionScoreSheet.aspx.cs" Inherits="GestionV2_gestionScoreSheet" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <div id="sdsGrouping"> <asp:SqlDataSource ID="sdsJoueurVisiteur" runat="server" ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>" SelectCommand="SELECT tblPersonne.strNomPersonne + N', ' + tblPersonne.strPrenomPersonne AS strNomComplet, tblJoueurPosition.strNomPosition, tblSSSubEquipeSubJoueur.FKintIDJoueurPosition, tblSSSubEquipeSubJoueur.FKintIDPersonne, tblSSSubEquipe.intIDSSEquipe, tblSS.intIDSS, tblSS.FKintIDCedule, tblSSSubEquipe.FKintIDEquipe, tblSSSubEquipeSubJoueur.intIDSSJoueur, tblSSSubEquipeSubJoueur.ysnRegulier FROM tblSSSubEquipe INNER JOIN tblSS ON tblSSSubEquipe.FKintIDSS = tblSS.intIDSS INNER JOIN tblSSSubEquipeSubJoueur INNER JOIN tblPersonne ON tblSSSubEquipeSubJoueur.FKintIDPersonne = tblPersonne.intIDPersonne INNER JOIN tblJoueurPosition ON tblSSSubEquipeSubJoueur.FKintIDJoueurPosition = tblJoueurPosition.intIDJoueurPosition ON tblSSSubEquipe.intIDSSEquipe = tblSSSubEquipeSubJoueur.FKintIDSSEquipe WHERE (tblSSSubEquipe.FKintIDEquipe = @FKintIDEquipe) AND (tblSS.intIDSS = @intIDSS) ORDER BY strNomComplet" UpdateCommand="spScoreSheetLineUPUpdate" UpdateCommandType="StoredProcedure" DeleteCommand="spScoreSheetLineUPDelete" DeleteCommandType="StoredProcedure" InsertCommand="spScoreSheetLineUpInsert" InsertCommandType="StoredProcedure"> <DeleteParameters> <asp:Parameter Name="intIDSSJoueur" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="intIDSS" Type="Int32" /> <asp:Parameter Name="strRVSSEquipe" Type="String" /> <asp:Parameter Name="FKintIDPersonne" Type="Int32" /> <asp:Parameter Name="FKintIDJoueurPosition" Type="Int32" /> <asp:Parameter Name="ysnRegulier" Type="Boolean" DefaultValue="False" /> </InsertParameters> <SelectParameters> <asp:Parameter DefaultValue="2144395403" Name="FKintIDEquipe" /> <asp:Parameter DefaultValue="2146239473" Name="intIDSS" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="intIDSSJoueur" Type="Int32" /> <asp:Parameter Name="FKintIDPersonne" Type="Int32" /> <asp:Parameter Name="FKintIDJoueurPosition" Type="Int32" /> <asp:Parameter Name="ysnRegulier" Type="Boolean" DefaultValue="False" /> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="sdsListePosition" runat="server" ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>" SelectCommand="SELECT * FROM [tblJoueurPosition]"></asp:SqlDataSource> <%--sdsListePersonne select command = SELECT top (100) percent intIDPersonne, strNomPersonne + ', ' + strPrenomPersonne AS strNomComplet FROM tblPersonne order by strNomComplet--%> <asp:SqlDataSource ID="sdsListePersonne" runat="server" ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>" SelectCommand="spListePersonne" SelectCommandType="StoredProcedure"></asp:SqlDataSource> <br /> <br /> <div> <telerik:RadGrid ID="rGridLineUpVisiteur" runat="server" AutoGenerateColumns="False" CellSpacing="0" Culture="fr-FR" DataSourceID="sdsJoueurVisiteur" GridLines="None" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowMultiRowEdit="True" AllowSorting="True" ShowFooter="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"> <MasterTableView DataSourceID="sdsJoueurVisiteur" DataKeyNames="intIDSSJoueur" EditMode="InPlace" CommandItemDisplay="TopAndBottom"> <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridTemplateColumn DataField="FKintIDPersonne" DataType="System.Int32" FilterControlAltText="Filter FKintIDPersonne column" HeaderText="Name of person" SortExpression="FKintIDPersonne" UniqueName="FKintIDPersonne"> <EditItemTemplate> <telerik:RadComboBox ID="radCombo_ListPerson" runat="server" Culture="fr-FR" DataSourceID="sdsListePersonne" AutoPostBack="true" DataTextField="strNomComplet" DataValueField="intIDPersonne" EnableAutomaticLoadOnDemand="true" ShowMoreResultsBox="true" EnableVirtualScrolling="true" ItemsPerRequest="30"> </telerik:RadComboBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblNamePerson" runat="server" Text='<%# Eval("strNomComplet") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="FKintIDJoueurPosition" DataType="System.Int32" FilterControlAltText="Filter FKintIDJoueurPosition column" HeaderText="Position of person" SortExpression="FKintIDJoueurPosition" UniqueName="FKintIDJoueurPosition"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="ysnRegulier" DataType="System.Boolean" FilterControlAltText="Filter ysnRegulier column" HeaderText="Full time player ?" SortExpression="ysnRegulier" UniqueName="ysnRegulier"> </telerik:GridCheckBoxColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> </div> </form></body></html>