Reading and inserting a Xml file in sqlserver.

Question

 

Hi All,

.I want to read a xml file by the sql server which send from asp.net and passed data should be inserted in a Table which presents in SqlServer.

Example:

 

asp.net generating the xml file called - XmltblCart

Sqlserver reads the XmltblCart and insert into a table called tblCart in sqlserver.

 

I want to know,how i have to start?

Any introduction sites or articles?

 

Best Regards,

mathan

 

 

Answer 1

Mathan,

 

You can find some examples @ http://msdn.microsoft.com/en-us/library/ms971534.aspx.

 

Regards,

Galex

Answer 2

how do you pass the information from ASP.NET application to sqlserver? Are you passing it as an XML parameter? What kind of information do you exchange? I have presented an example of a sales order here: http://jacobsebastian.blogspot.com/2007/04/sales-order-workshop-articles-at.html

Answer 3

Welcome back, Jacob; I've missed you. 

Answer 4