How would i explain this problem. hmmm...
I have a program for the database of the patient's record and I have a different tables which are categorize, like table for personal information , table for gynecological history and so on, each table has the column "NAME" which is for the search purpose where if you search a record it will show the record of the different tables in a one search process that has the same text that is inputted "NAME" .
it explains here when you type on the Nametextbox under the table of Personal information, it will copy the string on there and transfer to the nametextbox of the gynecological and other table of the database. So here the problem starts , i created a button for the update command which is for the edit process, i coded this :
Me.Validate() Me.Chief_ComplaintBindingSource.EndEdit() Me.Family_HistoryBindingSource.EndEdit() Me.GynecologicalBindingSource.EndEdit() Me.HusbandBindingSource.EndEdit() Me.Menstrual_HistoryBindingSource.EndEdit() Me.Past_MedicalBindingSource.EndEdit() Me.Patient_s_informationBindingSource.EndEdit() Me.Personal_and_LocalBindingSource.EndEdit() Me.Pregnancy_HistoryBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(Obgyn2DataSet)
and error provider provide this thing when you click update command:
Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.
please give me some other way or the solution for this.. plsss.