private void ExportGridToExcel() { try { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=ExportGridData.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; using (System.IO.StringWriter StringWriter = new System.IO.StringWriter()) { HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); GridTicketData.AllowPaging = false; this.TicketDataGrid(); GridTicketData.CssClass = "rounded_corners"; foreach (GridViewRow row in GridTicketData.Rows) { foreach (TableCell cell in row.Cells) { cell.Attributes.CssStyle["text-align"] = "center"; List <Control> controls = new List <Control>(); //Add controls to be removed to Generic List foreach (Control control in cell.Controls) { controls.Add(control); } foreach (Control control in controls) { switch (control.GetType().Name) { case "Label": cell.Controls.Add(new Literal { Text = (control as Label).Text }); break; } cell.Controls.Remove(control); } } } GridTicketData.RenderControl(HtmlTextWriter); Response.Write(StringWriter.ToString()); Response.End(); } } catch (Exception ex) { throw ex; } }
private void ExportGridToExcel() { GridTicketData.AllowPaging = true; this.TicketDataGrid(); Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename= " + DropDownList1.SelectedValue + "" + "Data.xls"); Response.ContentType = "File/Data.xls"; StringWriter StringWriter = new System.IO.StringWriter(); HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); GridTicketData.RenderControl(HtmlTextWriter); Response.Write(StringWriter.ToString()); Response.End(); }
private void TicketDataGrid() { SqlConnection con = new SqlConnection(constr); con.Open(); using (con) { using (SqlCommand cmd = new SqlCommand("select * from Asset_Master Where AMS_Date_of_Purchase between'" + string.Format("{0:yyyy-MM-dd}", DateTime.Parse(fromDate.Text, new CultureInfo("gu-IN", false))) + "'AND '" + string.Format("{0:yyyy-MM-dd}", DateTime.Parse(todate.Text, new CultureInfo("gu-IN", false))) + "' AND AMS_AssetType Like'" + '%' + ReportAssetType.SelectedValue + '%' + "'")) { SqlDataAdapter dt = new SqlDataAdapter(); try { cmd.Connection = con; dt.SelectCommand = cmd; DataTable dTable = new DataTable(); dt.Fill(dTable); SqlDataReader sdr = cmd.ExecuteReader(); GridTicketData.DataSource = dTable; GridTicketData.DataBind(); if (GridTicketData.Rows.Count != 0) { exportToExcel.Visible = true; GridTicketData.CssClass = "table table-bordered table-striped table-inverse nomargin"; GridTicketData.UseAccessibleHeader = true; //GridTicketData.HeaderRow.TableSection = TableRowSection.TableHeader; //GridTicketData.FooterRow.TableSection = TableRowSection.TableFooter; } else { exportToExcel.Visible = false; ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('There is no data');", true); } } catch (Exception ex) { throw ex; } } } con.Close(); }
protected void ExportToExcel(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages GridTicketData.AllowPaging = false; this.BindGrid(); foreach (TableCell cell in GridTicketData.HeaderRow.Cells) { cell.BackColor = GridTicketData.HeaderStyle.BackColor; } foreach (GridViewRow row in GridTicketData.Rows) { foreach (TableCell cell in row.Cells) { if (row.RowIndex % 2 == 0) { cell.BackColor = GridTicketData.AlternatingRowStyle.BackColor; } else { cell.BackColor = GridTicketData.RowStyle.BackColor; } cell.CssClass = "textmode"; } } GridTicketData.RenderControl(hw); //style to format numbers to string string style = @"<style> .textmode { } </style>"; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } }
private void ExportGridToword() { Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; string FileName = "Report" + DateTime.Now + ".doc"; StringWriter strwritter = new StringWriter(); HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/msword"; Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName); GridTicketData.GridLines = GridLines.Both; GridTicketData.HeaderStyle.Font.Bold = true; GridTicketData.RenderControl(htmltextwrtter); Response.Write(strwritter.ToString()); Response.End(); }
//Other text export code private void BindGrid() { using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM HardwareDbTable")) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); GridTicketData.DataSource = dt; GridTicketData.DataBind(); } } } } }
private void TicketDataGrid() { if (DropDownList1.SelectedValue == "All") { using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("select TMSTicketID as TicketID ,TMSTicketSubject as Subject,TMSTicketDepartment as Department,TMSTicketDescription as Description,TMSTicketPriority as Priority,TMSTicketStatus as Status,TMSTicketDate as Date,TMSTicketOwnership as Ownership from TMSTicketMaster Where TMSTicketDate>='" + fromDate.Text + "'and TMSTicketDate<='" + todate.Text + "'")) { SqlDataAdapter dt = new SqlDataAdapter(); try { cmd.Connection = con; con.Open(); dt.SelectCommand = cmd; DataTable dTable = new DataTable(); dt.Fill(dTable); SqlDataReader sdr = cmd.ExecuteReader(); GridTicketData.DataSource = dTable; GridTicketData.DataBind(); } catch (Exception ex) { Console.Write(ex.Message); // Error msg display here } } } } else if (DropDownList1.SelectedValue == "Sla") { using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("select TMSTicketID as TicketID ,TMSTicketSubject as Subject,TMSTicketDepartment as Department,TMSTicketDescription as Description,TMSTicketPriority as Priority,TMSTicketStatus as Status,TMSTicketDate as SubmittedDate,TMSTicketOwnership as Ownership,DeviationTime from TMSTicketMaster Where (TMSTicketDate>='" + fromDate.Text + "'and TMSTicketDate<='" + todate.Text + "') and (Level2Escalation<GETDATE() or Level3Escalation<GETDATE()) ")) { SqlDataAdapter dt = new SqlDataAdapter(); try { cmd.Connection = con; con.Open(); dt.SelectCommand = cmd; DataTable dTable = new DataTable(); dt.Fill(dTable); SqlDataReader sdr = cmd.ExecuteReader(); GridTicketData.DataSource = dTable; GridTicketData.DataBind(); } catch (Exception) { // Error msg display here } } } } else { using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("select TMSTicketID as TicketID ,TMSTicketSubject as Subject,TMSTicketDepartment as Department,TMSTicketDescription as Description,TMSTicketPriority as Priority,TMSTicketStatus as Status,TMSTicketDate as SubmittedDate,TMSTicketOwnership as Ownership from TMSTicketMaster Where TMSTicketDate>='" + fromDate.Text + "'and TMSTicketDate<='" + todate.Text + "' and TMSTicketPriority='" + DropDownList1.SelectedValue + "'")) { SqlDataAdapter dt = new SqlDataAdapter(); try { cmd.Connection = con; con.Open(); dt.SelectCommand = cmd; DataTable dTable = new DataTable(); dt.Fill(dTable); SqlDataReader sdr = cmd.ExecuteReader(); GridTicketData.DataSource = dTable; GridTicketData.DataBind(); } catch (Exception ex) { Console.Write(ex.Message); // Error msg display here } } } } }