C# App - Dataset updating, how to update certain aspects

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gun Slinger
    New Member
    • Feb 2008
    • 27
    #1

    C# App - Dataset updating, how to update certain aspects

    Hi guys,

    I have run into a little problem once again in my program. I have struggled with this for a while looking around for answers, and have made a make shift method to do a work around. But this will consume a lot of resources and is unnecessary i believe.

    My problem is this. I have a dataset which has several relations, i then also have enough datagridviews to display the levels of data. Now i have certain columns in the data that will be sql functions such as SUM and COUNT on the data in the child tables.

    My problem is that i want to be able to refresh the parents sql column whenever a child datagridview has been altered.

    My makeshift way around this before was to recreate the dataset, recreate the bindingsources and then attaching them to the datagridviews.

    What is the best way to do this without needlessly repeating steps?

    In summation, all it needs to be able to do is refresh the parents current row in the table from the child data that is related to it.

    Sorry if my wording is a little odd, it's very late and I have been wracking my brain over this too long.

    Cheers
    Gun Slinger
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      Thread moved to c# forum.

        Comment

        • Gun Slinger
          New Member
          • Feb 2008
          • 27
          #3
          Cheers.

          I have been moved to the .net forum quite a lot when i have posted here, that i assumed that i was supposed to post in the .net forum.

          It is C#.net, maybe i should have made that clearer in the title.

          Also, just to clarify. I want to be able to update SUM and COUNT columns either within the current row, the parents current row, or all children data. Just so i can update information such as, a column in my query which is tickets * ticket cost and shows the user what the total price is.
          Then in a parent table which is a ticket bookings table which has various tickets under one person at a particular event and time and in that row, show a total of the totals and show a complete price for the booking.

          I have seen it done in a lot of databases, i just want the most efficient and possibly easiest way to do it =)

            Comment

            • Gun Slinger
              New Member
              • Feb 2008
              • 27
              #4
              Anyone got any ideas? i have been busying myself with other parts of my project, but i would like to get this part done soon.

              Thanks in advance

                Comment

                Previous template Next
                Working...