How to find and replace in Word document with text from database?

4 mins read

Syncfusion Essential DocIO is a .NET Core Word library used to create, read, and edit Word documents programmatically without Microsoft Word or Interop dependencies. Using this library, you can find and replace in Word document with text from database in C#.

Steps to find and replace in Word document with text from database:

Create a new C# .NET Core console application project.
Install the Syncfusion.DocIO.Net.Core NuGet package as a reference to your .NET Core applications from NuGet.org and System.Data.SqlClient Nuget package.
Create table in database with columns "TextToFind" and "ReplacementText" as like the screenshot shown below.

Image of the database table

Include the following namespace in the Program.cs file:

using Syncfusion.DocIO;
using Syncfusion.DocIO.DLS;
using System.Data;
using System.Data.SqlClient;

Use the following code example to find and replace in Word document with text from database in C#:

using (FileStream inputStream = new FileStream(Path.GetFullPath(@"../../../Input.docx"), FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
    //Set datasource and database values.
    string datasource = "";
    string database = "";
    //Load the file stream into a Word document.
    using (WordDocument document = new WordDocument(inputStream, FormatType.Automatic))
    {
        //Create sql connection to get data from the database.
        SqlConnection sqlConnection= new SqlConnection("Data Source=" + datasource + ";Initial Catalog=" + database + ";Integrated Security=True");
        //Retrive data from the table 'FindReplace' using SqlCommand.
        SqlCommand sqlCommand = new SqlCommand("Select * from FindReplace");
        sqlCommand.Connection = sqlConnection;
 
        //Load the data into DataTable using SqlDataAdapter.
        SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCommand);
        dataAdapter.SelectCommand.CommandTimeout = 0;
        DataTable dataTable = new DataTable();
        dataAdapter.Fill(dataTable);
        //Iterate DataRow to find and replace text with other text from the database.
        foreach (DataRow row in dataTable.Rows)
        {
            //First column contains text to find.
            //Second column contains replacement text.
            document.Replace(row[dataTable.Columns[0]] as string, row[dataTable.Columns[1]] as string, false, false);
        }
        //Create a file stream.
        using (FileStream outputFileStream = new FileStream(Path.GetFullPath(@"../../../Sample.docx"), FileMode.Create, FileAccess.ReadWrite))
        {
            //Save the Word document to the file stream.
            document.Save(outputFileStream, FormatType.Docx);
        }
    }
}

A complete working sample to find and replace in Word document with text from database in C# can be downloaded from GitHub.

By executing the program, you will get the Output document as follows.

Output document generated in ASP.NET Core Word

Take a moment to peruse the documentation, where you can find basic Word document processing options along with the features like mail merge, merge and split documents, find and replace text in the Word document, protect the Word documents, and most importantly, the PDF and Image conversions with code examples.

Explore more about the rich set of Syncfusion Word Framework features.

How to find and replace in Word document with text from database?

Access denied