cannot save to datasource when bindingsource is sorted.

Question

BH

Hi,
I'm using the below code, to save a single row to a datasource. This works fine, but only when the clientsBindingSource is not sorted.   However, when I sort clientsBindingSource (Ascending or Descending), the below code does not save the row.  Any idea as to why this is happening and how to fix it?

                clientsTableAdapter.Update(new[] { (clientsBindingSource.Current as DataRowView).Row });

Thanks so much.
Aron

---

Thanks Aron www.EvidenceForTorah.comxa.com

Answer 1

Hi aniyahudi,

I am moving your thread into the ADO.NET Managed Providers Forum for dedicated support.
Have a nice day,

---

Leo Liu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi aniyahudi,

Welcome to MSDN Forum.

Could you please post more code to let me test? How do you sort the datasource?

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us

Answer 3

BH
Hi Allen, thanks so much for your reply.  Here is the full code of that function:

      

voidSaveEverything()

        {

           

if(ClientsPanel.Visible == true)

            {

               

this.Validate();

               

this.clientsBindingSource.EndEdit();

                clientsTableAdapter.Update(

new[] { (clientsBindingSource.Current asDataRowView).Row });

               

//refresh everything is required, because without it when clicking on the Trips button,

               

//an exception happens that is related to the ClientsDataGridView1.

                RefreshEverything();

            }

           

elseif(TripPanel.Visible == true) // || DispatchGroupBox.Visible == true || ReportsPanel.Visible == true)

            {

               

this.Validate();

               

this.trips1BindingSource.EndEdit();

                tripsTableAdapter.Update(

new[] { (trips1BindingSource.Current asDataRowView).Row });

               

//RefreshEverything();

            }

           

elseif(DispatchGroupBox.Visible == true)

            {

               

this.Validate();

               

this.trips1BindingSource.EndEdit();

                tripsTableAdapter.Update(

new[] { (trips1BindingSource.Current asDataRowView).Row });

            }

           

elseif(ReportsPanel.Visible == true)

            {

               

this.Validate();

               

this.trips1BindingSource.EndEdit();

                tripsTableAdapter.Update(

new[] { (trips1BindingSource.Current asDataRowView).Row });

            }

　

        }

---

Thanks Aron www.EvidenceForTorah.comxa.com

Answer 4

Your code is related to Windows Form, it seems not caused by you update command, it caused by your datasource. Post the question here: http://social.msdn.microsoft.com/Forums/en/winformsdatacontrols/threads

---

Fighting like Allen Iverson. Neve give up!

Answer 5

Hi aniyahudi,

Please try to update the whole datasource, don't only update the new row. If you sort the records, I'm not sure whether the state of records in your datasource are changed or not.

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us

Answer 6

BH
I see.  But its not possible to update a single row, and have the bindingsource sorted?

Thanks

Aron

---

Thanks Aron www.EvidenceForTorah.comxa.com

Answer 7

Hi aniyahudi,

I'm afraid I'm not familiar with Winform Data Binding Controls, based on this issue, you have used datasource and data binding controls, I suggest you to post the question in Windows Forms Data Controls and Databinding Forum. There are more related specialists there, I think you can get help more effectively there. Sorry for little help.

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us