How to export all the files in PDF format at a time

Question

0.00/5 (No votes)

See more:

How to export multiple files in PDF format through ASP.NET at a time. File format is already updated in Crystal report. My code attached here. this is use to only one PDFfile save at a time.

C#

public void updatestaus(string F)
    {
        sc.Close();
        sc.Open();
        SqlCommand cmd = new SqlCommand("update BOND_REG set status='P' where fliono='"+F+"'", sc);
        cmd.ExecuteNonQuery();
        sc.Close();


    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        sc.Open();
        SqlCommand cmd = new SqlCommand("select Fliono from BOND_REG where status='A'", sc);
        SqlDataReader SDR = cmd.ExecuteReader();
        while (SDR.Read() == true)
        {
            string St = SDR.GetValue(0).ToString();
            //SDR.Close();
          // SDR.Dispose();
            fileexport(St);
            updatestaus(St);

        }
        SDR.Close();
        sc.Close();

    }

    public void fileexport(string st1)
    {
       // SDR.Close(); 
        SqlCommand cmd1 = new SqlCommand("select * from BOND_REG where status='A' and Fliono='" + st1 + "'", sc);
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd1;
        DataTable datatable = new DataTable();
        da.Fill(datatable);
        ReportDocument crystalReport = new ReportDocument();
        crystalReport.Load(Server.MapPath("~/bond.rpt"));
        crystalReport.SetDataSource(datatable);
        ExportOptions rptExportOption;
        DiskFileDestinationOptions rptFileDestOption = new DiskFileDestinationOptions();
        PdfRtfWordFormatOptions rptFormatOption = new PdfRtfWordFormatOptions();
        string reportFileName = @"C:\pdfd\ st1.pdf";
        rptFileDestOption.DiskFileName = reportFileName;
        rptExportOption = crystalReport.ExportOptions;
        {
            rptExportOption.ExportDestinationType = ExportDestinationType.DiskFile;
                       rptExportOption.ExportFormatType = ExportFormatType.PortableDocFormat;
            rptExportOption.ExportDestinationOptions = rptFileDestOption;
            rptExportOption.ExportFormatOptions = rptFormatOption;
        }

        crystalReport.Export();
    }

Posted 31-May-15 18:13pm

Unni R

Updated 31-May-15 18:28pm

DamithSL

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2015-05-31T18:27:00

I think the problem is in each record your application overwrite the same pdf file. try to build unique file name like below

C#

string reportFileName =string.Format(@"C:\pdfd\st1_{0}.pdf",st1) ;

or append timespan to file name.[^]

You can avoid connection related issues by introducing methods to do the database operations and properly handling database connections in those methods. for example,

C#

public List<string> GetFlionoList()
{
    List<string>  flionoList = new List<string>();
    using(SqlConnection connection = new SqlConnection(yourConnectionString) )
	using(SqlCommand cmd = new SqlCommand("select Fliono from BOND_REG where status='A'", connection))
	{
		connection.Open();
		using(SqlDataReader sdr= cmd.ExecuteReader())
		{
			while (sdr.Read())
			{
			  flionoList.Add(sdr.Getstring(0));
			}
		}
	}
	return flionoList;
}

public void UpdateStaus(string fliono)
{
   using(SqlConnection connection = new SqlConnection(yourConnectionString) )
   using(SqlCommand cmd = new SqlCommand("update BOND_REG set status='P' where fliono='"+fliono+"'", connection))
   {
   		connection.Open();
   		cmd.ExecuteNonQuery();
   }
}

Now you can call GetFlionoList() and get the list and iterate each item of the list and call methods like UpdateStaus for each item. make sure that you have dispose the connection and readers using "using blocks"