Esempio n. 1
0
        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;
        }
Esempio n. 2
0
        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;
        }