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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataSet data table name 3
strongly typed dataset update with identity column 6
Inserting Multi Table Dataset into Dataset 1
ADO.NET TableAdapter "The connection is closed" error 0
Existing algorithm for merging DataSets after GetChanges() and withidentity column? 1
Select multiple table in 1 stored proc 3
DataSet designer in VS2005 4
Creating a Dataview from a Dataset using SQL? 3

Back
Top