I did that originally....I want to be able to display the results to a user, who then selects which row to insert/update.
I'll have to look at SQLbulkLoad. -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Wildermuth (MVP) Sent: 20 March 2007 11:50 To: [email protected] Subject: Re: [ADVANCED-DOTNET] Using SQL to generate new data in a dataset 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: [email protected] 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(r) 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
