or
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>protected void SetAshGraph(RadChart RadChart, string bpAshValue, string apAshValue, string apTotSedi, string bpTotSedi, string ymax, string ymin, string steps, string title, string yaxislabel) { //------------------------------Setting Rad Chart Properties RadChart.Clear(); RadChart.RemoveAllSeries(); RadChart.Margins.Left = Unit.Percentage(25); RadChart.Margins.Bottom = Unit.Percentage(17); RadChart.Margins.Right = Unit.Percentage(10); RadChart.Title.Text = title; RadChart.Title.TextFont = new System.Drawing.Font("Verdana", 9, System.Drawing.FontStyle.Bold); RadChart.Title.Background.MainColor = Color.Transparent; RadChart.Title.Background.BorderColor = Color.Transparent; RadChart.Title.Background.FillStyle = FillStyle.Solid; //----------------------setting X porperties RadChart.XAxis.Clear(); //RadChart.XAxis.Label.TextFont = new System.Drawing.Font("Verdana", 3, System.Drawing.FontStyle.Regular); //RadChart.XAxis.Items.Font = new System.Drawing.Font("Verdana", 2, System.Drawing.FontStyle.Regular); RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[0].Visible = false; //RadChart.XAxis.Items[0].Value = -1; RadChart.XAxis.AddItem("BP \nAsh"); //RadChart.XAxis.Items[1].Value = 0; RadChart.XAxis.AddItem("AP \nAsh"); //RadChart.XAxis.Items[2].Value = 1; RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[3].Visible = false; //RadChart.XAxis.Items[3].Value = -2; RadChart.XAxis.AddItem("BP \nTSA"); //RadChart.XAxis.Items[4].Value = 2; RadChart.XAxis.AddItem("AP \nTSA"); //RadChart.XAxis.Items[5].Value = 3; RadChart.BarOverlapPercent = 0; RadChart.BarWidthPercent = 100; RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[6].Value = -3; //RadChart.XAxis.Items[6].Visible = false; RadChart.XAxis.AxisWidth = 1; RadChart.XAxis.AxisColor = Color.Black; RadChart.XAxis.Label.TextColor = Color.Black; //----------------------setting y porperties RadChart.YAxis.AddRange(double.Parse(ymin), double.Parse(ymax), double.Parse(steps)); // RadChart.YAxis.AutoScale = true; RadChart.YAxis.Label.Text = yaxislabel; RadChart.YAxis.Label.TextFont = new System.Drawing.Font("Verdana", 8, System.Drawing.FontStyle.Bold); RadChart.YAxis.AxisColor = Color.Black; RadChart.YAxis.Label.TextColor = Color.Black; RadChart.YAxis.AxisWidth = 1; RadChart.YAxis.DefaultItemColor = System.Drawing.Color.Black; //RadChart.YAxis.VisibleValues = ChartAxisVisibleValues.Positive; RadChart.XAxis.DefaultItemColor = System.Drawing.Color.Black; //RadChart.XAxis.VisibleValues = ChartAxisVisibleValues.Positive; //RadChart.XAxis.AutoScale = false; //RadChart.XAxis.AutoShrink = true; //------------------------------Adding Chart series Properties ChartSeries s = RadChart.CreateSeries("Series", Color.DarkViolet, ChartSeriesType.Bar); s.Items.Series.Appearance.FillStyle = FillStyle.Solid; s.Items.Series.Appearance.BorderColor = Color.Black; ChartSeriesItem items0 = new ChartSeriesItem(); items0.YValue = double.Parse(ymin); //items0.XValue = -1; s.Items.Add(items0); s.Items[0].Label = " "; //-----------------------------first Item i.e Bp/Ap reading ChartSeriesItem items1 = new ChartSeriesItem(); double dd; if (double.TryParse(bpAshValue, out dd)) { items1.YValue = dd; s.Items.Add(items1); //anks //s.Items[0].Appearance.MainColor = Color.FromArgb(153, 51, 101); //s.Items[0].Appearance.SecondColor = Color.FromArgb(153, 51, 101); s.Items[1].Appearance.MainColor = Color.FromArgb(198, 83, 138); s.Items[1].Appearance.SecondColor = Color.FromArgb(198, 83, 138); s.Items[1].Label = " "; } else { items1.YValue = dd; s.Items.Add(items1); s.Items[1].Label = " "; } ChartSeriesItem items2 = new ChartSeriesItem(); if (double.TryParse(apAshValue, out dd)) { items2.YValue = dd; s.Items.Add(items2); //anks //s.Items[1].Appearance.MainColor = Color.FromArgb(154, 153, 255); //s.Items[1].Appearance.SecondColor = Color.FromArgb(154, 153, 255); s.Items[2].Appearance.MainColor = Color.FromArgb(180, 179, 255); s.Items[2].Appearance.SecondColor = Color.FromArgb(180, 179, 255); s.Items[2].Label = " "; } ChartSeriesItem items3 = new ChartSeriesItem(); items3.YValue = double.Parse(ymin); //items3.XValue = -2; s.Items.Add(items3); s.Items[3].Label = " "; ChartSeriesItem items4 = new ChartSeriesItem(); if (double.TryParse(bpTotSedi, out dd)) { items4.YValue = dd; s.Items.Add(items4); //anks //s.Items[2].Appearance.MainColor = Color.FromArgb(153, 51, 101); //s.Items[2].Appearance.SecondColor = Color.FromArgb(153, 51, 101); s.Items[4].Appearance.MainColor = Color.FromArgb(198, 83, 138); s.Items[4].Appearance.SecondColor = Color.FromArgb(198, 83, 138); s.Items[4].Label = " "; } ChartSeriesItem items5 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { items5.YValue = dd; s.Items.Add(items5); //anks //s.Items[3].Appearance.MainColor = Color.FromArgb(154, 153, 255); //s.Items[3].Appearance.SecondColor = Color.FromArgb(154, 153, 255); s.Items[5].Appearance.MainColor = Color.FromArgb(180, 179, 255); s.Items[5].Appearance.SecondColor = Color.FromArgb(180, 179, 255); s.Items[5].Label = " "; } ChartSeriesItem items6 = new ChartSeriesItem(); items6.YValue = double.Parse(ymin); //items6.XValue = -3; s.Items.Add(items6); s.Items[6].Label = " "; RadChart.AddChartSeries(s); //anks ChartSeries s1 = RadChart.CreateSeries("LineSeries", Color.Black, ChartSeriesType.Line); s1.Items.Series.Appearance.FillStyle = FillStyle.Solid; s1.Items.Series.Appearance.BorderColor = Color.Black; s1.Items.Series.ShowLabels = true; //RadChart.XAxis.LayoutStyle = ChartAxisLayoutStyle.Between; RadChart.XAxis.LayoutStyle = ChartAxisLayoutStyle.Normal; ChartSeriesItem LineItems0 = new ChartSeriesItem(); if (double.TryParse(bpAshValue, out dd)) { LineItems0.YValue = 1.5; s1.Items.Add(LineItems0); s1.Items[0].Appearance.MainColor = Color.Black; s1.Items[0].Label = "This is a strip line line li"; s1.Items[0].Series.LabelAppearance.TextFont = new Font("Times New Roman", 9, FontStyle.Bold | FontStyle.Italic); s1.Items[0].Series.LabelAppearance.TextColor = Color.Black; //s1.Items[0].Series.LabelAppearance.TextColor = Color.Gold; } else { LineItems0.YValue = 1.5; s1.Items.Add(LineItems0); s1.Items[0].Label = " "; } ChartSeriesItem LineItems1 = new ChartSeriesItem(); if (double.TryParse(bpAshValue, out dd)) { LineItems1.YValue = 1.5; s1.Items.Add(LineItems1); s1.Items[1].Appearance.MainColor = Color.Black; s1.Items[1].Label = " "; } ChartSeriesItem LineItems2 = new ChartSeriesItem(); if (double.TryParse(apAshValue, out dd)) { LineItems2.YValue = 1.5; s1.Items.Add(LineItems2); s1.Items[2].Appearance.MainColor = Color.Black; s1.Items[2].Label = " "; } ChartSeriesItem LineItems3 = new ChartSeriesItem(); if (double.TryParse(bpTotSedi, out dd)) { LineItems3.YValue = 1.5; s1.Items.Add(LineItems3); s1.Items[3].Appearance.MainColor = Color.Black; s1.Items[3].Label = " "; } ChartSeriesItem LineItems4 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems4.YValue = 1.5; s1.Items.Add(LineItems4); s1.Items[4].Appearance.MainColor = Color.Black; s1.Items[4].Label = " "; } ChartSeriesItem LineItems5 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems5.YValue = 1.5; s1.Items.Add(LineItems5); s1.Items[5].Appearance.MainColor = Color.Black; s1.Items[5].Label = " "; } ChartSeriesItem LineItems6 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems6.YValue = 1.5; s1.Items.Add(LineItems6); s1.Items[6].Appearance.MainColor = Color.Black; s1.Items[6].Label = " "; } RadChart.AddChartSeries(s1); }