Updating Value of ComboBoxColumn Item of the DGV
-
Hello everybody! I am using a data entry Form, which has only one DataGriedView. The DGV properties include: Name: tblStaffInfoDGV DataSource: tblStaffInfoBindingSource The properties of the tblStaffInfoBindingSource are: DataSource: StaffEvaluationDataSet DataMember: tblStaffInfo The 2nd Column (CampusID), of the DGV has the following properties: ColumnType: DataGridViewComboxColumn DataPropertyName: CampusID DataSource: CampusesBindingSource DisplayName: CampusName ValueMember: CampusID The properties of the CampusesBindingSource include: Name: CampusesBindingSource DataMember: tblCampuses DataSource: CampusesDataSet The "CampusName" and the"CampusID" are the only two Fields of the table tblCampuses My Dataset is StaffEvaluationDataSet The code, of the Form, is as below:
Public Class frmStaffEntry
Private Sub TblStaffInfoBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles TblStaffInfoBindingNavigatorSaveItem.Click
Me.Validate()
Me.tblStaffInfoBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.StaffEvaluationDataSet)Me.tblStaffInfoBindingSource.EndEdit()
Me.tblStaffInfoTableAdapter.Update(Me.StaffEvaluationDataSet.tblStaffInfo)
End SubPrivate Sub frmStaffEntry_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Me.tblCampusesTableAdapter.Fill(Me.CampusesDataSet.tblCampuses)
Me.tblStaffInfoTableAdapter.Fill(Me.StaffEvaluationDataSet.tblStaffInfo)
End Sub
End ClassISSUE After selecting a different item from the drop-down list of the ComboBox and clicking Save button of the tblStaffInfoBindingNavigator, the new value is Not saved in the tblStaffInfo table. Would an expert help me in resolving this issue, please! Regards
-
Hello everybody! I am using a data entry Form, which has only one DataGriedView. The DGV properties include: Name: tblStaffInfoDGV DataSource: tblStaffInfoBindingSource The properties of the tblStaffInfoBindingSource are: DataSource: StaffEvaluationDataSet DataMember: tblStaffInfo The 2nd Column (CampusID), of the DGV has the following properties: ColumnType: DataGridViewComboxColumn DataPropertyName: CampusID DataSource: CampusesBindingSource DisplayName: CampusName ValueMember: CampusID The properties of the CampusesBindingSource include: Name: CampusesBindingSource DataMember: tblCampuses DataSource: CampusesDataSet The "CampusName" and the"CampusID" are the only two Fields of the table tblCampuses My Dataset is StaffEvaluationDataSet The code, of the Form, is as below:
Public Class frmStaffEntry
Private Sub TblStaffInfoBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles TblStaffInfoBindingNavigatorSaveItem.Click
Me.Validate()
Me.tblStaffInfoBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.StaffEvaluationDataSet)Me.tblStaffInfoBindingSource.EndEdit()
Me.tblStaffInfoTableAdapter.Update(Me.StaffEvaluationDataSet.tblStaffInfo)
End SubPrivate Sub frmStaffEntry_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Me.tblCampusesTableAdapter.Fill(Me.CampusesDataSet.tblCampuses)
Me.tblStaffInfoTableAdapter.Fill(Me.StaffEvaluationDataSet.tblStaffInfo)
End Sub
End ClassISSUE After selecting a different item from the drop-down list of the ComboBox and clicking Save button of the tblStaffInfoBindingNavigator, the new value is Not saved in the tblStaffInfo table. Would an expert help me in resolving this issue, please! Regards
I am desperate for the solution of my issue, but surprisingly received no response. Please help!
-
I am desperate for the solution of my issue, but surprisingly received no response. Please help!
Probably because you missed by 2, forums that is the VB.Net forum is 2 above this one one the left menu!
Never underestimate the power of human stupidity RAH