public void grid() { DateTime StartDate = Convert.ToDateTime(TxtFromDate.Text); DateTime EndDate = Convert.ToDateTime(TxtToDate.Text); DataTable dt_values = ClsReportDeliveryChallan.Report_DeliveryChallan(StartDate, EndDate); GvwSalesOrder.DataSource = dt_values; GvwSalesOrder.DataBind(); }
protected void BtnExport_Click(object sender, EventArgs e) { if (TxtFromDate.Text != string.Empty && TxtToDate.Text != string.Empty) { DataSet ds = new DataSet(); DateTime StartDate = Convert.ToDateTime(TxtFromDate.Text.ToString()); DateTime EndDate = Convert.ToDateTime(TxtToDate.Text.ToString()); if (StartDate <= EndDate) { DataTable dt_values = ClsReportDeliveryChallan.Report_DeliveryChallan(StartDate, EndDate); if (dt_values.Rows.Count > 0) { ds.Tables.Add(dt_values); ds.Tables[0].TableName = "Delivery Challan"; ExcelHelper.ToExcel(ds, "DeliveryChallan.xls", Page.Response); } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('No Records Found...');</script>", false); } //grid(); //if (GvwSalesOrder.Rows.Count > 0) //{ // Response.Clear(); // Response.Buffer = true; // Response.AddHeader("content-disposition", "attachment;filename=DeliveryChallan.xls"); // Response.Charset = ""; // Response.ContentType = "application/vnd.ms-excel"; // using (StringWriter sw = new StringWriter()) // { // HtmlTextWriter hw = new HtmlTextWriter(sw); // //To Export all pages // GvwSalesOrder.AllowPaging = false; // this.grid(); // GvwSalesOrder.HeaderRow.Style.Add("background-color", "#FFFFFF"); // foreach (TableCell cell in GvwSalesOrder.HeaderRow.Cells) // { // cell.BackColor = GvwSalesOrder.HeaderStyle.BackColor; // } // foreach (GridViewRow row in GvwSalesOrder.Rows) // { // row.Style.Add("background-color", "white"); // //row.BackColor = Color.White; // foreach (TableCell cell in row.Cells) // { // if (row.RowIndex % 2 == 0) // { // cell.BackColor = GvwSalesOrder.AlternatingRowStyle.BackColor; // } // else // { // cell.BackColor = GvwSalesOrder.RowStyle.BackColor; // } // cell.CssClass = "textmode"; // } // } // GvwSalesOrder.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(); // } //} //else //{ // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('No Records Found');</script>", false); //} } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Todate Should be Greater than or equal to Fromdate');</script>", false); } } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select Date...');</script>", false); } }