If you're just using it to generate lots of data in SQL, why not just create lots of INSERTs or UPDATEs? Alternatively, if you creating *lots* of data, why not just create huge datasets and use SqlBulkLoad to dump it into SQL efficiently (assuming you're using SQL Server).
Thanks, Shawn Wildermuth http://adoguy.com http://wildermuthconsulting.com Microsoft MVP (C#), MCSD.NET, Author and Speaker -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Mark Nicholls Sent: Tuesday, March 20, 2007 7:38 AM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] Using SQL to generate new data in a dataset I've answered it myself. SetAdded(); ! please feel free to tell me if you think what I'm doing is mad. =================================== This list is hosted by DevelopMentorR http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorĀ® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com