In my C# winforms project I have a DataGridView which is displaying a View of two SQL tables. Is there a workaround for Updating the View from the DataGridView.
Using a Save button on my form,
At first I assumed I could update the View like this:
Did not work so I tried updating the tables separately and still was not able to update:
this.DataSet.EndInit(); this.TableOneTableAdapter.Update(this.DataSet.TableOne); this.TableTwoTableAdapter.Update(this.DataSet.TableTwo);
I have another form where a DataGridView is displaying just one Table and using the following works fine when Updating: