# DataSourceManager.Merge Method

> Merges a binary TX internal unicode format document with the currently loaded data source.

- **Product:** TX Text Control .NET Server
- **Section:** Reference
- **Kind:** Method
- **Introduced:** 24.0
- **Namespace:** `TXTextControl.DocumentServer.DataSources`
- **Package:** `TXTextControl.TextControl.Core.SDK` (assembly `TXDocumentServer.Core.dll`, from the private NuGet feed or Text Control Offline Packages)
- **Package:** `TXTextControl.TextControl.ASP.SDK` (assembly `TXDocumentServer.dll`, from the private NuGet feed or Text Control Offline Packages)
- **.NET Framework:** reference `TXDocumentServer.dll` from the setup
- **Path:** TX Text Control .NET Server > Reference > TXTextControl.DocumentServer.DataSources > DataSourceManager.Merge Method
- **1906 words**
- **Web URL:** https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/datasourcemanager/merge-method/
- **LLMs URL:** https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/datasourcemanager/merge-method/llms.txt
- **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/datasourcemanager/merge-method/llms-full.txt

---

### Description

Merges a binary TX internal unicode format document with the currently loaded data source.

### Syntax

#### Merge(byte\[\], int, object, MergeSettings)

Merges a maximum number of data rows.

```csharp
public IList<byte[]> Merge(byte[] template, int maxDocuments, object textControl, MergeSettings mergeSettings);
```

```vbnet
Public Function Merge(template As Byte(), maxDocuments As Integer, textControl As Object, mergeSettings As MergeSettings) As IList(Of Byte())
```

| Parameter | Description |
|---|---|
| template | A binary TX internal unicode format document into which the data is merged. |
| maxDocuments | Specifies the maximum number of merged documents. |
| textControl | A TextControl instance needed for licensing purposes. Must be of one of the following types: [ServerTextControl](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol/servertextcontrol/llms-full.txt), [TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/textcontrol/llms-full.txt) or [WPF.TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/llms-full.txt). |
| mergeSettings | A [MergeSettings](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/mergesettings/llms-full.txt) instance for providing additional merge settings. |

#### Merge(byte\[\], int, object)

Merges a maximum number of data rows.

```csharp
public IList<byte[]> Merge(byte[] template, int maxDocuments, object textControl);
```

```vbnet
Public Function Merge(template As Byte(), maxDocuments As Integer, textControl As Object) As IList(Of Byte())
```

| Parameter | Description |
|---|---|
| template | A binary TX internal unicode format document into which the data is merged. |
| maxDocuments | Specifies the maximum number of merged documents. |
| textControl | A TextControl instance needed for licensing purposes. Must be of one of the following types: [ServerTextControl](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol/servertextcontrol/llms-full.txt), [TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/textcontrol/llms-full.txt) or [WPF.TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/llms-full.txt). |

#### Merge(byte\[\], object, MergeSettings)

Merges all data rows.

```csharp
public IList<byte[]> Merge(byte[] template, object textControl, MergeSettings mergeSettings);
```

```vbnet
Public Function Merge(template As Byte(), textControl As Object, mergeSettings As MergeSettings) As IList(Of Byte())
```

| Parameter | Description |
|---|---|
| template | A binary TX internal unicode format document into which the data is merged. |
| textControl | A TextControl instance needed for licensing purposes. Must be of one of the following types: [ServerTextControl](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol/servertextcontrol/llms-full.txt), [TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/textcontrol/llms-full.txt) or [WPF.TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/llms-full.txt). |
| mergeSettings | A [MergeSettings](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/mergesettings/llms-full.txt) instance for providing additional merge settings. |

#### Merge(byte\[\], object)

Merges all data rows.

```csharp
public IList<byte[]> Merge(byte[] template, object textControl);
```

```vbnet
Public Function Merge(template As Byte(), textControl As Object) As IList(Of Byte())
```

| Parameter | Description |
|---|---|
| template | A binary TX internal unicode format document into which the data is merged. |
| textControl | A TextControl instance needed for licensing purposes. Must be of one of the following types: [ServerTextControl](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol/servertextcontrol/llms-full.txt), [TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/textcontrol/llms-full.txt) or [WPF.TextControl](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/llms-full.txt). |

### Return Value

An IList of byte arrays containing one binary TX internal unicode format document for each merged data row.

### Examples

The following example uses Merge in a focused Data Source Manager workflow.

```csharp
var result = dataSourceManager.Merge(new byte[] { 1 }, "Approved");
Console.WriteLine($"Merge result: {result}");
```

```vbnet
Dim result = dataSourceManager.Merge(New Byte() { 1 }, "Approved")
Console.WriteLine($"Merge result: {result}")
```

---

## Nearby

- **Previous:** [DataSourceManager.MaxMergeResults Property](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/datasourcemanager/maxmergeresults-property/llms-full.txt)
- **Next:** [DataSourceManager.MergeCulture Property](https://docs.textcontrol.com/tx-text-control-dotnet-server/reference/txtextcontrol-documentserver-datasources/datasourcemanager/mergeculture-property/llms-full.txt)