Dataset and Temporary Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone konws haow I can save as populated Dataset (with one datatable) in a Temporary Table in sql server
Thanks
 
Hi Luke,

I know how to make a string from it, so your question I can answer.

dataset.GetXML

What I do not know is how to bring it back with one statement to a
datataset.
(Something as SetXML or PutXML)

The documentation says it is the same as writeXML which it is in my opinion
not, as far as I remember me does in not gives the xml header.

Cor
 
Hi Luke:

Sure, you can save just about any data into a temp table. Since Sql Server
supports batch statements, you can use one statement to create the temp
table , a ; and then the insert statement. It's syntactically a little
bulky but doable. Here's an example of creating a temp table and loading an
array into it, it's effectively the same process with any other data
structure although you can do it a little more elegantly depedning on what
you are loading... http://www.knowdotnet.com/articles/temptables.html

Cheers,

Bill
Luke v said:
Anyone konws haow I can save as populated Dataset (with one datatable) in
Click to expand...
a Temporary Table in sql server?
 
Back
Top