Efficiently comparing 2 datasets from different datasources

Discussion in 'ASP .Net' started by Elliot M. Rodriguez, Jul 6, 2004.

  1. I can accomplish this relatively easily but inefficiently, and it seems like
    a hack, but I cant think of a better workaround. Hopefully someone else here
    can.

    My task is to perform an update on a dataset retrieved from SQL Server 2000
    using a stored procedure. This is the base dataset. Users will send an Excel
    document up to a webserver and that excel document, which matches the schema
    of the SQL dataset (few differences but nothing major), will be queried
    using some inline SQL, and another dataset will be created from this
    resultset.

    The Excel dataset will contain differences that must be sent up to the SQL
    dataset. Once this change is detected in the row, I need to update the
    column(s), then once all updates are completed, save the SQL dataset (I dont
    care about the Excel dataset; its essentially read only). I can loop through
    the Excel dataset and compare column values using Datarows, but there are
    upwards of 4000 rows between the 2 datasets, and this usually results in
    timeouts.

    I found an article that discusses how to do this (cant recall the URL right
    now), but it didnt work in my scenario. What are my other options?
    Elliot M. Rodriguez, Jul 6, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. GaryDean
    Replies:
    9
    Views:
    694
    Steven Cheng[MSFT]
    Jan 10, 2006
  2. news.microsoft.com
    Replies:
    0
    Views:
    414
    news.microsoft.com
    Apr 12, 2006
  3. Francisco Garcia
    Replies:
    2
    Views:
    454
    Fran Garcia
    Apr 13, 2006
  4. news.microsoft.com
    Replies:
    0
    Views:
    176
    news.microsoft.com
    Apr 12, 2006
  5. Francisco Garcia
    Replies:
    3
    Views:
    234
    vincent
    Apr 13, 2006
Loading...

Share This Page