I am a test Evaluation copy and I am trying to get a mail merge to work for labels. Here is the code, stored procedure and template. It never return any data in the template. The data is coming back from the stored procedure .
Private Sub GetData()
Dim myAdapter As SqlDataAdapter
Dim result As New DataSet
Dim myConnection As SqlConnection = New SqlConnection(WebConfigurationManager.ConnectionStrings(“testCenter”).ConnectionString)
Dim stlabel As New DataTable
Try
Dim sqlCommand_Label As SqlCommand
sqlCommand_Label = New SqlCommand(“Select_CondPolicyIndex_Address_Label”, myConnection)
sqlCommand_Label.CommandTimeout = 200
sqlCommand_Label.CommandType = CommandType.StoredProcedure
myConnection.Open()
myAdapter = New SqlDataAdapter(sqlCommand_Label)
myAdapter.Fill(result)
If (result.Tables.Count > 0) Then
stlabel = result.Tables(0)
stlabel.TableName = “Labels”
End If
Dim dataDir As String = “C:\LabTest”
Dim doc As New Document(dataDir & Convert.ToString(“LabelTest.docx”))
doc.MailMerge.ExecuteWithRegions(stlabel)
Dim dataOut As String = dataDir & Convert.ToString(“LabelTestout.docx”)
doc.Save(dataOut)
Catch ex As Exception
Throw (ex)
Finally
If myConnection.State = ConnectionState.Open Then
myConnection.Close()
End If
End Try
Catch ex As Exception
Throw (ex)
Finally
If myConnection.State = ConnectionState.Open Then
myConnection.Close()
End If
End Try
End Sub
stored Procedures
ALTER PROCEDURE [dbo].[Select_CondPolicyIndex_Address_Label]
AS
SELECT top 100 CurrentName as CurrentName
, Address as Address
, City as City
, State as State
, ZipCode as ZipCpde
FROM Address_GL