import XML file in SQL Server 2008 using C#

Question

Hi, 

Actually my windows mobile 6.5 application contains a simple form, I managed to save information typed by users into an XML file using Visual C# 2008, the thing is I want to transfer that file to SQL Server 2008, what shall I use as a service, a teacher of mine told me that I may need an API to ensure the sending or the communication between my app. and the SQL Server Database.

Thanks for helping, I'm just still a rookie I found some tutorials about importing XML files into SQL Server but not for Mobile Development.

Answer 1

Hello,

You can follow these documents to import a XML file into SQL database.

http://support.microsoft.com/kb/316005
http://msdn.microsoft.com/en-us/library/ms191184.aspx

If you want to get more information about this, I would suggest you to ask help in SQL technet forum

http://social.technet.microsoft.com/Forums/en-us/category/sqlserver

Best regards,
Jesse

---

Jesse Jiang [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Thanks for your useful links, it really helps. But again I'm stuck on the web service part of it, if you know what I mean. I just need to find away how to extract my in-emulator-saved XML file. In fact my project advisor told me to use some web service in order to connect and send my xml file to my local based database which will be Developed by SQL Server.

So if there any tip to make this connection via GPRS would be much appreciated.

Answer 3

Hello,

I would suggest you to use the web service to make the communiation between mobile and service.

You can follow this document
http://msdn.microsoft.com/en-us/library/dd483215.aspx

Best regards,
Jesse

---

Jesse Jiang [MSFT]
MSDN Community Support | Feedback to us