Hey everyone this is a problem that no one has been able to give me an answer too, any help would be appreciated
I have an a gridview which is displaying an accessdatasource table called "Test"
on another page i have a another gridview which is displaying a table called "Scores"
How can I updated a value on the "Test" table when a user goes into the edit-update mode an tries to update a value for the "Scores"
So far I have my update command sql string as follows:
Update [Test], [Scores] Set SET [Test].[Name]=@Name, [Test].[Total] = @Total, [Scores].[Total2] = [Test].[Total] WHERE [Test].[ID]=@ID And [Test].[ID] = [Scores].[ID]">
This works but the problem is I have to go into edit mode twice and update before [Scores] see's any change, the table [Test] sees a change and gets updated immediately. THANKS!
I have tried two update statements, but it won't let me,
I have tried store procedures, but being an acess database it won't let me
I'm wondering if i can overite the update functions OnRowUpdating, OnRowUpdated somehow to simply do twice the updates, that would solve my problem. I am programming in C#
I have an a gridview which is displaying an accessdatasource table called "Test"
on another page i have a another gridview which is displaying a table called "Scores"
How can I updated a value on the "Test" table when a user goes into the edit-update mode an tries to update a value for the "Scores"
So far I have my update command sql string as follows:
Update [Test], [Scores] Set SET [Test].[Name]=@Name, [Test].[Total] = @Total, [Scores].[Total2] = [Test].[Total] WHERE [Test].[ID]=@ID And [Test].[ID] = [Scores].[ID]">
This works but the problem is I have to go into edit mode twice and update before [Scores] see's any change, the table [Test] sees a change and gets updated immediately. THANKS!
I have tried two update statements, but it won't let me,
I have tried store procedures, but being an acess database it won't let me
I'm wondering if i can overite the update functions OnRowUpdating, OnRowUpdated somehow to simply do twice the updates, that would solve my problem. I am programming in C#