How to save xml url into sqlserver database by asp.net

Question

hi all, I have a xml url ,hit this url open data in xml format now save this data into sqlserver table how please Help for this question. Thanks Rajveer Singh

Anil Kumar · Answer

File is looking like the output of the web service.. If it is so then you can access it using the proxy class in you client application OR use "http://www.beansoftware.com/ASP.NET-FAQ/Read-Page-HTML.aspx" to simply get the source of the file and save it in sql..

Rajveer singh · Answer

ok sir , But i face problem System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Received an unexpected EOF or 0 bytes from the transport stream. at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count) at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult) at System.Net.TlsStream.CallProcessAuthentication(Object state) at System.Threading.ExecutionContext.runTryCode(Object userData) at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result) at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.ConnectStream.WriteHeaders(Boolean async) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetResponse() at Service.SAVERTI() in c:\Users\Administrator\Desktop\RTISERVICES\App_Code\Service.cs:line 49

Rajveer singh · Answer

This Url :-http://rtionline.gov.in/webservice/website_display.php?servicecode=sfIMQjFojvyPFNy5y4u4JbrzHY9kOikC3%2F7wv1eUWLU%3D&un=Oe9nk14AhqGUGGSPv%2Fnjcb7epVva7cauUx21oOYROBw%3D&pd=HlOIa%2B%2BDDBa6ncUlpce6ehhIxvrx19iNqAlGx7gLNNYPP9NDjD2qGHUG7MuZjzAiufiiMEVt6hy5legUphkXRw%3D%3D and hit this url open data xml formate:- 1 MOIAB/R/2015/00208 nil Information, Education and Communication stategy on infant and young child feeding 19/02/2015 Physically reply https://rtionline.gov.in/webservice/viewpdf_request.php?reg=Rn%2BdzLm8DVyUZzgl29pm%2FY2l9w8792uqFsA5M6E%2BP7E%3D https://rtionline.gov.in/webservice/viewpdf_reply.php?regId=Rn%2BdzLm8DVyUZzgl29pm%2FY2l9w8792uqFsA5M6E%2BP7E%3D nil nil nil nil nil nil

Anil Kumar · Answer

Can you share the sample xml data which you want to save in sql?

Rajveer singh · Answer

But sir data come from Http url ,please i Request u please share code for this ,Please Thanks Rajveer Singh

Anil Kumar · Answer

Sql provides "XML" data type to store xml data. You can create a table in sql server with xml data type column and use it to store your xml data. Example : CREATE TABLE XmlTest( ID int NOT NULL, XmlDesc xml NOT NULL) GO Rest process in your c# code is same as you save data for other data formats Please mark this solution as accepted if it solves the purpose