Hello
I am trying to programatically set a SQL database attribute, and I keep getting errors.
I am trying to use this code to set the @ComIPSCode value to 'CaseCode'. I am able to set other fields in the form to the CaseCode value, but for some reason I am unable to set the @ComIPSCode using this. Can anyone see any problems? Do I need a diferent method for setting a database attribute?
Try
Me.Errors.DeleteAll() webservConn.Execute(Nothing, OutputNav, ErrorNav)
Dim CaseCode As String
If CheckReturnStatus(OutputDoc) = False Then
CaseCode = GetCaseCode(OutputDoc)
Dim xNav As XPathNavigator = Me.CreateNavigator() Dim ns As XmlNamespaceManager = Me.NamespaceManager
xNav.SelectSingleNode("//dfs:myFields/dfs:dataFields/d:TrustDeeds/@ComIPSCode", ns).SetValue(CaseCode)
End If
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString)
End Try