How to compare two table contents?

Discussion in 'ASP .Net' started by =?Utf-8?B?U2hhdw==?=, Dec 27, 2004.

  1. Our database is constantly updated (input data) from another DB, and
    sometimes it crashes our ASP.NET applications. My boss told me to write a DB
    utility app to check DB and make sure all apps are still running.

    The first step of few checks is to compare current DB tables with
    yesterday’s tables. I store yesterday’s tables at a XML file (DB is
    maintained by another guy, and certainly they don’t want me to make back copy
    for few tables in DB everyday).

    I thought it’s trivial, and just do loop and compare two XML DOM
    (XmlDocument) objects and make a new one. But the algorithm is more complex
    than I thought. The new rows can be inserted or deleted based on primary key.

    So, my question is: Is there a sample code to compare two tables (either
    DataTable in DataSet, or XmlDocument)?

    Another question is: Can I set color for individual cell in DataGrid UI,
    because I want to use different color to show new, deleted or modified field
    dynamically?

    Thanks
    Shaw
     
    =?Utf-8?B?U2hhdw==?=, Dec 27, 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. YC
    Replies:
    1
    Views:
    4,865
    siva chelliah
    Aug 13, 2003
  2. Robin Siebler
    Replies:
    6
    Views:
    5,536
    Raymond Hettinger
    Sep 15, 2004
  3. GenxLogic
    Replies:
    3
    Views:
    1,371
    andrewmcdonagh
    Dec 6, 2006
  4. Esmail
    Replies:
    0
    Views:
    286
    Esmail
    Apr 24, 2009
  5. Zachary Dziura
    Replies:
    12
    Views:
    478
    Chris Angelico
    Jun 13, 2011
Loading...

Share This Page