CODEWITHSUNDEEP
c#.net
Puzzien
Puzzien

Reputation:

Store whole dataset to database

How to store a complete dataset into database without having to do it table by table and row by row.

Upvotes: 0

Views: 944

Answers (3)

ADAM
ADAM

Reputation: 3903

Your question is a little ambiguous, so assuming you want to store multiple objects in a row i would recommend you investigate storing them as serialized json.

serialize the objects before you store them and un-serialize them when you need them again.

Upvotes: 0

marc_s
marc_s

Reputation: 754518

Have a look at the SqlDataAdapter. It can do bulk inserts/updates/deletes using its .Update() method.

That of course only works if you're using SQL Server as your database - you didn't mention what database you're targeting in your question....

See some tutorials on how to use SqlDataAdapter:

Marc

Upvotes: 1

benPearce
benPearce

Reputation: 38333

You could serialize the dataset to Xml and store it as a string

Upvotes: 0

Related Questions