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.