or
var listDisengTrains = Final.Select(g => new { Date = Convert.ToDateTime(g.Date).ToOADate(), Trains1 = g.Trains1, Trains2 = g.Trains2, Trains1RecIds = "12345,23456", Trains2RecIds = "34567,45678,56789"});protected void ChartTrains_ItemDataBound(object sender, ChartItemDataBoundEventArgs e)<BR>{<BR>if (e.SeriesItem != null)<BR>{<BR>if (e.ChartSeries.Index % 2 == 0)<BR>{ <BR>e.SeriesItem.ActiveRegion.Url = string.Format("javascript:ShowTrainInfoForm({0}", ?)<BR>}<BR>else<BR>{<BR>;<BR>}<BR><BR>}<BR>}<BR>
Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As EventArgs) Me.RadGrid1.MasterTableView.GetColumn("Location").Display = True 'This field contains the network location Me.RadGrid1.MasterTableView.GetColumn("Proposal_NotIssued").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_NotIssuedReason").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_Qualification").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_EstimatedProjectArea").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_EstimatedConstructionCost").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_WinningProbabilityPct").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_DateGranted").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_ProjectID").Display = True Me.RadGrid1.MasterTableView.GetColumn("Proposal_Comments").Display = True For Each item As GridDataItem In Me.RadGrid1.Items If item.Selected = False Then item.Visible = False End If Next Me.RadGrid1.Rebind() Me.RadGrid1.ExportSettings.ExportOnlyData = True Me.RadGrid1.ExportSettings.OpenInNewWindow = True Me.RadGrid1.ExportSettings.FileName = "Selected Proposals " & Format(Now, "yyyy-MM-dd-h-mm-ss") 'Me.RadGrid1.ExportSettings.IgnorePaging = True Me.RadGrid1.ExportSettings.UseItemStyles = True Me.RadGrid1.MasterTableView.ExportToExcel()End Sub<telerik:RadGrid ID="durationGrid" runat="server" DataSourceID="durationDataSource" OnItemCommand="durationGrid_ItemCommand" AllowPaging="true" OnItemCreated="durationGrid_ItemCreated"> <MasterTableView runat="server" CommandItemDisplay="Top" UseAllDataFields="true" AutoGenerateColumns="false" DataKeyNames="ID"> <Columns> <telerik:GridBoundColumn DataField="Stat" HeaderText="Status" SortExpression="Stat" ReadOnly="true" /> <telerik:GridBoundColumn DataField="ItemName" HeaderText="Name" SortExpression="ItemName" ReadOnly="true" /> <telerik:GridBoundColumn DataField="PartNumber" HeaderText="Part Number" SortExpression="PartNumber" ReadOnly="true" /> <telerik:GridBoundColumn DataField="Serial" HeaderText="Serial #" SortExpression="Serial" ReadOnly="true" /> <telerik:GridBoundColumn DataField="LotNumber" HeaderText="Lot #" SortExpression="LotNumber" ReadOnly="true" /> <telerik:GridBoundColumn DataField="CrossRefID" HeaderText="PS #" SortExpression="CrossRefID" ReadOnly="true" /> <telerik:GridBoundColumn DataField="OEM" HeaderText="OEM" SortExpression="OEM" ReadOnly="true" /> <telerik:GridBoundColumn DataField="Consigned" HeaderText="Consigned" ReadOnly="true" /> <telerik:GridBoundColumn DataField="location" HeaderText="Location" SortExpression="location" ReadOnly="true" /> <telerik:GridBoundColumn DataField="Value" HeaderText="Value" SortExpression="Value" ReadOnly="true" DataFormatString="{0:c}" /> <telerik:GridBoundColumn DataField="ExpirationDate" HeaderText="Expiration Date" SortExpression="ExpirationDate" ReadOnly="true" DataFormatString="{0:MM/dd/yyy}" /> <telerik:GridTemplateColumn HeaderText=""> <ItemTemplate> <asp:ImageButton ID="NotesBtn" runat="server" ImageUrl="images/icons/notes.png" OnClick="NotesBtn_Click" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false" /> </MasterTableView> <ExportSettings FileName="Duration Report"></ExportSettings> </telerik:RadGrid> <telerik:RadWindowManager ID="winma2" runat="server"> <Windows> <telerik:RadWindow ID="NotesWindow" runat="server" Modal="true" Behaviors="Close, Move" Width="540px" Height="490px" DestroyOnClose="false" VisibleStatusbar="false" ShowContentDuringLoad="false" ReloadOnShow="true" Skin="Simple" OnClientShow="OnClientShow" Title="Item Notes Editor" > </telerik:RadWindow> </Windows> </telerik:RadWindowManager>protected void NotesBtn_Click(object sender, EventArgs e) { string script = "function openRadWin(value) {var win = $find('" + NotesWindow.ClientID + "');alert(win); Sys.Application.remove_load(openRadWin);}Sys.Application.add_load(openRadWin);"; ScriptManager.RegisterStartupScript(this, this.GetType(), "key", script, true); } protected void durationGrid_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridCommandItem) { Button btncmd = (e.Item as GridCommandItem).FindControl("ExportToExcelButton") as Button; if (btncmd != null) { RadScriptManager.GetCurrent(this.Page).RegisterPostBackControl(btncmd); } } if (e.Item is GridDataItem) { ImageButton NotesBtn = (ImageButton)e.Item.FindControl("NotesBtn"); NotesBtn.OnClientClick = "openRadWin('" + e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"] + "');"; } }