DbNetGrid allows the user to select a sample of data and then merge this data sample with a MS Word document. This example demonstrates a number ways in which this can be done including the creation of a new document, opening an existing document from the local file system or merging with a pre-defined specified document that has been deployed on the web server. When merging with an existing document you can additionally elect to perform the merge automatically after opening the document

Register the component libraries

Server Control

<form id="Form1" name="Form1" method="post" runat="server">
	<table>
		<tr>
			<td>
				<div id=customers.toolbar></div>
			</td>
		</tr>
		<tr>
			<td>
				<fieldset><legend>Merge Options</legend>
				<table>
					<tr>
						<td class=label>Document selection</td>
						<td>
							<select id=mergeDocumentMode onchange=setMergeDocumentMode()>
								<option value="">Default mode
								<option value="new">New document mode
								<option value="open">Open document mode
								<option value="labels.doc" selected>Pre-selected document mode (Labels)
								<option value="letter.doc">Pre-selected document mode (Letter)
							</select>
						</td>
						<td class=label>Execute Merge On Open</td>
						<td>
							<input id=mergeExecute onclick=setMergeDocumentMode() type=checkbox checked></input>
						</td>
						<td>
							<button onclick=merge()>Merge</button>
						</td>
					</tr>
				</table>
				</fieldset>
			</td>
		</tr>
		<tr>
			<td>
				<DNL:DbNetGrid 
					id="customers" 
					runat="server" 
					ConnectionString = "samples"
					FromPart = "customers"
					SelectPart = "Customerid,Companyname,Contactname,Contacttitle,Address,City,Region,Postalcode,Country,Phone,Fax"
					Headings = "ID,Name,Contact,Title,Address,City,Region,Post Code,Country,Phone,Fax"

DatasourceColumns = "Companyname,Contactname,Contacttitle,Address,City,Region,Postalcode,Country"
					DatasourceHeadings = "Name,Contact,Title,Address,City,Region,Post Code,Country"
					MailMerge = "true"
					>
				</DNL:DbNetGrid>
			</td>
		</tr>
	</table>
</form>

Client-side script

window.onload = initGrid
//////////////////////////////////////////////////////////////////////////////////////////////
function initGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	setMergeDocumentMode()
}

//////////////////////////////////////////////////////////////////////////////////////////////
function setMergeDocumentMode()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	with ( window.DbNetGridArray["customers"] )
	{
		mailMergeDocument = document.getElementById("mergeDocumentMode").value

switch (mailMergeDocument)
		{
			case "labels.doc":
			case "letter.doc":
				mailMergeDocument = virtualDir + "office/samples/" + mailMergeDocument
		}

mailMergeExecute = document.getElementById("mergeExecute").checked
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function merge()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	window.DbNetGridArray["customers"].toolbarElement("mailMerge").click()
}