Put a sample bit of code . otherwise it is too difficult to analyze.
On Thu, Aug 13, 2009 at 1:53 PM, Steffen Sommer <[email protected]>wrote: > Hi koro, > have you tryed your method without the background worker? Sometimes the > synchronization is messed up or not ready or anything... > > On Thu, Aug 13, 2009 at 12:16 AM, koro <[email protected]> wrote: > >> >> I'm trying to set up a background worker than can compare individual >> tables/databases between SQL instances. Each table compared (chosen >> either individually or during a scan of the database) returns 2 >> tables. One table for machine 1 and one table for machine 2 showing >> the differences in each as compared to the other. >> >> I was to be able to use the same code for both. Basically a single >> dataset consisting of 2 results tables for each chosen table in a >> database. To that end I've been trying to implement a system of >> Dataset arrays. Where by I only initialize 1 element for and >> individually chosen table, and dynamically initialize a variable >> amount of elements based off the the number of tables of the chosen >> Database. Then populate each element with their respective 2 >> comparison results tables. >> >> For individually chosen tables: >> dataSet[0].Tables[0] >> dataSet[0].Tables[1] >> >> For a database comparison: >> dataSet[0].Tables[0] >> dataSet[0].Tables[1] >> dataSet[1].Tables[0] >> dataSet[1].Tables[1] >> etc..... >> >> It seems to be working through the DoWork event yet when I attempt to >> check the tables, they're all blank. As in 0 columns. It seems like >> the entry for however many tables came through but the actual data for >> those tables is lost. >> >> I was wondering if anyone else had attempted anything similar or had >> any other idea's as to how I could go about this. >> > > -- Santhosh V http://techplex.wordpress.com
