extracting data into pdf form from oracle

Question

i want to extract the data and want to convert it to pdf from oracle.

Tuhin Paul · Answer

Hello! Data from Oracle and convert it to PDF, see below the steps: Step -1 : Connect to the Oracle database using an appropriate driver such as the Oracle Data Provider for .NET (ODP.NET) in C#. Step -2: Write a query to select the data that you want to extract. You can use SQL to query the database. Step -3: Iterate over the result set returned by the query and format it into a suitable structure for exporting to PDF. You can use a library such as iTextSharp to generate PDF documents in C#. Step -4: Save the generated PDF file to a desired location. Here is some sample C# code that shows how to extract data from Oracle and convert it to PDF using iTextSharp: // Establish connection to Oracle database using (var conn = new OracleConnection(connectionString)) { conn.Open(); // Create command to select data var command = new OracleCommand(sql, conn); // Execute command and get data reader using (var reader = command.ExecuteReader()) { // Create new PDF document var doc = new Document(); // Create PDF writer and attach it to document var writer = PdfWriter.GetInstance(doc, new FileStream(outputFilePath, FileMode.Create)); doc.Open(); // Iterate over data reader and add rows to PDF table while (reader.Read()) { var table = new PdfPTable(reader.FieldCount); for (int i = 0; i This code assumes that you have already established a connection to the Oracle database using an appropriate connection string, and have defined the SQL query to select the data you want to extract in the sql variable.

extracting data into pdf form from oracle

Answers (1)