' Update the Bus Obj dataset with Picker Item Selected Text Value Dim VisitorView As DataRowView = Me.GetCurrentRow(oVisitor) Dim VisCompanySelected As String VisCompanySelected = VisitorView("CompanyName").ToString Dim CompanySelected As String = _ Me.VisitorCompanyNamePicker.Text VisitorView("CompanyName") = CompanySelected Dim VisitorCompanyName As String = Me.oVisitor.DataRow.Item("CompanyName").ToString ' Save the Item Selected from mmPicker to Bus Obj dataset VisCompanySelected = VisitorView("CompanyName").ToString ' Following Code PRODUCES CANNOT INSERT NULL CompanyName ERROR Dim result As mmSaveDataResult = _ Me.oVisitor.SaveDataSet(Me.oVisitor.GetCurrentDataSet()) ' Following Code also PRODUCED CANNOT INSERT NULL CompanyName ERROR 'Me.oVisitor.SaveRow() ' Raises the Navigated event to get new Company Bus Obj (Hook) Me.oVisitor.NavigatedData(VisitorView)My NEW button click code:
Private Sub VisitorNewButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles VisitorNewButton.Click Me.oVisitor.NewRow _ (New VisitorDefaultValues _ (DateTime.Now, _ System.Security.Principal.WindowsIdentity.GetCurrent.Name.ToString)) ' Move to last row (new row) Me.BindingContext(Me.oVisitor.GetCurrentDataSet(), "Visitors").Position = _ Me.oVisitor.GetCurrentDataSet().Tables("Visitors").Rows.Count - 1 Dim VisitorView As DataRowView = Me.GetCurrentRow(oVisitor) Dim VisCompanySelected As String VisCompanySelected = VisitorView("CompanyName").ToString End Sub