protected void lbExport_Click(object sender, System.EventArgs e) { exportPanel.Visible = true; dgExport.DataSource = GetDataView(); dgExport.DataBind(); CManage.ExportExcel(exportPanel, "SitesExport.xls"); exportPanel.Visible = false; }
protected void lbExport_Click(object sender, System.EventArgs e) { exportPanel.Visible = true; DataView dv = DBTrialRequest.GetDataTable().DefaultView; dv.Sort = ViewState[ConstRequestSortingKey].ToString(); string sFilter = ""; if (ddReseller.SelectedItem.Value != "0") { sFilter = "ResellerTitle='" + ddReseller.SelectedItem.Text + "'"; } if (ddStatus.SelectedItem.Value == "1") { if (sFilter.Length > 0) { sFilter += "AND IsActive='True'"; } else { sFilter = "IsActive='True'"; } } if (ddStatus.SelectedItem.Value == "-1") { if (sFilter.Length > 0) { sFilter += "AND IsActive='False'"; } else { sFilter = "IsActive='False'"; } } if (sFilter.Length > 0) { dv.RowFilter = sFilter; } dgExport.DataSource = dv; dgExport.DataBind(); CManage.ExportExcel(exportPanel, "RequestsExport.xls"); exportPanel.Visible = false; }