Jeetu .NET SQL: October 2012

Monday, 22 October 2012

How to merge multiple pdf files in .net

Step: 1 Function for merge

public void MergePDFs(string[] fileNames, string outFile)

{

int pageOffset = 0;

ArrayList master = new ArrayList();

int f = 0;

Document document = null;

PdfCopy writer = null;

while (f < (GetArrayOccupiedLenght(fileNames)-1)) //fileNames.Length-1

{

PdfReader reader = new PdfReader(fileNames[f]);

reader.ConsolidateNamedDestinations();

// we retrieve the total number of pages

int n = reader.NumberOfPages;

pageOffset += n;

if (f == 0)

{

// step 1: creation of a document-object

document = new Document(reader.GetPageSizeWithRotation(1));

// step 2: we create a writer that listens to the document

writer = new PdfCopy(document, new FileStream(outFile, FileMode.Create));

// step 3: we open the document

document.Open();

}

// step 4: we add content

for (int i = 0; i < n; )

{

++i;

if (writer != null)

{

PdfImportedPage page = writer.GetImportedPage(reader, i);

writer.AddPage(page);

}

PRAcroForm form = reader.AcroForm;

if (form != null && writer != null)

{

writer.CopyAcroForm(reader);

}

f++;

}

// step 5: we close the document

if (document != null)

{

document.Close();

}

Step2: How to Call

public void MyPDFs()

{

string[] files;

string MergedPath;

files[0] = "D:\abc.pdf";

files[1] = "D:\xyz.pdf";

files[2] = "D:\pqr.pdf";

MergedPath = "D:\MergedFile.pdf";

MergePDFs(files,MergedPath);

}

Note : Don't forget to use the iTextSharp Namespace.

Tuesday, 9 October 2012

How to fast Export Datatable into Excel sheet in .net

Just Put this function and Pass argument as datatable in Your code

private void ExporttoExcelFast(DataTable table)

{

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.ClearContent();

HttpContext.Current.Response.ClearHeaders();

HttpContext.Current.Response.Buffer = true;

HttpContext.Current.Response.ContentType = "application/ms-excel";

HttpContext.Current.Response.Write(@"<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">");

HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=DAS.xls");

HttpContext.Current.Response.Charset = "utf-8";

HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1250");

//sets font

HttpContext.Current.Response.Write("<font style='font-size:10.0pt; font-family:Calibri;'>");

HttpContext.Current.Response.Write("<BR><BR><BR>");

//sets the table border, cell spacing, border color, font of the text, background, foreground, font height

HttpContext.Current.Response.Write("<Table border='1' bgColor='#ffffff' " +

"borderColor='#000000' cellSpacing='0' cellPadding='0' " +

"style='font-size:10.0pt; font-family:Calibri; background:white;'> <TR>");

//am getting my grid's column headers

int columnscount = table.Columns.Count;

for (int j = 0; j < columnscount; j++)

{ //write in new column

HttpContext.Current.Response.Write("<Td bgcolor='#6699cc'>");

//Get column headers and make it as bold in excel columns

HttpContext.Current.Response.Write("<B>");

HttpContext.Current.Response.Write(table.Columns[j].ColumnName);

HttpContext.Current.Response.Write("</B>");

HttpContext.Current.Response.Write("</Td>");

}

HttpContext.Current.Response.Write("</TR>");

foreach (DataRow row in table.Rows)

{//write in new row

HttpContext.Current.Response.Write("<TR>");

for (int i = 0; i < table.Columns.Count; i++)

{

if (row[i].ToString() == "01/01/1754")

{

if (table.Rows.IndexOf(row) % 2 == 0)

{

HttpContext.Current.Response.Write("<Td>");

HttpContext.Current.Response.Write(" ");

HttpContext.Current.Response.Write("</Td>");

}

else

{

HttpContext.Current.Response.Write("<Td bgcolor='#dcf2f8'>");

HttpContext.Current.Response.Write(" ");

HttpContext.Current.Response.Write("</Td>");

}

else

{

if (table.Rows.IndexOf(row) % 2 == 0)

{

HttpContext.Current.Response.Write("<Td>");

HttpContext.Current.Response.Write(row[i].ToString());

HttpContext.Current.Response.Write("</Td>");

}

else

{

HttpContext.Current.Response.Write("<Td bgcolor='#dcf2f8'>");

HttpContext.Current.Response.Write(row[i].ToString());

HttpContext.Current.Response.Write("</Td>");

}

HttpContext.Current.Response.Write("</TR>");

}

HttpContext.Current.Response.Write("</Table>");

HttpContext.Current.Response.Write("</font>");

HttpContext.Current.Response.Flush();

HttpContext.Current.Response.End();

}