private void ToExcel_SingleSectionWise()
        {
            //****Maximum Progressber Process Declare**********;
            progressBar1.Maximum = 9;


            //*********************Array Define*********************
            string[] SectionNames = { "b2b", "b2cl", "b2cs", "cdnr", "cdnur", "at", "exem", "hsn", "docs" };
            //*********************Data Table Array Define*********************
            DataTable[] lstDT =
            {
                B2BFormate.B2BInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),    _LastDate.ToString("dd-MMM-yyyy")),
                B2CLFormate.B2CLInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),  _LastDate.ToString("dd-MMM-yyyy")),
                B2CSFormate.B2CSInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),  _LastDate.ToString("dd-MMM-yyyy")),
                CDNRFormate.CDNRnvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),   _LastDate.ToString("dd-MMM-yyyy")),
                CDNURFormate.CDNURnvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
                ATFormate.ATInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),      _LastDate.ToString("dd-MMM-yyyy")),
                EXEMPFormate.EXEMInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
                HSNFormate.HSNInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),    _LastDate.ToString("dd-MMM-yyyy")),
                DOCSFormate.DOCSInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"),  _LastDate.ToString("dd-MMM-yyyy")),
            };
            //*******Create  <ToEX ToEX = delegate> Delegate variable***************
            ToEX ToEX = delegate
            {
                FolderBrowserDialog sfd = new FolderBrowserDialog();
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    Cursor = Cursors.WaitCursor;
                    string path = sfd.SelectedPath + "\\Section_wise_CSV_files"; // or whatever
                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    int i = 0;
                    foreach (string item in SectionNames)
                    {
                        ExportToExcel_SingleSectionWise(path + "\\" + item + ".csv", lstDT[i], item);
                        //**********method wise progressber increase**********
                        progressBar1.Value = ++MethodExecutioncount;
                        i++;
                    }
                    Cursor             = Cursors.Default;
                    progressBar1.Value = 0;
                    MessageBox.Show("Export Successfull");
                }
            };

            //*******point  <ToEX ToEX = delegate> Delegate variable***************
            ToEX();
        }
 private void b2CSREPORTToolStripMenuItem1_Click(object sender, EventArgs e)
 {
     mActiveMenuberName = "B2CS";
     dgvView.DataSource = B2CSFormate.B2CSInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy"));
     GriedDesign();
 }