Re: [ADVANCED-DOTNET] Using SQL to generate new data in a dataset

2007-03-20 Thread Nicholls, Mark
t: 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, wh

Re: [ADVANCED-DOTNET] Using SQL to generate new data in a dataset

2007-03-20 Thread Shawn Wildermuth (MVP)
[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.develo

Re: [ADVANCED-DOTNET] Using SQL to generate new data in a dataset

2007-03-20 Thread Mark Nicholls
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 DevelopMentorĀ® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com

[ADVANCED-DOTNET] Using SQL to generate new data in a dataset

2007-03-20 Thread Mark Nicholls
Hello, I want to be able to use SQL to create lots of 'added' rows in a datatable. e.g. to create a single row I can execute "Select 1,2,3,4" and then map it to the 'Table' in a datasetusing a dataadapter. This works but it's datarowstate is 'unchanged'so if I write it back to the dat