Here is part of my code:
Here is my problem. My controls on the form were created from dragging and dropping one of my tables from the data explorer window onto the form in details form, not gridview. Amongst these controls are four comboboxes whose text properties are databound, but their items lists are not bound. When I click my submit button, all the data is sent to the database except the text from these four comboboxes. I have looked everywhere I can think of and can't figure out why the text from those comboboxes isn't being updated in the db.Code:Private Sub ESignSubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ESignSubmitButton.Click Me.Validate() Me._859BindingSource.EndEdit() Me.ATCFormsDataDataSet._859.Item(Me._859BindingSource.Position).IsException = recordIsAnException() Me.ATCFormsDataDataSet._859.Item(Me._859BindingSource.Position).SubmissionDate = Now Me.ATCFormsDataDataSet._859.Item(Me._859BindingSource.Position).SubmittedBy = Environment.UserName.ToUpper If formIsComplete() Then Dim promptQuestion As DialogResult = MessageBox.Show("Are you sure?", "Submit?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) If promptQuestion = Windows.Forms.DialogResult.No Then Exit Sub End If Try Me.TableAdapterManager.UpdateAll(Me.ATCFormsDataDataSet) MessageBox.Show("Form submitted successfully", "Successful") Me.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try End If End Sub




Reply With Quote