Custom Submit button code to QC

bush3102 — Tue, 10 Jan 2012 16:57:59 GMT

I am creating a submit button (using InfoPath 2007) on a form that will be executed in SharePoint 2010. I have several fields that I want to send the data to a Quality Center (QC) database using a COM reference. I would also like to send some fields (some the same and some different) to a particular SharePoint 2010 list. Can someone provide some example syntax for the following:

Public Sub btnSubmit_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)
            Dim qcconn As New TDAPIOLELib.TDConnection

            qcconn.InitConnectionEx("http://QualityCenter/qcbin/")
            qcconn.Login("username", "password")
            qcconn.Connect("Domain", "Project")

            update(databasename)
            set
            FormTextObject1.text = database.table.field1
            FormTextObject2.text = database.table.field1
            DropDownObject1.text = database.table.field1
            DateObject1.date = database.table.field1



        End Sub

Code

Custom Submit button code to QC