Mark Breen
marklbreen at gmail.com
Fri Nov 13 00:58:16 CST 2009
Hello John, Just curious, how many records are you talking about - a few hundred or millions? Second question, other than for purely academic reasons, why are you bring the data into C#, to concatenate and insert into another table can so easily be done in one sproc, even if you need a temporary holding place, you would still use a temp table or even a local table. Of course if it is to learn datasets then thats another story, Mark 2009/11/13 jwcolby <jwcolby at colbyconsulting.com> > I am writing an application in C# to merge records (previously discussed). > It looks pretty simple, > all things considered. Get data into a dataset object which will contain > about 4 tables. Then use > the records and fields collections of the recordset to iterate through the > fields building up a > record (or modifying the first record of a small set of records - the > dupes). Copy a record from > one table into another table inside of the dataset. Delete records in a > table in the dataset. Etc. > Etc all without going back out to the actual data tables on SQL Server > until the very end when I > will do an update back to the live data. > > Am I correct in assuming here that I can programmatically append records > from one table in the > dataset to another record in the dataset? Delete records in the tables in > the dataset? Update > records in tables in the dataset? All "in memory" without connecting back > to the live data in the > database? > > Is there anything I need to know before I launch into this? > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >