protected void ExcelPrintButton_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=Warehouse_InOut_" + System.DateTime.Today.ToString("yyyy-MM-dd") + ".xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GridViewSoSort.RenderControl(htmlWrite); GridViewWRSort.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); }
protected void BindGridView() { try { if (ds.Tables["SortWRSQLTable"] == null) { } else if (ds.Tables["SortWRSQLTable"].Rows.Count == 0) { MakeEmptyGridView(GridViewWRSort, "SortWRSQLTable"); MakeEmptyGridView(GridViewWRSortCustomer, "SortWRSQLTable"); isEmptyIn = "Y"; } else { GridViewWRSort.PageSize = maxRows; GridViewWRSort.DataSource = ds.Tables["SortWRSQLTable"].DefaultView; GridViewWRSort.DataBind(); GridViewWRSortCustomer.PageSize = maxRows; GridViewWRSortCustomer.DataSource = ds.Tables["SortWRSQLTable"].DefaultView; GridViewWRSortCustomer.DataBind(); isEmptyIn = null; } if (ds.Tables["IOEmptyTable"].Rows.Count == 0) { MakeEmptyGridView2(GridView2, "IOEmptyTable"); GridView2.Visible = false; } else { GridView2.PageSize = maxRows; GridView2.DataSource = ds.Tables["IOEmptyTable"].DefaultView; GridView2.DataBind(); } if (ds.Tables["IOEmptyTable"].Rows.Count == 0) { MakeEmptyGridView2(GridView2, "IOEmptyTable"); GridView3.Visible = false; } else { GridView3.PageSize = maxRows; GridView3.DataSource = ds.Tables["IOEmptyTable"].DefaultView; GridView3.DataBind(); } if (ds.Tables["SortSoSQLTable"] == null) { } else if (ds.Tables["SortSoSQLTable"] == null || ds.Tables["SortSoSQLTable"].Rows.Count == 0) { MakeEmptyGridView(GridViewSoSort, "SortSoSQLTable"); MakeEmptyGridView(GridViewSoSortCustomer, "SortSoSQLTable"); isEmptyIn = "Y"; } else { GridViewSoSort.PageSize = maxRows; GridViewSoSort.DataSource = ds.Tables["SortSoSQLTable"].DefaultView; GridViewSoSort.DataBind(); GridViewSoSortCustomer.PageSize = maxRows; GridViewSoSortCustomer.DataSource = ds.Tables["SortSoSQLTable"].DefaultView; GridViewSoSortCustomer.DataBind(); } if (lstSortBy.SelectedIndex == 0) { GridViewSoSort.Visible = false; GridView2.Visible = false; GridViewSoSortCustomer.Visible = false; GridView3.Visible = false; if (hAccountOfAcct.Value != "" && hAccountOfAcct.Value != "0") { if (checkpart2() == true) { GridViewWRSort.Visible = false; GridViewWRSortCustomer.Visible = true; } else { GridViewWRSort.Visible = true; GridViewWRSortCustomer.Visible = false; } } else { GridViewWRSort.Visible = true; GridViewWRSortCustomer.Visible = false; } bindChildGridView("SortWRSQLTable", "InOutSQLTable", "GridViewWRDetail", GridViewWRSort, "WRRelation"); bindChildGridView("SortWRSQLTable", "InOutSQLTable", "GridViewWRCustomerDetail", GridViewWRSortCustomer, "WRRelation"); } else if (lstSortBy.SelectedIndex == 1) { if (hAccountOfAcct.Value != "" && hAccountOfAcct.Value != "0") { if (checkpart2() == true) { GridViewSoSort.Visible = false; GridView2.Visible = false; GridViewSoSortCustomer.Visible = true; GridView3.Visible = true; } else { GridViewSoSort.Visible = true; if (ds.Tables["IOEmptyTable"].Rows.Count != 0) { if (checkpart2a() == true) { GridView2.Visible = true; } else { GridView2.Visible = false; } } else { GridView2.Visible = false; } GridViewSoSortCustomer.Visible = false; GridView3.Visible = false; } } else { GridViewSoSort.Visible = true; if (ds.Tables["IOEmptyTable"].Rows.Count != 0) { if (checkpart2a() == true) { GridView2.Visible = true; } else { GridView2.Visible = false; } } GridViewSoSortCustomer.Visible = false; GridView3.Visible = false; } if (GridView2.Rows[0].Cells[0].Text.ToString() == "None") { GridView2.Visible = false; GridView3.Visible = false; } else { //if(GridViewSoSort.Rows[0].Cells[0].Text.ToString ==) } GridViewWRSort.Visible = false; GridViewWRSortCustomer.Visible = false; bindChildGridView("SortSoSQLTable", "InOutSQLTable2", "GridViewSoDetail", GridViewSoSort, "SORelation"); bindChildGridView("SortSoSQLTable", "InOutSQLTable2", "GridViewSoDetailCustomer", GridViewSoSortCustomer, "SORelation"); } Get_total(); } catch { } }