Dataset Merge

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Moty Michaely
    #1

    Dataset Merge

    Hello,

    I have an issue I would like to solve.

    I need a dataset synchronization mechanism method that needs to read data
    from SQL server and within an interval of time, read the data again and Send
    only the changes made to the dataset.

    My thought was read one dataset that will be my cache and compare it to
    another dataset that will be filled within the interval.
    The comparison can be made ( I guess) by Merge method, but it's not working.

    GetChanges should return a dataset I guess with the changes but how can I
    use it with 2 datasets and not by updateing the dataset directly.

    Is it possible?

    - Moty -


    Tags: None
    • Shardool Karnik
      #2
      Re: Dataset Merge

      I'm confused ... did u say that you have tried merging the two datasets and
      then calling getchanges() and it returns nothing ?


      "Moty Michaely" <moty@speedocs. co.il> wrote in message
      news:uOP5bq9eFH A.2420@TK2MSFTN GP12.phx.gbl...[color=blue]
      > Hello,
      >
      > I have an issue I would like to solve.
      >
      > I need a dataset synchronization mechanism method that needs to read data
      > from SQL server and within an interval of time, read the data again and[/color]
      Send[color=blue]
      > only the changes made to the dataset.
      >
      > My thought was read one dataset that will be my cache and compare it to
      > another dataset that will be filled within the interval.
      > The comparison can be made ( I guess) by Merge method, but it's not[/color]
      working.[color=blue]
      >
      > GetChanges should return a dataset I guess with the changes but how can I
      > use it with 2 datasets and not by updateing the dataset directly.
      >
      > Is it possible?
      >
      > - Moty -
      >
      >[/color]


        Comment

        • Moty Michaely
          #3
          Re: Dataset Merge

          Hey,

          Yep.. I still don't get how doe's the dataset recognize same fields???

          Any other ideas will be great.

          - Moty -

          "Shardool Karnik" <TheOutlander@g mail.com> wrote in message
          news:euTooP$eFH A.3808@TK2MSFTN GP14.phx.gbl...[color=blue]
          > I'm confused ... did u say that you have tried merging the two datasets
          > and
          > then calling getchanges() and it returns nothing ?
          >
          >
          > "Moty Michaely" <moty@speedocs. co.il> wrote in message
          > news:uOP5bq9eFH A.2420@TK2MSFTN GP12.phx.gbl...[color=green]
          >> Hello,
          >>
          >> I have an issue I would like to solve.
          >>
          >> I need a dataset synchronization mechanism method that needs to read data
          >> from SQL server and within an interval of time, read the data again and[/color]
          > Send[color=green]
          >> only the changes made to the dataset.
          >>
          >> My thought was read one dataset that will be my cache and compare it to
          >> another dataset that will be filled within the interval.
          >> The comparison can be made ( I guess) by Merge method, but it's not[/color]
          > working.[color=green]
          >>
          >> GetChanges should return a dataset I guess with the changes but how can I
          >> use it with 2 datasets and not by updateing the dataset directly.
          >>
          >> Is it possible?
          >>
          >> - Moty -
          >>
          >>[/color]
          >
          >[/color]


            Comment

            • Shardool Karnik
              #4
              Re: Dataset Merge

              I think they will be based on the primary keys that you have defined in the
              dataset ...

              try this ... create a dataset with 1 table 1 row ... .create an identical
              datarow ... and merge it ..... with a primary key defined ....


              "Moty Michaely" <moty@speedocs. co.il> wrote in message
              news:ukzVEa$eFH A.688@TK2MSFTNG P14.phx.gbl...[color=blue]
              > Hey,
              >
              > Yep.. I still don't get how doe's the dataset recognize same fields???
              >
              > Any other ideas will be great.
              >
              > - Moty -
              >
              > "Shardool Karnik" <TheOutlander@g mail.com> wrote in message
              > news:euTooP$eFH A.3808@TK2MSFTN GP14.phx.gbl...[color=green]
              > > I'm confused ... did u say that you have tried merging the two datasets
              > > and
              > > then calling getchanges() and it returns nothing ?
              > >
              > >
              > > "Moty Michaely" <moty@speedocs. co.il> wrote in message
              > > news:uOP5bq9eFH A.2420@TK2MSFTN GP12.phx.gbl...[color=darkred]
              > >> Hello,
              > >>
              > >> I have an issue I would like to solve.
              > >>
              > >> I need a dataset synchronization mechanism method that needs to read[/color][/color][/color]
              data[color=blue][color=green][color=darkred]
              > >> from SQL server and within an interval of time, read the data again and[/color]
              > > Send[color=darkred]
              > >> only the changes made to the dataset.
              > >>
              > >> My thought was read one dataset that will be my cache and compare it to
              > >> another dataset that will be filled within the interval.
              > >> The comparison can be made ( I guess) by Merge method, but it's not[/color]
              > > working.[color=darkred]
              > >>
              > >> GetChanges should return a dataset I guess with the changes but how can[/color][/color][/color]
              I[color=blue][color=green][color=darkred]
              > >> use it with 2 datasets and not by updateing the dataset directly.
              > >>
              > >> Is it possible?
              > >>
              > >> - Moty -
              > >>
              > >>[/color]
              > >
              > >[/color]
              >
              >[/color]


                Comment

                Previous template Next
                Working...