or


| /// <summary> |
| /// Exports data in grid to excel |
| /// </summary> |
| public void Export() |
| { |
| //rgdProjectWorksheets.ExportSettings.ExportOnlyData = true; |
| //rgdProjectWorksheets.ExportSettings.IgnorePaging = true; |
| //rgdProjectWorksheets.MasterTableView.ExportToExcel(); |
| PWDetailAccess pwa = new PWDetailAccess(); |
| DataTable dt = pwa.GetFlatExportData(Convert.ToInt32(Session[ApplicationConstants.SessionVariables.OrganizationID].ToString())); |
| List<int> idlist = GetVisibleIDList(); |
| HttpContext context = HttpContext.Current; |
| context.Response.Clear(); |
| foreach (DataColumn column in dt.Columns) |
| { |
| context.Response.Write(column.ColumnName + ","); |
| } |
| context.Response.Write(Environment.NewLine); |
| foreach (DataRow row in dt.Rows) |
| { |
| if (!idlist.Contains(Convert.ToInt32(row[PWDetailsSchema.ID].ToString()))) |
| continue; |
| for (int i = 0; i < dt.Columns.Count; i++) |
| { |
| context.Response.Write(row[i].ToString().Replace(",", string.Empty) + ","); |
| } |
| context.Response.Write(Environment.NewLine); |
| } |
| context.Response.ContentType = "text/csv"; |
| context.Response.AppendHeader("Content-Disposition", "attachment; filename=SA_FlatExport.csv"); |
| context.Response.End(); |
| } |
| private List<int> GetVisibleIDList() |
| { |
| List<int> idlist = new List<int>(); |
| for (int i = 0; i < rgdProjectWorksheets.MasterTableView.Items.Count; i++) |
| { |
| if (rgdProjectWorksheets.Items[i].Visible == true) |
| idlist.Add(Convert.ToInt32(rgdProjectWorksheets.Items[i][PWDetailsSchema.ID].Text)); |
| } |
| return idlist; |
| } |

<div> <telerik:RadTileList runat="server" ID="RadTileList1"></telerik:RadTileList> </div>protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PopulateTileList(0); PopulateRadMenu(); } } protected void PopulateTileList(int tileId) { string sqlWhere = string.Empty; if (tileId == 0) { sqlWhere = string.Empty; } else { sqlWhere = " where intDirectoriteId = " + tileId; } sql = "select intAppId, strAppName, strTooltip, strUrl, strNotes, s.strColor from tblApplications a INNER JOIN tblStatus s on s.intStatusID = a.intStatusID " + sqlWhere; mydatatable = new DataTable(); mydatatable = c.GetReader(sql); TileGroup tg = new TileGroup(); RadTileList1.Groups.Add(tg); foreach (DataRow row in mydatatable.Rows) { RadContentTemplateTile tile = new RadContentTemplateTile(); tg.Tiles.Add(tile); LinkButton linkfav = new LinkButton(); linkfav.Attributes.Add("runat", "server"); linkfav.Click += new EventHandler(linkfav_Click); linkfav.Text = "favorites"; linkfav.Attributes.Add("CommandName", "AddFavorites"); linkfav.Attributes.Add("CommandArgument", row[0].ToString()); tile.ID = row[0].ToString(); tile.Name = row[1].ToString(); tile.ContentContainer.GroupingText = row[1].ToString(); tile.ToolTip = row[2].ToString(); // tile.NavigateUrl = row[3].ToString(); tile.BackColor = System.Drawing.ColorTranslator.FromHtml(row[5].ToString()); //Peektemplate tile.PeekTemplateSettings.Animation = PeekTemplateAnimation.Slide; tile.PeekTemplateSettings.HidePeekTemplateOnMouseOut = true; tile.PeekTemplateSettings.ShowPeekTemplateOnMouseOver = true; tile.PeekContentContainer.Controls.Add(new LiteralControl(row[4].ToString())); tile.PeekContentContainer.Controls.Add(linkfav); tile.PeekTemplateSettings.CloseDelay = 0; tile.PeekTemplateSettings.ShowInterval = 0; } } private void PopulateRadMenu() { sql = "select intDirectoriteID, strDirectorite from tblDirectorite where bitActive = 1"; rdmenu.DataTextField = "strDirectorite"; rdmenu.DataValueField = "intDirectoriteID"; rdmenu.CssClass = "Menuitems"; rdmenu.DataSource = c.GetReader(sql); rdmenu.DataBind(); } protected void rdmenu_ItemClick(object sender, Telerik.Web.UI.RadMenuEventArgs e) { switch (e.Item.Value) { case "1": PopulateTileList(1); break; case "2": PopulateTileList(2); break; case "3": PopulateTileList(3); break; case "4": PopulateTileList(4); break; case "5": PopulateTileList(5); break; case "6": PopulateTileList(6); break; case "7": PopulateTileList(7); break; } } protected void linkfav_Click(object sender, EventArgs e) { Response.Write("Try this LinkButton!"); } }<telerik:RadGrid ID="RadGrid1" EnableViewState="false" runat="server" AllowPaging="true" AllowSorting="False" AllowFilteringByColumn="true" GridLines="None" OnInit="RadGrid1_Init" OnDeleteCommand="RadGrid1_DeleteCommand"> <ItemStyle Wrap="false"></ItemStyle> <MasterTableView AllowMultiColumnSorting="true" TableLayout="Fixed" DataKeyNames="Id" ClientDataKeyNames="Id"> <Columns> <telerik:GridNumericColumn DataField="Id" HeaderText="Id" HeaderStyle-Width="100px" AllowFiltering="False" FilterControlWidth="50px"> <telerik:GridTemplateColumn UniqueName="" HeaderText="Select"> <ItemTemplate> <asp:RadioButton ID="rbdSelect" runat="server" AutoPostBack="true" OnCheckedChanged="rbdSelect_CheckedChanged"></asp:RadioButton> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView>protected void rbdSelect_CheckedChanged(object sender, EventArgs e) { foreach (GridDataItem item in RadGrid1.MasterTableView.Items) { RadioButton rbd = (RadioButton)item.FindControl("rbdSelect"); if (rbd.Checked == true) { string key = item.GetDataKeyValue("Id").ToString(); Response.Redirect("~/Default.aspx"); } } }
