Create database table directly from a dataset which has many no. of data table [modified]
-
hi, my problem is that..... Recently i get a complex xml.Which have huge no of data.When i read xml by dataset i get 6 realated tables.Each have 10 to 20 no of coloumn.so i want to directly move this data to sqlserver database. please help me :( :((
modified on Wednesday, October 1, 2008 5:12 AM
-
hi, my problem is that..... Recently i get a complex xml.Which have huge no of data.When i read xml by dataset i get 6 realated tables.Each have 10 to 20 no of coloumn.so i want to directly move this data to sqlserver database. please help me :( :((
modified on Wednesday, October 1, 2008 5:12 AM
Hello, So you basically wants to move the XML data into the SQL server. If you are trying to do this through code, then you can have a look at the given web link which should give you some fair idea on how to achieve this. http://www.dbazine.com/sql/sql-articles/cook2[^] Hope this will help. Regards,
Allen Smith ComponentOne LLC www.componentone.com
-
Hello, So you basically wants to move the XML data into the SQL server. If you are trying to do this through code, then you can have a look at the given web link which should give you some fair idea on how to achieve this. http://www.dbazine.com/sql/sql-articles/cook2[^] Hope this will help. Regards,
Allen Smith ComponentOne LLC www.componentone.com
-
Hello, So you basically wants to move the XML data into the SQL server. If you are trying to do this through code, then you can have a look at the given web link which should give you some fair idea on how to achieve this. http://www.dbazine.com/sql/sql-articles/cook2[^] Hope this will help. Regards,
Allen Smith ComponentOne LLC www.componentone.com
you can insert xml file directly to sql server. for this you can see How to insert XML data in sql server database through visual basic .net may be you have to work through it if you got big xml but it is very handy way of getting your xml data in database.
-
hi Allen, Thanks for your suggestion.I think it will work if i create related table first. But i do not want to create table by myself.i want something dynamically to store it from dataset to database. Hope you help me again.
You just need to issue a create table statement first, surely...