By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

how to convert data from sql server to xml? how to import data from xml to sql server

P: 4
I have xml data in my vb.net mobile application:
customer.xml
<dataset>
<customers>
<customerid>BONAP</customerid>
<companyname>Bon app'</companyname>
<contactname>Laurence Lebihan</contactname>
<contacttitle>Owner</contacttitle>
<address>12, rue des Bouchers</address>
<city>Marseille</city>
<postalcode>13008</postalcode>
<country>France</country>
<region>Asia</region>
<phone>91.24.45.40</phone>
<fax>91.24.45.41</fax>
</customers>
</dataset>

And i have database "inventory" in sql server at my desktop. and the server name is : "development\sqlexpress"
i want to import the xml data (customer.xml) into "customers" table at sql server.
can you help me with my problem?

and i want to convert data in table "customers" at sql server into xml data (customer.xml) in my vb.net mobile apllication.
please...help me...
Aug 10 '07 #1
Share this Question
Share on Google+
2 Replies


shweta123
Expert 100+
P: 692
Hi,

You can try these threads

Link1

OR

Link2
Aug 10 '07 #2

shweta123
Expert 100+
P: 692
Hi,

Sorry for last reply for posting some wrong links.
You can refer these threads

Link1
Link2


Hi,

You can try these threads

Link1

OR

Link2
Aug 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.