Ok, assume I selected the first Row in the ComboBox, and then updated the data according to the following fields:
User Name: Ahmad
Title: System Analyst
Then I clicked the Save button, data saved correctly. RowState is Updated

Now, I’ll select another row from the ComboBox, say the 5th row in the ComboBox list, and updated the data as follows:
User Name: Sara
Title: Developer
Then I clicked the Save button. RowState is UnChanged

Now what happens, the first Row (Record) which having “Ahmad” value in “UserName” Field, is replaced with “Sara”, and “Title” filed with value “Systems Analyst” replaced with “Developer”.

And the 5th Row still having the old data.
Hope it’s clear now





>Sorry Ahmad, I'm still not following what you are saying. =(
>
>
>
>>Sorry Bonnie, I was replying yestrday & sadenly the internet disconnected, ISP problem!.
>>
>>Well, yes I am sure, if I closed the form & reopen it and get the data I see the new entered data which suppose to be saved on the 3rd row, has been replaced the 1st row data. and the RowState is "Unchanged"!!, it becomes "Updated" only if I selected the 1st row.
>>
>>In another word, any row changes other that the 1st row are effecting and changing the 1st row data.
>>
>>
>>
>>>And yet the 3rd row in the DataSet has been changed? Are you sure of that? What is it's RowState?
>>>
>>>
>>>
>>>>Bonnie
>>>>The problem not with the update, the database is updated in all cases, but the problem if I selected the 3rd row in the combobox and modefied it then save the changes, the 3rd row is not updated - the changed effected the 1st row !!
>>>>
>>>>And regarding AcceptChanges Iam not using it
>>>>
>>>>any idea?
>>>>
>>>>
>>>>
>>>>>How are you updating your database? If you see the changes in the DataSet, then your ComboBox must be working right. I have the feeling you're probably doing an ds.AcceptChanges() before your da.Update() or something along those lines ....
>>>>>
>>>>>~~Bonnie
>>>>>
>>>>>
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>I am using a ComboBox in my application and binding it to the DataSet and CommandBuilder, when I select a record then change it, if it's the first it accept changes, if not, I see the changes only in the dataset but the database not updated.
>>>>>>
>>>>>>Any idea what Iam missing?
>>>>>>
>>>>>>Thanks for the help